刚才那不全,全部的如下:http://chs.gotdotnet.com/quickstart/util/srcview.aspx?path=/quickstart/aspplus/samples/webforms/data/datagrid10.src
上有:
protected void Page_Load(Object sender, EventArgs e)
{
myConnection = new SqlConnection("server=(local);database=pubs;Trusted_Connection=yes"); if (!IsPostBack)
BindGrid();
} public void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs e)
{
String deleteCmd = "DELETE from aa where emp_id = @Id"; SqlCommand myCommand = new SqlCommand(deleteCmd, myConnection);
myCommand.Parameters.Add(new SqlParameter("@Id", SqlDbType.NChar, 3));
myCommand.Parameters["@Id"].Value = MyDataGrid.DataKeys[(int)e.Item.ItemIndex]; myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
Message.InnerHtml = "<b>已删除记录</b><br>" +  MyDataGrid.DataKeys[(int)e.Item.ItemIndex];


}
catch (SqlException)
{
Message.InnerHtml = "错误:未能删除记录";
Message.Style["color"] = "red";
} myCommand.Connection.Close(); BindGrid();
} public void BindGrid()
{
SqlDataAdapter myCommand = new SqlDataAdapter("select * from aa", myConnection); DataSet ds = new DataSet();
myCommand.Fill(ds, "aa"); MyDataGrid.DataSource=ds.Tables["aa"].DefaultView;
MyDataGrid.DataBind();
}
}