要求用 HpyerLink 传参数(WebFrom1.aspx?id={0}) 实现删除功能 //newsid = Request.Params["id"];
string newsid ="136";
sel="delete from aa WHERE id="+newsid;
sqlCommand1=new System.Data.SqlClient.SqlCommand (sel,sqlConnection1);
sqlCommand1.Connection.Open();
sqlCommand1.ExecuteNonQuery();
sqlCommand1.Connection.Close(); sqlDataAdapter1.Fill(dataSet11);
dataGrid1.DataBind();
Response.Write ("<script>window.open('WebForm1.aspx')</script>");会出现死循环 打开无数见面 请大虾们帮帮 改一改啊
datagrid属性里的按钮列和模板列 的选择 更新 删除按钮怎么使用的
要求代码写 在 *.aspx.cs 的文件里 和Html 语言分开 谢谢
string newsid ="136";
sel="delete from aa WHERE id="+newsid;
sqlCommand1=new System.Data.SqlClient.SqlCommand (sel,sqlConnection1);
sqlCommand1.Connection.Open();
sqlCommand1.ExecuteNonQuery();
sqlCommand1.Connection.Close(); sqlDataAdapter1.Fill(dataSet11);
dataGrid1.DataBind();
Response.Write ("<script>window.open('WebForm1.aspx')</script>");会出现死循环 打开无数见面 请大虾们帮帮 改一改啊
datagrid属性里的按钮列和模板列 的选择 更新 删除按钮怎么使用的
要求代码写 在 *.aspx.cs 的文件里 和Html 语言分开 谢谢
string newsid ="136";
sel="delete from aa WHERE id="+newsid;
sqlCommand1=new System.Data.SqlClient.SqlCommand (sel,sqlConnection1);
sqlCommand1.Connection.Open();
sqlCommand1.ExecuteNonQuery();
sqlCommand1.Connection.Close(); sqlDataAdapter1.Fill(dataSet11);
dataGrid1.DataBind();
Response.Write ("<script>window.open('WebForm1.aspx')</script>");会出现死循环 打开无数见面 请大虾们帮帮 改一改啊
datagrid属性里的按钮列和模板列 的选择 更新 删除按钮怎么使用的
要求代码写 在 *.aspx.cs 的文件里 和Html 语言分开 谢谢
我的代码是
删除 删不掉
string keyValue;
keyValue=(string) dataGrid1.DataKeys [(inte.Item .ItemIndex]; sel="delete from aa WHERE id="+keyValue;
sqlCommand1=new System.Data.SqlClient.SqlCommand (sel,sqlConnection1);
sqlCommand1.Connection.Open();
sqlCommand1.ExecuteNonQuery();
sqlCommand1.Connection.Close();
sqlDataAdapter1.Fill(dataSet11,"aa");
dataGrid1.DataSource =dataSet161.Tables ["aa"].DefaultView ;
dataGrid1.DataBind();
查询没结果 也不报错
string sel="SELECT * FROM aa ORDER BY id DESC";
sqlDataAdapter1=new System.Data.SqlClient.SqlDataAdapter (sel,sqlConnection1);
dataSet11=new DataSet1 ();
sqlDataAdapter1.Fill (dataSet11,"aa");sel="SELECT * FROM aa where "+DropDownList1.SelectedItem .Value +" like '% "+ table1.Text .ToString ()+" % '";
sqlDataAdapter1=new System.Data.SqlClient.SqlDataAdapter (sel,sqlConnection1);
dataSet11=new DataSet1 ();
sqlDataAdapter1.Fill (dataSet11,"aa");
dataGrid1.DataSource =dataSet11.Tables ["aa"].DefaultView ;
dataGrid1.DataBind ();
高手帮帮忙 我都忙了一整天都没有 ,搞出来,加分
我的代码是
删除 删不掉
string keyValue;
keyValue=(string) dataGrid1.DataKeys [(inte.Item .ItemIndex]; sel="delete from aa WHERE id="+keyValue;
sqlCommand1=new System.Data.SqlClient.SqlCommand (sel,sqlConnection1);
sqlCommand1.Connection.Open();
sqlCommand1.ExecuteNonQuery();
sqlCommand1.Connection.Close();
sqlDataAdapter1.Fill(dataSet11,"aa");
dataGrid1.DataSource =dataSet11.Tables ["aa"].DefaultView ;
dataGrid1.DataBind();
查询没结果 也不报错
string sel="SELECT * FROM aa ORDER BY id DESC";
sqlDataAdapter1=new System.Data.SqlClient.SqlDataAdapter (sel,sqlConnection1);
dataSet11=new DataSet1 ();
sqlDataAdapter1.Fill (dataSet11,"aa");sel="SELECT * FROM aa where "+DropDownList1.SelectedItem .Value +" like '% "+ table1.Text .ToString ()+" % '";
sqlDataAdapter1=new System.Data.SqlClient.SqlDataAdapter (sel,sqlConnection1);
dataSet11=new DataSet1 ();
sqlDataAdapter1.Fill (dataSet11,"aa");
dataGrid1.DataSource =dataSet11.Tables ["aa"].DefaultView ;
dataGrid1.DataBind ();
高手帮帮忙 我都忙了一整天都没有 ,搞出来,加分
我的代码是
删除 删不掉
string keyValue;
keyValue=(string) dataGrid1.DataKeys [(int)e.Item .ItemIndex]; sel="delete from aa WHERE id="+keyValue;
sqlCommand1=new System.Data.SqlClient.SqlCommand (sel,sqlConnection1);
sqlCommand1.Connection.Open();
sqlCommand1.ExecuteNonQuery();
sqlCommand1.Connection.Close();
sqlDataAdapter1.Fill(dataSet11,"aa");
dataGrid1.DataSource =dataSet161.Tables ["aa"].DefaultView ;
dataGrid1.DataBind();
查询没结果 也不报错
string sel="SELECT * FROM aa ORDER BY id DESC";
sqlDataAdapter1=new System.Data.SqlClient.SqlDataAdapter (sel,sqlConnection1);
dataSet11=new DataSet1 ();
sqlDataAdapter1.Fill (dataSet11,"aa");sel="SELECT * FROM aa where "+DropDownList1.SelectedItem .Value +" like '% "+ table1.Text .ToString ()+" % '";
sqlDataAdapter1=new System.Data.SqlClient.SqlDataAdapter (sel,sqlConnection1);
dataSet11=new DataSet1 ();
sqlDataAdapter1.Fill (dataSet11,"aa");
dataGrid1.DataSource =dataSet11.Tables ["aa"].DefaultView ;
dataGrid1.DataBind ();
高手帮帮忙 我都忙了一整天都没有 ,搞出来,加分