亲们,帮我看看到底怎么了??感激不尽!
/asp:CommandField
后台代码
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string str = "delete from MANAGER where USERID='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
SqlConnection conn = new SqlConnection("server=localhost;integrated security=true;database=opinion");
conn.Open();
SqlCommand comm = new SqlCommand(str, conn);
comm.ExecuteNonQuery();
conn.Close();
bind();
}
//绑定
public void bind()
{
string str = "server=localhost;integrated security=true;database=opinion";
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlCommand comm = new SqlCommand("select * from MANAGER", conn);
SqlDataAdapter adapter = new SqlDataAdapter(comm);
DataSet dataset1 = new DataSet();
adapter.Fill(dataset1);
GridView1.DataSource = dataset1.Tables[0].DefaultView;
GridView1.DataSource = dataset1.Tables[0].DefaultView;
GridView1.DataKeyNames = new string[] { "USERID" };
Page.DataBind();
}