常用的sql语句

来源:互联网 发布:淘宝要绑定身份证号 编辑:程序博客网 时间:2024/06/01 18:07

delete from st where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"

string sqlStr = "select * from st  where  id =''  ";

  string commdstr = "insert into st(id,name,date,action) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "')";  

update st set id='" + id + "', name='" + name + "' , date='" + date + "' , action='" + action + "'  where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"


原创粉丝点击