在線等，，以下多選刪除報錯，

[shixianyong]

將 varchar 數值 'GridView1.DataKeys[gvr.DataItemIndex].Value' 轉換成資料型別為 int 的資料行語法錯誤。

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string connStr = ConfigurationManager.ConnectionStrings["BTS"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
DataSet ds = new DataSet();
SqlCommand comm = new SqlCommand();
SqlDataAdapter sqlad = new SqlDataAdapter();
comm.Connection = conn;
comm.CommandText = "select * from bts";
sqlad.SelectCommand = comm;
//Response.Write(sqlad.SelectCommand.CommandText);
sqlad.Fill(ds, "bts");
GridView1.DataSource = ds.Tables["bts"];
GridView1.DataBind();
}
}
protected void Button3_Click(object sender, EventArgs e)
{
foreach (GridViewRow gvr in GridView1.Rows)
{
CheckBox ch = (CheckBox)gvr.FindControl("ItemCheckBox");
if (ch.Checked)
{
//Ret2.Text += "<li>GridView1 您选择的是（键值）：" + GridView1.DataKeys[gvr.DataItemIndex].Value.ToString();
string connStr = ConfigurationManager.ConnectionStrings["BTS"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
DataSet ds = new DataSet();
SqlCommand comm = new SqlCommand();
SqlDataAdapter sqlad = new SqlDataAdapter();
string sql;
sql = "delete from bts where au_id= 'GridView1.DataKeys[gvr.DataItemIndex].Value'";
comm.Connection = conn;
comm.CommandText = sql;
comm.ExecuteNonQuery();

}
}
}

protected void CheckAll(object sender, EventArgs e)
{
CheckBox cbx = (CheckBox)sender;
foreach (GridViewRow gvr in GridView1.Rows)
{
CheckBox ch = (CheckBox)gvr.FindControl("ItemCheckBox");
ch.Checked = cbx.Checked;
}
}

[usxue]

GridView1.DataKeys[gvr.DataItemIndex].Value的值是多少？

[zhenjiaobing]

SF.

[usxue]

而且在你删除数据的时候，为啥还要定义：
DataSet ds = new DataSet();
SqlDataAdapter sqlad = new SqlDataAdapter();
？？？？？

[jobine]

sql = "delete from bts where au_id= '" + GridView1.DataKeys[gvr.DataItemIndex].Value.ToString() + "'";

[wuhan_dotnet]

能直接获取? GridView1.DataKeys[gvr.DataItemIndex].Value.ToString();

不需要强转?((DataKey)GridView1.DataKeys[gvr.DataItemIndex]).Value.ToString(); 这样吧```

[songle912]

真是

[songle912]

sql = "delete from bts where au_id= 'GridView1.DataKeys[gvr.DataItemIndex].Value'";
额滴娘亲呀，这样怎么可以
GridView1.DataKeys[gvr.DataItemIndex].Value用加号链接起来
不然你的au_id不是永远等于‘'GridView1.DataKeys[gvr.DataItemIndex].Value'’这个字符串吗？？

[sendling]

sql = "delete from bts where au_id= “+ int.Parse（GridView1.DataKeys[gvr.DataItemIndex].Value）+“"; 试下

[belldandy11]

sql = "delete from bts where au_id= 'GridView1.DataKeys[gvr.DataItemIndex].Value'";

大哥 好歹也5个裤头了........别告诉我不知道怎么改了哈

[yan53125]

是真裤衩么..穿那么多了

[icefeiji]

单步跟踪下，看看值到底是多少，不就清楚了么~

[BearRui]

try:

GridView1.DataKeys[gvr.DataItemIndex][0].ToString();

[foxfab]

...............................................................................................................................................................................................................................................................................

[freeboy827]

调试一下就解决了，好歹也那么多裤衩