新手求解答


sqlconnection conn = new SqlConnection("server=.;database=db_HHMS;uid=sa;pwd=");
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into tb_TenantSource");
            strSql.Append("values(");
            strSql.Append("'" + 
                ConNum_tBox.Text.Trim().ToString() + "',");
            strSql.Append("'" +
                ClientName_tBox.Text.Trim().ToString() + "',");
            strSql.Append("'" +
                ClientNum_tBox.Text.Trim().ToString() + "',");
            strSql.Append("'" +
                PlaceRequire_tBox.Text.Trim().ToString() + "',");
            strSql.Append("'" +
                RentRequire_tBox.Text.Trim().ToString() + "',");
            strSql.Append("'" +
                TypeRequire_tBox.Text.Trim().ToString() + "',");
            strSql.Append("'" +
                FloorRequire_tBox.Text.Trim().ToString() + "',");
            strSql.Append("'" +
                Consignor_tBox.Text.Trim().ToString() + "'");
            strSql.Append(")");
            using (SqlCommand cmd = new SqlCommand(strSql.ToString(), conn))
            {
                conn.Open();
                cmd.ExecuteNonQuery();//此处有sqlException异常,是怎么回事？？
                conn.Close();
                conn.Dispose();
            }