DataGrid的修改、删除

最新推荐文章于 2021-10-12 16:00:20 发布

iCOLIN

最新推荐文章于 2021-10-12 16:00:20 发布

阅读量1.3k

点赞数

分类专栏：编程心得文章标签： datagrid textbox sql database string javascript

编程心得专栏收录该内容

18 篇文章 0 订阅

订阅专栏

DataGrid的修改、删除

删除确认:
<div id="de" οnclick="javascript :return confirm('是否删除')">删除</div>

删除:
         string sql;
         int bianhao;
         bianhao=Convert.ToInt32(e.Item.Cells[0].Text);
         sql="delete from my where job_id=" + bianhao ;
         Label1.Text=sql;
         SqlConnection con=new SqlConnection();
         con.ConnectionString="server=(local);user id=sa ;pwd=sa ; database=pubs";
         con.Open();
         SqlCommand cmd=new SqlCommand();
         cmd.CommandText=sql;
         cmd.Connection=con;
         cmd.ExecuteNonQuery();
         cmd.Dispose();
         con.Close();
         DataGrid1.EditItemIndex=-1;
         bind();

修改:
         string sql;
         string bianhao,dizhi;
         bianhao=e.Item.Cells[0].Text;
         TextBox newtxt=(TextBox)e.Item.Cells[3].Controls[0];
         dizhi=newtxt.Text;

//dizhi=DataGrid1.DataKesy[e.Item.ItemIndex];
         sql="update authors set address='" + dizhi + "' where au_id='" + bianhao + "'";
         SqlConnection con=new SqlConnection();
         con.ConnectionString="server=(local);user id=sa ;pwd=sa ; database=pubs";
         con.Open();
         SqlCommand cmd=new SqlCommand();
         cmd.CommandText=sql;
         cmd.Connection=con;
         cmd.ExecuteNonQuery();
         cmd.Dispose();
         con.Close();
         DataGrid1.EditItemIndex=-1;
         bind();