SqlConnection conn;
string sqlstr = "update KuCun set ShuLiang =ShuLiang-'" + TextBox2.Text.ToString().Trim() + "' where cast(BianHao as varchar(55))='" + TextBox1.Text.ToString().Trim() + "' and cast(ChiCun as varchar(55))='" + TextBox3.Text.ToString().Trim() + "'";
string connection = ConfigurationManager.ConnectionStrings["ErpConnectionString"].ConnectionString;
conn = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand(sqlstr, conn);
conn.Open();
cmd.ExecuteNonQuery();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货