请问在datagaid中删除数据?!
使用.net中自带的datagaid控件中的删除命令!
如何删除?
原来代码如下:private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
SqlConnection MyConnection = new SqlConnection("server=GY;database=bbs;Trusted_Connection=yes");
string DeleteCmd = "DELETE FROM text where t_no = 5";
SqlCommand MyCommand = new SqlCommand(DeleteCmd, MyConnection);
//MyCommand.Parameters.Add(new SqlParameter("@Uid", SqlDbType.NChar, 4));
//MyCommand.Parameters["@Uid"].Value = DataGrid1.DataKeys[e.Item.ItemIndex];
MyCommand.Connection.Open();
try
{
MyCommand.ExecuteNonQuery();
//Message.Text = "数据记录已经成功删除";
}
catch (SqlException)
{
//Message.Text = "错误: 无法删除数据纪录";
}
MyCommand.Connection.Close();
BindGridToSource();
}
问题点数:20、回复次数:0Top




