程序有一千多行,先贴出UpdateCommand 的commandtext,都是系统自动生成的,感觉奇怪怎么会有这么多where且每个where的字段名前面都有一个Original不知道为何物,我的sqlconnection,SqlDataAdapter,DataSet都用数据庫控件做的(新手)。// // sqlUpdateCommand1 // this.sqlUpdateCommand1.CommandText = "UPDATE verify SET bill_type = @bill_type, bill_no = @bill_no, asset_no = @asset_n" + "o, merch_type = @merch_type, project = @project, bill_date = @bill_date, name = " + "@name, estate_part = @estate_part, status = @status, dep_meath = @dep_meath, dep" + "t = @dept, dep_money = @dep_money, year_money = @year_money, dep_add = @dep_add," + " insurance = @insurance, record = @record, k11_97 = @k11_97, pri_qty = @pri_qty," + " pri_money = @pri_money, pri_resid = @pri_resid, price = @price, now_qty = @now_" + "qty, now_money = @now_money, now_resid = @now_resid, dep_date = @dep_date, user_" + "year = @user_year, dep_rat = @dep_rat WHERE (v_no = @Original_v_no) AND (asset_n" + "o = @Original_asset_no OR @Original_asset_no IS NULL AND asset_no IS NULL) AND (" + "bill_date = @Original_bill_date OR @Original_bill_date IS NULL AND bill_date IS " + "NULL) AND (bill_no = @Original_bill_no OR @Original_bill_no IS NULL AND bill_no " + "IS NULL) AND (bill_type = @Original_bill_type OR @Original_bill_type IS NULL AND" + " bill_type IS NULL) AND (dep_add = @Original_dep_add OR @Original_dep_add IS NUL" + "L AND dep_add IS NULL) AND (dep_date = @Original_dep_date OR @Original_dep_date " + "IS NULL AND dep_date IS NULL) AND (dep_meath = @Original_dep_meath OR @Original_" + "dep_meath IS NULL AND dep_meath IS NULL) AND (dep_money = @Original_dep_money OR" + " @Original_dep_money IS NULL AND dep_money IS NULL) AND (dep_rat = @Original_dep" + "_rat OR @Original_dep_rat IS NULL AND dep_rat IS NULL) AND (dept = @Original_dep" + "t OR @Original_dept IS NULL AND dept IS NULL) AND (estate_part = @Original_estat" + "e_part OR @Original_estate_part IS NULL AND estate_part IS NULL) AND (insurance " + "= @Original_insurance OR @Original_insurance IS NULL AND insurance IS NULL) AND " + "(k11_97 = @Original_k11_97 OR @Original_k11_97 IS NULL AND k11_97 IS NULL) AND (" + "merch_type = @Original_merch_type OR @Original_merch_type IS NULL AND merch_type" + " IS NULL) AND (name = @Original_name OR @Original_name IS NULL AND name IS NULL)" + " AND (now_money = @Original_now_money OR @Original_now_money IS NULL AND now_mon" + "ey IS NULL) AND (now_qty = @Original_now_qty OR @Original_now_qty IS NULL AND no" + "w_qty IS NULL) AND (now_resid = @Original_now_resid OR @Original_now_resid IS NU" + "LL AND now_resid IS NULL) AND (pri_money = @Original_pri_money OR @Original_pri_" + "money IS NULL AND pri_money IS NULL) AND (pri_qty = @Original_pri_qty OR @Origin" + "al_pri_qty IS NULL AND pri_qty IS NULL) AND (pri_resid = @Original_pri_resid OR " + "@Original_pri_resid IS NULL AND pri_resid IS NULL) AND (price = @Original_price " + "OR @Original_price IS NULL AND price IS NULL) AND (project = @Original_project O" + "R @Original_project IS NULL AND project IS NULL) AND (record = @Original_record " + "OR @Original_record IS NULL AND record IS NULL) AND (status = @Original_status O" + "R @Original_status IS NULL AND status IS NULL) AND (user_year = @Original_user_y" + "ear OR @Original_user_year IS NULL AND user_year IS NULL) AND (year_money = @Ori" + "ginal_year_money OR @Original_year_money IS NULL AND year_money IS NULL); SELECT" + " v_no, bill_type, bill_no, asset_no, merch_type, project, bill_date, name, estat" + "e_part, status, dep_meath, dept, dep_money, year_money, dep_add, insurance, reco" + "rd, k11_97, pri_qty, pri_money, pri_resid, price, now_qty, now_money, now_resid," + " dep_date, user_year, dep_rat FROM verify WHERE (v_no = @v_no)";
我估计可能是程序上下连接的地方出了问题
要不就看看comcb的UpdateCommand 的commandtext
这句话多余。
this.sqlDataAdapter1 .UpdateCommand =comcb.GetUpdateCommand ();
sqlDataAdapter1.UpdateCommand.CommandText=“sql 语句";
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = "UPDATE verify SET bill_type = @bill_type, bill_no = @bill_no, asset_no = @asset_n" +
"o, merch_type = @merch_type, project = @project, bill_date = @bill_date, name = " +
"@name, estate_part = @estate_part, status = @status, dep_meath = @dep_meath, dep" +
"t = @dept, dep_money = @dep_money, year_money = @year_money, dep_add = @dep_add," +
" insurance = @insurance, record = @record, k11_97 = @k11_97, pri_qty = @pri_qty," +
" pri_money = @pri_money, pri_resid = @pri_resid, price = @price, now_qty = @now_" +
"qty, now_money = @now_money, now_resid = @now_resid, dep_date = @dep_date, user_" +
"year = @user_year, dep_rat = @dep_rat WHERE (v_no = @Original_v_no) AND (asset_n" +
"o = @Original_asset_no OR @Original_asset_no IS NULL AND asset_no IS NULL) AND (" +
"bill_date = @Original_bill_date OR @Original_bill_date IS NULL AND bill_date IS " +
"NULL) AND (bill_no = @Original_bill_no OR @Original_bill_no IS NULL AND bill_no " +
"IS NULL) AND (bill_type = @Original_bill_type OR @Original_bill_type IS NULL AND" +
" bill_type IS NULL) AND (dep_add = @Original_dep_add OR @Original_dep_add IS NUL" +
"L AND dep_add IS NULL) AND (dep_date = @Original_dep_date OR @Original_dep_date " +
"IS NULL AND dep_date IS NULL) AND (dep_meath = @Original_dep_meath OR @Original_" +
"dep_meath IS NULL AND dep_meath IS NULL) AND (dep_money = @Original_dep_money OR" +
" @Original_dep_money IS NULL AND dep_money IS NULL) AND (dep_rat = @Original_dep" +
"_rat OR @Original_dep_rat IS NULL AND dep_rat IS NULL) AND (dept = @Original_dep" +
"t OR @Original_dept IS NULL AND dept IS NULL) AND (estate_part = @Original_estat" +
"e_part OR @Original_estate_part IS NULL AND estate_part IS NULL) AND (insurance " +
"= @Original_insurance OR @Original_insurance IS NULL AND insurance IS NULL) AND " +
"(k11_97 = @Original_k11_97 OR @Original_k11_97 IS NULL AND k11_97 IS NULL) AND (" +
"merch_type = @Original_merch_type OR @Original_merch_type IS NULL AND merch_type" +
" IS NULL) AND (name = @Original_name OR @Original_name IS NULL AND name IS NULL)" +
" AND (now_money = @Original_now_money OR @Original_now_money IS NULL AND now_mon" +
"ey IS NULL) AND (now_qty = @Original_now_qty OR @Original_now_qty IS NULL AND no" +
"w_qty IS NULL) AND (now_resid = @Original_now_resid OR @Original_now_resid IS NU" +
"LL AND now_resid IS NULL) AND (pri_money = @Original_pri_money OR @Original_pri_" +
"money IS NULL AND pri_money IS NULL) AND (pri_qty = @Original_pri_qty OR @Origin" +
"al_pri_qty IS NULL AND pri_qty IS NULL) AND (pri_resid = @Original_pri_resid OR " +
"@Original_pri_resid IS NULL AND pri_resid IS NULL) AND (price = @Original_price " +
"OR @Original_price IS NULL AND price IS NULL) AND (project = @Original_project O" +
"R @Original_project IS NULL AND project IS NULL) AND (record = @Original_record " +
"OR @Original_record IS NULL AND record IS NULL) AND (status = @Original_status O" +
"R @Original_status IS NULL AND status IS NULL) AND (user_year = @Original_user_y" +
"ear OR @Original_user_year IS NULL AND user_year IS NULL) AND (year_money = @Ori" +
"ginal_year_money OR @Original_year_money IS NULL AND year_money IS NULL); SELECT" +
" v_no, bill_type, bill_no, asset_no, merch_type, project, bill_date, name, estat" +
"e_part, status, dep_meath, dept, dep_money, year_money, dep_add, insurance, reco" +
"rd, k11_97, pri_qty, pri_money, pri_resid, price, now_qty, now_money, now_resid," +
" dep_date, user_year, dep_rat FROM verify WHERE (v_no = @v_no)";