我的问题都已经好几天，还未解决？

[jiajia1]

请各位高手帮我检查代码的错误。谢谢！

public void DataGrid1_Delete(Object sender, DataGridCommandEventArgs e)
{
string deleteCmd = "DELETE from qw where q1 = @q1";

SqlCommand sqlCommand1 = new SqlCommand(deleteCmd,sqlConnection1);
sqlCommand1.Parameters.Add(new SqlParameter("@q1", SqlDbType.Char, 6));
sqlCommand1.Parameters["@q1"].Value =DataGrid1.DataKeys[(int)e.Item.ItemIndex];

sqlCommand1.Connection.Open();

sqlCommand1.ExecuteNonQuery();

sqlCommand1.Connection.Close();

Bindgrid();
}//public void DataGrid1_Delete(Object sender, DataGridCommandEventArgs e)

//string deleteCmd = "DELETE from qw where q1=@q1 ";
//SqlCommand sqlCommand1 = new SqlCommand(deleteCmd, sqlConnection1);
//sqlCommand1.Parameters.Add(new SqlParameter("@q1", SqlDbType.Char,6));
　　//sqlCommand1.Parameters["@q1"].Value = DataGrid1.Columns .ToString ();
//sqlCommand1.Connection.Open();

//int id=DataGrid1.SelectedIndex;
//string q11=this.DataGrid1.DataKeys[(int)id+1].ToString();
//.Item.Cells[1].Text;
//string sqlstr="delete from qw where q1="+"'"+q11+"'";
//sqlConnection1.Open();
//System.Data.SqlClient.SqlCommand sqlDeleteCommand2=new System.Data.SqlClient.SqlCommand(sqlstr,sqlConnection1);
//sqlDeleteCommand2.ExecuteNonQuery();
//sqlConnection1.Close();

//String deleteCmd = "DELETE FROM qw WHERE q1 d='"+datagrid.DataKeys[i].ToString()+"'";
//SqlCommand sqlCommand1 = new SqlCommand(deleteCmd, sqlConnection1);
//sqlCommand1.Parameters.Add(new SqlParameter("@q1",
//sqlDbType.Char, 6));
// Initialize the SqlCommand "@Id" parameter to the ID of the row
// that was clicked.

//sqlCommand1.Parameters["@q1"].Value =
//DataGrid1.DataKeys[(int)e.Item.ItemIndex];
// Connect to the database and delete the specified row.
//sqlCommand1.Connection.Open();
// Test whether the delete was accomplished and display the
// appropriate message to the user.

//sqlCommand1.ExecuteNonQuery();






//private void Button5_click(object sender, System.Web.UI.WebControls.DataGridCommand.EventArgs e)

//this. sqlDeleteCommand2.Parameters["@q1"].Value=this.TextBox5.Text.ToString();
//string sqlstr="delete from qw where q1=@q1";
//sqlConnection1.Open();
//System.Data.SqlClient.SqlCommand sqlDeleteCommand2=new System.Data.SqlClient.SqlCommand(sqlstr,sqlConnection1);
//sqlDeleteCommand2.ExecuteNonQuery();
//sqlConnection1.Close();



//private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

// int delRow=e.Item.ItemIndex; //获取删除列
// this.dataSet11.q1.Rows[delRow].Delete();//在数据集中删除数据
// this.sqlDataAdapter1.Update(this.dataSet11);//将数据集更改提交到数据库
// this.DataGrid1.DataBind();//刷新DataGrid

[erictang2003]

错误提示是什么?

[jiajia1]

没有提示，但不能达到效果，不能删除

[erictang2003]

我想最大可能是:
DataGrid 没有制定 DataKeyField !

<ASP:DataGrid id="MyDataGrid" runat="server"
Width="800"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
DataKeyField="emp_id" //-----------------------------important!
OnDeleteCommand="MyDataGrid_Delete"
>

[jiajia1]

我已经制定 DataKeyField ，但我想不通，为什么？

[jiajia1]

我已经制定 DataKeyField ，但我想不通，为什么我点击删除时，没有反映，也不会出错。查了库中的数据，也没删除。请教高手们。

[xzgtysx]

你好象没有使用update()

[jiajia1]

我是用DELETE，删除啊！

[erictang2003]

1) sqlCommand1.Parameters.Add(new SqlParameter("@q1", SqlDbType.Char,6));
q1 字段的TYPE 是Char 吗?

2) Try : sqlCommand1.Parameters["@q1"].Value =DataGrid1.DataKeys[(int)e.Item.ItemIndex].ToString() ;

[jiajia1]

q1 字段的TYPE 是Char

[jiajia1]

注释部分，我已调试。也有sqlCommand1.Parameters["@q1"].Value =DataGrid1.DataKeys[(int)e.Item.ItemIndex].ToString() ;这句

[pengweihua]

此為設計工具支援所必需的方法

[jiajia1]

怎么没人回答我的问题.......

[pengweihua]

把它改一下：
private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
switch(e.CommandName)
{
case "Delete":
//增加你的刪除代碼;
break;

}

}

[pengweihua]

private void InitializeComponent()
{
this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
this.Load += new System.EventHandler(this.Page_Load);

}
add:

this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);

[jiajia1]

能具体一点吗？

[pengweihua]

private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
switch(e.CommandName)
{
case "Delete":
string deleteCmd = "DELETE from qw where q1 = @q1";

SqlCommand sqlCommand1 = new SqlCommand(deleteCmd,sqlConnection1);
sqlCommand1.Parameters.Add(new SqlParameter("@q1", SqlDbType.Char, 6));
sqlCommand1.Parameters["@q1"].Value =DataGrid1.DataKeys[(int)e.Item.ItemIndex];

sqlCommand1.Connection.Open();

sqlCommand1.ExecuteNonQuery();

sqlCommand1.Connection.Close();

Bindgrid();
break;

}

}

然後在這裡面加上這句話this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);

private void InitializeComponent()
{
........
}


即：

private void InitializeComponent()
{
........
this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
。。。。。
}

[jiajia1]

多谢了，private void InitializeComponent()
{
........
this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
。。。。。
}

InitializeComponent是什么意思？
因为我是初学者，请多多赐教。

[jiajia1]

why????

[jiajia1]

我调试过你给我的代码，但还是没实现。但也没有提示错误信息。