错误：GridView'GridView1'触发了未处理的事件RowDeleting。 [英] Error: The GridView 'GridView1' fired event RowDeleting which wasn't handled.
本文介绍了错误：GridView'GridView1'触发了未处理的事件RowDeleting。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
请帮助!!!
当我在Gridview中添加删除和编辑命令时。
我无法使用删除和编辑命令。我是由Visual Studio 2010开发的
这个错误GridView'GridView1'触发了没有处理的事件RowDeleting。
此HTML代码
please help!!!
When I add the Delete and Edit command in Gridview.
I can not use Delete and Edit command. I develop by Visual studio 2010
This error "The GridView 'GridView1' fired event RowDeleting which wasn't handled."
this HTML Code
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SearchEdit.aspx.cs" Inherits="SearchEdit" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1 {
width: 100%;
}
.auto-style2 {
width: 138px;
}
.auto-style3 {
width: 352px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table class="auto-style1">
<tr>
<td class="auto-style2">Search:</td>
<td class="auto-style3">
<asp:TextBox ID="TextBoxSearch" runat="server" Width="232px"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Style="margin-left: 35px" Text="Search" Width="75px" OnClick="Button1_Click1" />
</td>
<td> </td>
</tr>
</table>
<table class="auto-style1">
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="Member list"></asp:Label>
</td>
</tr>
</table>
<table class="auto-style1">
<tr>
<td>
<asp:SqlDataSource ID="SqlDataSourceMember" runat="server" ConnectionString="<%$ ConnectionStrings:Camt_LibraryConnectionString %>" SelectCommand="SELECT [pre_name], [name], (SELECT [tbl_member_type].[member_type_name] FROM [tbl_member_type] WHERE [tbl_member].[member_type_id] = [tbl_member_type].[member_type_id] ) as member_type_name, [expire_date] FROM [tbl_member]"></asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSourceMember" Height="270px" Style="font-size: small" Width="699px" AllowPaging="True" AllowSorting="True" EnableSortingAndPagingCallbacks="True" OnPageIndexChanging="GridView1_PageIndexChanging">
<Columns>
<asp:BoundField DataField="pre_name" HeaderText=" " SortExpression="pre_name" />
<asp:BoundField DataField="name" HeaderText="Name" SortExpression="name" />
<asp:BoundField DataField="member_type_name" HeaderText="Member type" SortExpression="member_type_id" />
<asp:BoundField DataField="expire_date" HeaderText="Ex-date" SortExpression="expire_date" />
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowDeleteButton="True" />
</Columns>
<FooterStyle BackColor="White" ForeColor="#000066" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#007DBB" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#00547E" />
</asp:GridView>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
和C＃代码
And C# code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
public partial class SearchEdit : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Camt_LibraryConnectionString"].ConnectionString);
DataSet ds = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
}
this.BindMember();
}
protected void BindMember()
{
try
{
String str = "select [pre_name], [name], (SELECT [tbl_member_type].[member_type_name] FROM [tbl_member_type] WHERE [tbl_member].[member_type_id] = [tbl_member_type].[member_type_id] ) as member_type_name, [expire_date] from tbl_member where (name like '%" + TextBoxSearch.Text + "%')";
/*
SqlCommand com = new SqlCommand(str, con);
com.Parameters.Add("@search", SqlDbType.NVarChar).Value = TextBoxSearch.Text;
con.Open();
com.ExecuteNonQuery();
*/
SqlDataAdapter da = new SqlDataAdapter(str, con);
//da.SelectCommand = com;
//DataSet ds = new DataSet();
da.Fill(ds, "name");
GridView1.DataSourceID = null;
GridView1.DataSource = ds;
GridView1.DataBind();
}
catch (Exception ex)
{
Response.Write(ex);
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
this.BindMember();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
this.BindMember();
}
}
推荐答案
ConnectionStrings：Camt_LibraryConnectionString ％> SelectCommand = SELECT [pre_name]，[name]，（SELECT [tbl_member_type]。[member_type_name] FROM [tbl_member_type] WHERE [tbl_member]。[member_type_id] = [ tbl_member_type]。[member_type_id]）as member_type_name，[expire_date] FROM [tbl_member] > < / asp：SqlDataSource >
< asp：GridView ID = G ridView1 runat = server AutoGenerateColumns = False BackColor = 白色 BorderColor = ＃CCCCCC BorderStyle = 无 BorderWidth = 1px CellPadding = 3 DataSourceID = < span class =code-keyword> SqlDataSourceMember 高度 = 270px 样式 = font-size：small 宽度 = 699px AllowPaging = True AllowSorting = True EnableSortingAndPagingCallbacks = True OnPageIndexChanging = GridView1_PageIndexChanging\">
<Columns>
<asp:BoundField DataField=\"pre_name\" HeaderText=\" \" SortExpression=\"pre_name\" />
<asp:BoundField DataField=\"name\" HeaderText=\"Name\" SortExpression=\"< span class=\"code-keyword\">name\" />
<asp:BoundField DataField=\"member_type_name\" HeaderText=\"Member type\" SortExpression=\"member_type_id\" />
<asp:BoundField DataField=\"expire_date\" HeaderText=\"Ex-date\" SortExpression=\"expire_date\" />
<asp:CommandField ShowEditButton=\"True\" / >
<asp:CommandField ShowDeleteButton=\"True\" />
</Columns>
<FooterStyle BackColor=\"White\" ForeColor=\" #000066\" />
<HeaderStyle BackColor=\"#006699\" Font-Bold=\"True\" ForeColor=\"White\" />
<PagerStyle BackColor=\"White\" ForeColor=\"#000066\" HorizontalAlign=\"Left\" />
<RowStyle ForeColor=\"#000066\" />
<SelectedRowStyle BackColor=\"#669999\" Font-Bold=\"True\" ForeColor=\"White\" />
<SortedAscendingCellStyle BackColor=\"#F1F1F1\" />
<SortedAscendingHeaderStyle BackColor=\"#007DBB\" />
<SortedDescendingCellStyle BackColor=\"#CAC9C9\" />
<SortedDescendingHeaderStyle BackColor=\"#00547E\" />
</asp:GridView>
</td>
</tr>
</table>
</div >
</form>
</body>
</html>
ConnectionStrings:Camt_LibraryConnectionString %>" SelectCommand="SELECT [pre_name], [name], (SELECT [tbl_member_type].[member_type_name] FROM [tbl_member_type] WHERE [tbl_member].[member_type_id] = [tbl_member_type].[member_type_id] ) as member_type_name, [expire_date] FROM [tbl_member]"></asp:SqlDataSource> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSourceMember" Height="270px" Style="font-size: small" Width="699px" AllowPaging="True" AllowSorting="True" EnableSortingAndPagingCallbacks="True" OnPageIndexChanging="GridView1_PageIndexChanging"> <Columns> <asp:BoundField DataField="pre_name" HeaderText=" " SortExpression="pre_name" /> <asp:BoundField DataField="name" HeaderText="Name" SortExpression="name" /> <asp:BoundField DataField="member_type_name" HeaderText="Member type" SortExpression="member_type_id" /> <asp:BoundField DataField="expire_date" HeaderText="Ex-date" SortExpression="expire_date" /> <asp:CommandField ShowEditButton="True" /> <asp:CommandField ShowDeleteButton="True" /> </Columns> <FooterStyle BackColor="White" ForeColor="#000066" /> <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" /> <RowStyle ForeColor="#000066" /> <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#F1F1F1" /> <SortedAscendingHeaderStyle BackColor="#007DBB" /> <SortedDescendingCellStyle BackColor="#CAC9C9" /> <SortedDescendingHeaderStyle BackColor="#00547E" /> </asp:GridView> </td> </tr> </table> </div> </form> </body> </html>
And C# code
And C# code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
public partial class SearchEdit : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Camt_LibraryConnectionString"].ConnectionString);
DataSet ds = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
}
this.BindMember();
}
protected void BindMember()
{
try
{
String str = "select [pre_name], [name], (SELECT [tbl_member_type].[member_type_name] FROM [tbl_member_type] WHERE [tbl_member].[member_type_id] = [tbl_member_type].[member_type_id] ) as member_type_name, [expire_date] from tbl_member where (name like '%" + TextBoxSearch.Text + "%')";
/*
SqlCommand com = new SqlCommand(str, con);
com.Parameters.Add("@search", SqlDbType.NVarChar).Value = TextBoxSearch.Text;
con.Open();
com.ExecuteNonQuery();
*/
SqlDataAdapter da = new SqlDataAdapter(str, con);
//da.SelectCommand = com;
//DataSet ds = new DataSet();
da.Fill(ds, "name");
GridView1.DataSourceID = null;
GridView1.DataSource = ds;
GridView1.DataBind();
}
catch (Exception ex)
{
Response.Write(ex);
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
this.BindMember();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
this.BindMember();
}
}Here you have to generate GridView1_RowDeleting Event.
For Example.
Here you have to generate GridView1_RowDeleting Event.
For Example.
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
dt.Rows.RemoveAt(e.RowIndex);
GridView1.DataSource = dt;
GridView1.DataBind();
}SElect the grid in design View and right click on it and click properties,
In property window select fire symbol and.. double click on row deleting..Enough..
Or property window..
select ur grid..
its like
GridVIew1 System.Web.UI...........
select fire row deleting
<asp:GridView ID=\"GridView2\" runat=\"server\" AutoGenerateColumns=\"False\" BackColor=\"White\" BorderColor=\"#CCCCCC\" BorderStyle=\"None\" BorderWidth=\"1px\" CellPadding=\"3\" DataSourceID=\"SqlDataSourceMember\" Height=\"270px\" Style=\"font-size: small\" Width=\"699px\" AllowPaging=\"True\" AllowSorting=\"True\" EnableSortingAndPagingCallbacks=\"True\" OnPageIndexChanging=\"GridView1_PageIndexChanging\" onrowdeleting=\"GridView1_RowDeleting\">
SElect the grid in design View and right click on it and click properties,
In property window select fire symbol and.. double click on row deleting..Enough..
Or property window..
select ur grid..
its like
GridVIew1 System.Web.UI...........
select fire row deleting
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSourceMember" Height="270px" Style="font-size: small" Width="699px" AllowPaging="True" AllowSorting="True" EnableSortingAndPagingCallbacks="True" OnPageIndexChanging="GridView1_PageIndexChanging" onrowdeleting="GridView1_RowDeleting">
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
}这篇关于错误：GridView'GridView1'触发了未处理的事件RowDeleting。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
