foreach (GridViewRow row in this.GridView1.Rows)
{
CheckBox c = row.FindControl("CheckBox1") as CheckBox;
if (c != null && c.Checked &&)
{
}
}目前我的button控件是用这个语句来判定选中行触发事件!但是我的主键属性是设置为Identity的!要怎么才能让sql语句里面绑定主键呢??具体主键绑定代码应该怎么写??请各位大大不吝赐教!!
{
CheckBox c = row.FindControl("CheckBox1") as CheckBox;
if (c != null && c.Checked &&)
{
}
}目前我的button控件是用这个语句来判定选中行触发事件!但是我的主键属性是设置为Identity的!要怎么才能让sql语句里面绑定主键呢??具体主键绑定代码应该怎么写??请各位大大不吝赐教!!
<ItemTemplate>
<tr>
<td style=" height: 30px; text-align:center;"><%# DataBinder.Eval(Container.DataItem,"id") %></td>
<td ><%# DataBinder.Eval(Container.DataItem,"productName") %></td>
<td style="text-align:center;"><%# DataBinder.Eval(Container.DataItem, "ProductMoney").ToString().Substring(0,DataBinder.Eval(Container.DataItem, "ProductMoney").ToString().Length - 2) %></td>
<td style="text-align:center; "><%# DataBinder.Eval(Container.DataItem,"hot") %></td>
<td style="text-align:center;">
<asp:LinkButton ID="LinkButton1" runat="server" CommandName="update" CommandArgument='<%# DataBinder.Eval(Container.DataItem,"id") %>'>修改</asp:LinkButton></td>
<td style="text-align:center;">
<asp:LinkButton ID="LinkButton2" runat="server" CommandName="del" CommandArgument='<%# DataBinder.Eval(Container.DataItem,"id") %>' OnClientClick="return confirm('是否真的要删除?')" >删除</asp:LinkButton></td>
</tr>
</ItemTemplate>
</asp:Repeater>
Product pd1;
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string commandname = e.CommandName;
string commandagument = e.CommandArgument.ToString();
if (commandname.Equals("del"))
{
string sql = "UPDATE [syData].[dbo].[Product] SET [visible] = 'off' WHERE id=" + Convert.ToInt32(commandagument);
DbSQL.ExecuteSql(sql);
inData();
}
}