<asp:GridView ID="dgResult" runat="server"
AutoGenerateColumns="False" DataKeyNames="PKID" Width="100%" onrwcommand="dgResult_RowCommand" >
<HeaderStyle HorizontalAlign="Center" />
<Columns>
<asp:TemplateField ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="16">
<HeaderTemplate>
<input id="chkAll" onclick="CheckAll()" type="checkbox" />
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" />
</ItemTemplate>
<HeaderStyle Width="16px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:TemplateField>
<asp:BoundField DataField="ProductsName" SortExpression="ProductName" HeaderText="产品名称"
ItemStyle-Width="320" ItemStyle-HorizontalAlign="center">
<ItemStyle HorizontalAlign="Center" Width="8%"></ItemStyle>
</asp:BoundField>
<asp:TemplateField HeaderText="图片" ItemStyle-Width="140">
<ItemTemplate>
<img src='../ProductsUrl/<%#Eval("ProductsUrl")%>' onerror="this.src='/images/nogoods120.gif'" width="140" height="140" />
</ItemTemplate>
<ItemStyle Width="50%"></ItemStyle>
</asp:TemplateField>
<asp:BoundField DataField="Productstime" SortExpression="Productstime"
HeaderText="发布时间" ItemStyle-Width="12%"
ItemStyle-HorizontalAlign="center">
</asp:BoundField>
<asp:BoundField DataField="Introduction" HeaderText="产品介绍"
ItemStyle-HorizontalAlign="center">
<ItemStyle HorizontalAlign="Center" Width="20%"></ItemStyle>
</asp:BoundField>
<asp:TemplateField ItemStyle-Width="5000px" ItemStyle-HorizontalAlign="center" HeaderText="相关操作">
<ItemTemplate>
<asp:HyperLink ID="btnModify" runat="server" NavigateUrl=''><img src="images/e17.gif" width="52" height="20" border="0" align="absmiddle"></asp:HyperLink>
<asp:ImageButton ID="btnDelete" runat="server" ImageAlign="AbsMiddle" ImageUrl="images/btnDelete.gif" CausesValidation="False"
CommandName="Remove" CommandArgument='<%#Eval("PKID") %>'
OnClientClick='<%# "if (!confirm(\"你确定要删除" + Eval("PKID").ToString() + "吗?\")) return false;"%>'></asp:ImageButton>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="10%"></ItemStyle>
</asp:TemplateField>
</Columns>
</asp:GridView>后台:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class Freasy_ProductsView : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
bind();
} }
private void bind()
{
string sql = "select PKID,ProductsName,ProductsUrl,Productstime,Introduction,Productstype from Products";
SqlCommand com = new SqlCommand(sql,DBHlepr.connection);
SqlDataAdapter dr = new SqlDataAdapter(com);
DataSet ds = new DataSet();
dr.Fill(ds);
dgResult.DataSource = ds;
dgResult.DataKeyNames = new string[] { "PKID" };
dgResult.DataBind();
} protected void dgResult_RowCommand(object sender, GridViewCommandEventArgs e)
{
int id =Convert.ToInt32(e.CommandArgument);
if (e.CommandName == "Remove")
{
string ssql = "delete from Products where PKID='"+id+"'";
SqlCommand com = new SqlCommand(ssql,DBHlepr.connection);
DBHlepr.connection.Open();
com.ExecuteNonQuery();
DBHlepr.connection.Close();
bind();
} }
}
为什么我删除不了,求解决
AutoGenerateColumns="False" DataKeyNames="PKID" Width="100%" onrwcommand="dgResult_RowCommand" >
<HeaderStyle HorizontalAlign="Center" />
<Columns>
<asp:TemplateField ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="16">
<HeaderTemplate>
<input id="chkAll" onclick="CheckAll()" type="checkbox" />
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" />
</ItemTemplate>
<HeaderStyle Width="16px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:TemplateField>
<asp:BoundField DataField="ProductsName" SortExpression="ProductName" HeaderText="产品名称"
ItemStyle-Width="320" ItemStyle-HorizontalAlign="center">
<ItemStyle HorizontalAlign="Center" Width="8%"></ItemStyle>
</asp:BoundField>
<asp:TemplateField HeaderText="图片" ItemStyle-Width="140">
<ItemTemplate>
<img src='../ProductsUrl/<%#Eval("ProductsUrl")%>' onerror="this.src='/images/nogoods120.gif'" width="140" height="140" />
</ItemTemplate>
<ItemStyle Width="50%"></ItemStyle>
</asp:TemplateField>
<asp:BoundField DataField="Productstime" SortExpression="Productstime"
HeaderText="发布时间" ItemStyle-Width="12%"
ItemStyle-HorizontalAlign="center">
</asp:BoundField>
<asp:BoundField DataField="Introduction" HeaderText="产品介绍"
ItemStyle-HorizontalAlign="center">
<ItemStyle HorizontalAlign="Center" Width="20%"></ItemStyle>
</asp:BoundField>
<asp:TemplateField ItemStyle-Width="5000px" ItemStyle-HorizontalAlign="center" HeaderText="相关操作">
<ItemTemplate>
<asp:HyperLink ID="btnModify" runat="server" NavigateUrl=''><img src="images/e17.gif" width="52" height="20" border="0" align="absmiddle"></asp:HyperLink>
<asp:ImageButton ID="btnDelete" runat="server" ImageAlign="AbsMiddle" ImageUrl="images/btnDelete.gif" CausesValidation="False"
CommandName="Remove" CommandArgument='<%#Eval("PKID") %>'
OnClientClick='<%# "if (!confirm(\"你确定要删除" + Eval("PKID").ToString() + "吗?\")) return false;"%>'></asp:ImageButton>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="10%"></ItemStyle>
</asp:TemplateField>
</Columns>
</asp:GridView>后台:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class Freasy_ProductsView : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
bind();
} }
private void bind()
{
string sql = "select PKID,ProductsName,ProductsUrl,Productstime,Introduction,Productstype from Products";
SqlCommand com = new SqlCommand(sql,DBHlepr.connection);
SqlDataAdapter dr = new SqlDataAdapter(com);
DataSet ds = new DataSet();
dr.Fill(ds);
dgResult.DataSource = ds;
dgResult.DataKeyNames = new string[] { "PKID" };
dgResult.DataBind();
} protected void dgResult_RowCommand(object sender, GridViewCommandEventArgs e)
{
int id =Convert.ToInt32(e.CommandArgument);
if (e.CommandName == "Remove")
{
string ssql = "delete from Products where PKID='"+id+"'";
SqlCommand com = new SqlCommand(ssql,DBHlepr.connection);
DBHlepr.connection.Open();
com.ExecuteNonQuery();
DBHlepr.connection.Close();
bind();
} }
}
为什么我删除不了,求解决
解决方案 »
- 能不能把字符串转化为对象
- 线程间操作问题
- C# 将制定字符串(客户端)输入到指定网页的TextBox中
- 关于socket监听?
- 想把4张 长20000px 宽20000px 的图片合成为一张大图该怎么做啊,好像photoshop最大只能生成30000px的图像?
- DropDownList初始化后什么都不不显示,必须选择之后才显示选择后的值
- C#,asp.net可不可以做到多文件选取框??(多文件上传)
- 我的c#中出现一个问题,richTextBox控件中没有DorgDrop方法??
- datagrid+树.如果记录多得开始滚动的时候,选择的时候树被datagrid遮挡.如何解决?
- 请问在C#里面怎么把char类型的数值转换成int
- help!!!!!!!!!!!!!!!!!!!!!!!!!
- delphi中的array of char相当下C#中的什么类型
此处设置断点,单步调试一下,看ssql的值是多少
然后把ssql在数据库查询分析器执行一下看是否能够正确删除
如果执行ssql在数据库查询分析器不能做删除操作,说明此sql语句有误;
否则,是你程序的问题。