GridView如何删除行？

[好好小妖]

GridView如何删除所选则的行的信息？

[huang_net]

菜鸟问题！！！
int id = Convert.ToInt32((this.GridView1.Rows[e.RowIndex].FindControl("Label1") as Label).Text;
string strSql = "DELETE FROM 表名 WHERE 数据库字段的Id = @id";
SqlParameter [] sqlPar = { new SqlParameter("@id",id)};
......

[insus]

参考:

http://blog.csdn.net/insus/archive/2008/03/30/2229898.aspx

[artwl_cn]

[Quote=引用 6 楼 liubaohuazy 的回复:]
<asp:GridView ID="GridView1" runat="server" OnRowCommand ="custemBut" AutoGenerateColumns ="False" AllowPaging ="True" PageSize =5 OnPageIndexChanging ="GridView1_PageIndexChanging" OnRowDataBound="GridView1_RowDataBound">

<asp:LinkButton ID="del" runat ="server" CommandName ="del" Text ="删除" CommandArgument =' <%#Eval("P_ID") %>' OnClientClick ="return confirm('确定要删除吗？');" />

…
[/Quote]
正解

[cyz9977]

delete~~

[好好小妖]

补充 是通过写代码实现数据绑定的？

[chy3503319]

删除绑定数据中的一行,然后重新绑定

[w5223336]

这个貌似很简单吧！

[正在加载昵称]

GridView启用选定 然后删除选定行--》重新绑定数据源

[liubaohuazy]

<asp:GridView ID="GridView1" runat="server" OnRowCommand ="custemBut" AutoGenerateColumns ="False" AllowPaging ="True" PageSize =5 OnPageIndexChanging ="GridView1_PageIndexChanging" OnRowDataBound="GridView1_RowDataBound">

<asp:LinkButton ID="del" runat ="server" CommandName ="del" Text ="删除" CommandArgument ='<%#Eval("P_ID") %>' OnClientClick ="return confirm('确定要删除吗？');" />

自定义custemBut()函数执行删除命令就好了

[spring1_]

delete from table where 字段='"+e.Item.Cells[列名].Text.Trim()+"'

[tengfei5200]

的确菜鸟问题
就是一个行的绑定事件

[che2piaopiao]

datekey

[Net_0mL]

加上一个checkbox 然后参考以下代码
for (int ii = 0; ii < GridView1.Rows.Count; ii++)
{
CheckBox cc = (CheckBox)GridView1.Rows[ii].Cells[0].FindControl("CheckBox1");

if (cc.Checked)
{
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:/bttc/bttcdata.mdb";
OleDbConnection conn = new OleDbConnection(strCon);
conn.Open();
string sqlstr = "select * from sw";
OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, conn);
OleDbCommandBuilder scb = new OleDbCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "sw");
DataRow dr = ds.Tables["sw"].Rows[ii];

dr.BeginEdit();
ds.Tables["sw"].Rows[ii].Delete();
da.Update(ds, "sw");
ds.Clear();
conn.Close();

}
cc.Checked =false;
this.cx.Text = "";

[Riverwcj]

先找到删除行的事件.再找到该行的ID...找到之后执行delete语句..再重新绑定GridView就可以了....

[humphrey923]

GridView有个RowDeleting事件
之后,把要删除的该行的ID得到就可以了
比如:
int uid = GridView.DataKeys[e.RowIndex].Value;

[aspnetblp]

找到gridview的删除行事件,得到删除的行的id,然后在重新绑定数据

[指间、魔法师]

GridView模板项中添加按钮；
源中代码：
<ItemTemplate>
<asp:LinkButton ID="linbtn" runat="server" CommandName="lik_del" CommandArgument='<%# Eval("Id")%>'>删除</asp:LinkButton>
</ItemTemplate>

后台：
protected void gvShow_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//删除判断
LinkButton link = e.Row.FindControl("linbtn") as LinkButton;
link.Attributes.Add("onclick", "return confirm('确定要删除?');");
}
}
protected void gvShow_RowCommand(object sender, GridViewCommandEventArgs e)
{
string butName = e.CommandName;//得到删除按钮
if (butName == "lik_del")
{
//删除方法
}
}

[renjuwht]

最简单的就是用sql数据源里面select到主键，然后点选高级，把第1个打上勾
然后出来就可以选择 自动编辑/删除按扭