update的sql语句

string strSql = string.Format("insert into k_rygl values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", txtBox1.Text.Trim(), txtBox2.Text.Trim(), TextBox3.Text.Trim(), drp1.Text, drp2.Text, textBox7.Text.Trim(), gwString);

string strSql = string.Format("update k_rygl set rygl_xm='{0}',rygl_mm='{1}',rygl_fzmc='{2}',rygl_qx='{3}',rygl_bz='{4}',rygl_gw='{5}' where rygl_id = '{6}'", txtBox2.Text.Trim(), TextBox3.Text.Trim(), drp1.Text, drp2.Text, textBox7.Text.Trim(), gwString, txtBox1.Text.Trim());

原文地址:https://www.cnblogs.com/jcomet/p/1281730.html