怎样对datagrid里的数据进行删除功能的编写?

dim cmd as new adodb.command
取出datagrid里的内容
dim str as string
str = datagrid.text //取出相应的值
然后用cmd执行相应的删除语句就可以了

//用与删除的方法
private void DataGridSql(string strSql)
{
string strCon = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
SqlConnection con = new SqlConnection(strCon);
con.Open();
SqlCommand cmd = new SqlCommand(strSql,con);
cmd.ExecuteNonQuery();
con.Close();

}
//删除
private void dg_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
//判断是不是只有一条记录
if(this.dg.Items.Count == 1)
{
//判断是否是第一页
if(this.dg.CurrentPageIndex != 0)
{
//向前翻一页
this.dg.CurrentPageIndex = this.dg.CurrentPageIndex-1;
}
}
string strDel = "delete from Users where StuId="+this.dg.DataKeys[(int)e.Item.ItemIndex]+"";