2023年6月21日发(作者：)

SqlParameter数组添加protected void Button1_Click(object sender, EventArgs e) { string strSql="insert into Invoice_Rebate_Customer_L (FORM_ID,LINE_NO) values (@formNo,@lineNo)";

SqlParameter[] paras =new SqlParameter[2]; paras[0] = new SqlParameter("@formNo", ar); paras[0].Value = "88888"; paras[1] = new SqlParameter("@lineNo", ); paras[1].Value = 8; ExecuteSql(strSql, paras, );

} void ExecuteSql(string strSql,SqlParameter[] paras,CommandType cmdType) { SqlConnection con = new SqlConnection("Server=aukm2;Database=BU;UID=buuser;PWD=buinfo"); (); SqlCommand cmd = new SqlCommand(); tion = con; dType = cmdType; dText = strSql;

foreach (SqlParameter p in paras) { (p); } eNonQuery(); (); }

2023年6月21日发(作者：)

SqlParameter数组添加protected void Button1_Click(object sender, EventArgs e) { string strSql="insert into Invoice_Rebate_Customer_L (FORM_ID,LINE_NO) values (@formNo,@lineNo)";

SqlParameter[] paras =new SqlParameter[2]; paras[0] = new SqlParameter("@formNo", ar); paras[0].Value = "88888"; paras[1] = new SqlParameter("@lineNo", ); paras[1].Value = 8; ExecuteSql(strSql, paras, );

} void ExecuteSql(string strSql,SqlParameter[] paras,CommandType cmdType) { SqlConnection con = new SqlConnection("Server=aukm2;Database=BU;UID=buuser;PWD=buinfo"); (); SqlCommand cmd = new SqlCommand(); tion = con; dType = cmdType; dText = strSql;

foreach (SqlParameter p in paras) { (p); } eNonQuery(); (); }