关于datagrid的一个简单小问题：望大虾帮帮忙

datagrid-update和datagrid-cancel却都能正常运行啊

string sql = @"DELETE FROM Employees WHERE EmployeeID='" + empID.ToString()+"'";

哦
string sql = @"DELETE FROM Employees WHERE 'EmployeeID'=" + empID.ToString();
改为string sql = @"DELETE FROM Employees WHERE EmployeeID=" + empID.ToString();就好

沒有句柄啊>>>
將這句public void Datagrid1_Delete(Object sender, DataGridCommandEventArgs e)
更改為public void Datagrid1_Delete(Object sender, DataGridCommandEventArgs e) Handles Datagrid1.DeleteCommand注意後面接尾的Handles Datagrid1.DeleteCommand

public void Datagrid1_DeleteCommand
(Object sender, DataGridCommandEventArgs e)

给你一个代码，自己慢慢看，未整理，运行通过！<%@ Page language="c#" Codebehind="jggl.aspx.cs" AutoEventWireup="false" Inherits="fenoeb.WebForm2" %>
<%@Import Namespace="System.Data.OleDb"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System"%>
<%@Import Namespace="MycMdb"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>价格管理</title> 
<meta content="Microsoft Visual Studio 7.0" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="WebForm2" method="post" runat="server">
<font size="2">
<asp:datagrid id="Grid1" style="Z-INDEX: 101; LEFT: 130px; POSITION: absolute; TOP: 90px" runat="server" AutoGenerateColumns="False" CellPadding="2" BorderColor="Black" AlternatingItemStyle-BackColor="#FFFFCD" Headerstyle-BackColor="#AAAADD" PagerStyle-Mode="NumericPages" AllowPaging="True" OnPageindexChanged="ChangePage" PagerStyle-HorizontalAlign="Right" Font-Size="9pt" AllowSorting="True" OnUpdateCommand="Grid_Update" OnEditCommand="Grid_Edit" OnCancelCommand="Grid_Cancel" PageSize="20">
<AlternatingItemStyle BackColor="#FFFFCD"></AlternatingItemStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<HeaderStyle HorizontalAlign="Center" BackColor="#AAAADD"></HeaderStyle>
<Columns>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" HeaderText="编辑" CancelText="取消" EditText="编辑">
<HeaderStyle Wrap="False"></HeaderStyle>
<ItemStyle Wrap="False"></ItemStyle>
</asp:EditCommandColumn>
<asp:BoundColumn DataField="spmc" ReadOnly="True" HeaderText="商品名称"></asp:BoundColumn>
<asp:BoundColumn DataField="sppp" ReadOnly="True" HeaderText="商品品牌"></asp:BoundColumn>
<asp:BoundColumn DataField="splx" ReadOnly="True" HeaderText="商品类型"></asp:BoundColumn>
<asp:BoundColumn DataField="yxrj" ReadOnly="True" HeaderText="有效容积"></asp:BoundColumn>
<asp:BoundColumn DataField="wxcc" ReadOnly="True" HeaderText="外型尺寸"></asp:BoundColumn>
<asp:BoundColumn DataField="zxgmsl" ReadOnly="True" HeaderText="最小购买量"></asp:BoundColumn>
<asp:BoundColumn DataField="jbjg" HeaderText="商品价格"></asp:BoundColumn>
<asp:BoundColumn Visible="False" DataField="spbh" ReadOnly="True" HeaderText="商品编号"></asp:BoundColumn>
</Columns>
<PagerStyle HorizontalAlign="Right" Mode="NumericPages"></PagerStyle>
</asp:datagrid>
<TABLE id="Table1" style="Z-INDEX: 102; LEFT: 11px; POSITION: absolute; TOP: 44px" cellSpacing="0" cellPadding="0" width="750" align="center" border="0">
<TR>
<TD align="middle"><FONT face="宋体" size="2">价格管理</FONT></TD>
</TR>
</TABLE>
<table cellSpacing="0" cellPadding="0" width="750" align="center" border="0">
<TR>
<td align="middle"><FONT face="宋体" size="2">商品名称:<asp:textbox id="spmc" BorderWidth="1" BorderStyle="Solid" AutoPostBack="false" Runat="server"></asp:textbox>
<asp:button id="Button1" onclick="Button1_Click" runat="server" BorderWidth="1" BorderStyle="Solid" Text="查询" Height="22px" Width="59px"></asp:button></FONT></td>
</TR>
</table>
</font>
</form>
<script language="C#" runat="server">
         int startIndex;
         DataTable Cart;
         DataView CartView;
         int ceIndex;
         void BindGrid()
            {
              string sqlstr="Select * From spml";
              Mdbc db= new Mdbc(Server.MapPath("DataBase/fenoeb.mdb"));
              Grid1.DataSource = db.GetDataView(sqlstr);
              Grid1.DataBind();
            }
            void Page_Load(Object sender,EventArgs e)
             {
                 if(!IsPostBack) {
                startIndex =0;
                }
                BindGrid();
           }
            public void Grid_Edit(Object sender,DataGridCommandEventArgs e){
                Grid1.EditItemIndex=(int)e.Item.ItemIndex;
                BindGrid();
                }
            public void Grid_Cancel(Object sender,DataGridCommandEventArgs e){
                Grid1.EditItemIndex=-1;
                BindGrid();
                }
            public void Grid_Update(Object sender,DataGridCommandEventArgs e)
            {
            Cart=(DataTable)Session["MyCart"];
            Cart=new DataTable();
            Cart.Columns.Add(new DataColumn("spmc",typeof(string)));
            Cart.Columns.Add(new DataColumn("sppp",typeof(string)));
            Cart.Columns.Add(new DataColumn("splx",typeof(string)));
            Cart.Columns.Add(new DataColumn("yxrj",typeof(string)));
            Cart.Columns.Add(new DataColumn("wxcc",typeof(string)));
            Cart.Columns.Add(new DataColumn("zxgmsl",typeof(int)));
            Cart.Columns.Add(new DataColumn("jbjg",typeof(int)));
            Cart.Columns.Add(new DataColumn("spbh",typeof(int)));
            CartView=new DataView(Cart);
            CartView.Sort="spbh";
            string spmc=e.Item.Cells[1].Text;
            string sppp=e.Item.Cells[2].Text;
            string splx=e.Item.Cells[3].Text;
            string yxrj=e.Item.Cells[4].Text;
            string wxcc=e.Item.Cells[5].Text;
            string zxgmsl=e.Item.Cells[6].Text;
            string jbjg=((TextBox)e.Item.Cells[7].Controls[0]).Text;
            string spbh=e.Item.Cells[8].Text;
                            CartView.RowFilter="spbh='"+spbh+"'";
                if (CartView.Count > 0){
                  CartView.Delete(0);
                  }
                CartView.RowFilter = "";
                DataRow dr = Cart.NewRow();
                dr[0]=spmc;
                dr[1]=sppp;
                dr[2]=splx;
                dr[3]=yxrj;
                dr[4]=wxcc;
                dr[5]=zxgmsl;
                dr[6]=jbjg;
                dr[7]=spbh;
                Cart.Rows.Add(dr);
                Grid1.DataSource=new DataView(Cart);
                Grid1.CurrentPageIndex = ceIndex;
                Grid1.DataBind();
                Grid1.EditItemIndex = -1;
                Mdbc db= new Mdbc(Server.MapPath("DataBase/fenoeb.mdb"));
                string str="update spml set jbjg="+jbjg+" where spbh="+spbh+"";
                CartView=db.GetDataView(str);
               // Grid1.CurrentPageIndex = 1;
                BindGrid();
            }
             void ChangePage(Object sender, DataGridPageChangedEventArgs e)
            {
               startIndex = e.NewPageIndex*Grid1.PageSize;
                 Grid1.CurrentPageIndex = e.NewPageIndex;
                 ceIndex = e.NewPageIndex;
                 BindGrid();
            }

     private void Button1_Click(object sender, System.EventArgs e)
{
Grid1.CurrentPageIndex = 0;
String sqlstr;
if (spmc.Text=="")
{
sqlstr="Select * From spml";
}
else
{
sqlstr="Select * From spml where spmc='"+spmc.Text+"'";
}
  Mdbc db= new Mdbc(Server.MapPath("DataBase/fenoeb.mdb"));
               Grid1.DataSource = db.GetDataView(sqlstr);
               Grid1.DataBind();
      } </script>
</body>
</HTML>

调试易

关于datagrid的一个简单小问题：望大虾帮帮忙

解决方案 »