Default.aspx page:
Copy Code code as follows:
<%@ Page language= "C #" autoeventwireup= "true" codebehind= "Default.aspx.cs" inherits= "Gps_web.default"%>
<! DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 transitional//en" "Http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd ">
<title></title>
<body>
<form id= "Form1" runat= "Server" >
<div>
<!--several events must be written in the GridView: Onrowediting, Onrowupdating, Onrowcancelingedit, onrowdeleting--->
<asp:gridview id= "GridView1" runat= "Server" autogeneratecolumns= "False"
onpageindexchanging= "gridview1_pageindexchanging" onrowcancelingedit= "Gridview1_rowcancelingedit"
onrowediting= "gridview1_rowediting" onrowupdating= "gridview1_rowupdating"
Onrowdeleting= "Gridview1_rowdeleting"
onselectedindexchanging= "Gridview1_selectedindexchanging" >
<Columns>
<asp:templatefield headertext= "number" visible= "False" >
<ItemTemplate>
<asp:label id= "Lblnum" runat= "server" text= ' <%# Eval ("Num")%> ' ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:templatefield headertext= "Name" >
<EditItemTemplate>
<asp:textbox id= "Txttablename" runat= "server" text= ' <%# Eval ("tablename")%> ' ></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:label id= "Label2" runat= "server" text= ' <%# Eval ("tablename")%> ' ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:templatefield headertext= "Address" >
<EditItemTemplate>
<asp:textbox id= "Txttextname" runat= "server" text= ' <%# Eval ("Textname")%> ' ></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:label id= "Label3" runat= "server" text= ' <%# Eval ("Textname")%> ' ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:commandfield headertext= "state" showselectbutton= "True"/>
<asp:commandfield headertext= "edit" showeditbutton= "True"/>
<asp:commandfield headertext= "Delete" showdeletebutton= "True"/>
</Columns>
</asp:GridView>
<br/>
<asp:button id= "Btnadd" runat= "Server" onclick= "btnAdd_Click" text= "Add"/>
<br/>
<br/>
</div>
</form>
</body>
Default.aspx.cs page Code:
Copy Code code as follows:
Using System;
Using System.Web.UI;
Using System.Web.UI.WebControls;
Using GPS_Web.ywpages.DAL;
Using System.Data;
Namespace Gps_web
{
<summary>
Reference URL: http://blog.csdn.net/wanglei_samrtfish/article/details/8070480
</summary>
public partial class Default:System.Web.UI.Page
{
protected void Page_Load (object sender, EventArgs e)
{
if (! Page.IsPostBack)
{
Gridviewbind ();
}
}
private void Gridviewbind ()
{
String sql = "Select Num,tablename,textname from dbo." Grouptype_demo ";
Try
{//bound data source
Gridview1.datasource = SqlHelper.ExecuteDataset (sqlhelper.getconnsting (), CommandType.Text, SQL). Tables[0];
Gridview1.databind ();
}
catch (Exception ex) {}
}
protected void Gridview1_pageindexchanging (object sender, Gridviewpageeventargs e)
{
Gridview1.pageindex = E.newpageindex;
Gridviewbind ();
}
protected void Gridview1_rowcancelingedit (object sender, Gridviewcancelediteventargs e)
{
Gridview1.editindex =-1;
Gridviewbind ();
}
protected void Gridview1_rowediting (object sender, GridViewEditEventArgs e)
{//gridview Edit item index equals click index of row
Gridview1.editindex = E.neweditindex;
Gridviewbind ();
}
<summary>
Modify an Event
</summary>
protected void Gridview1_rowupdating (object sender, Gridviewupdateeventargs e)
{//Remove number
int Num = Convert.ToInt32 ((Label) Gridview1.rows[e.rowindex]. FindControl ("Lblnum")). Text.tostring ());
Get the contents of a modified value
String tablename = ((TextBox) Gridview1.rows[e.rowindex]. FindControl ("Txttablename")). Text;
String textname = ((TextBox) Gridview1.rows[e.rowindex]. FindControl ("Txttextname")). Text;
Update records
String sql = string. Format ("UPDATE dbo.") Grouptype_demo set Tablename= ' {0} ', Textname= ' {1} ' where num={2} ', tablename,textname,num);
Try
{
int i = Sqlhelper.executenonquery (Sqlhelper.getconnsting (), CommandType.Text, SQL);
if (i > 0)
{
Clientscript.registerstartupscript (Clientscript.gettype (), "MyScript", "<script language= ' JavaScript" >alert (' Modification Successful! ') </script> ");
}
Else
{
Clientscript.registerstartupscript (Clientscript.gettype (), "MyScript", "<script language= ' JavaScript" >alert (' Modification failed! ') </script> ");
}
}
catch (Exception ex)
{
Clientscript.registerstartupscript (Clientscript.gettype (), "MyScript", "<script language= ' JavaScript" >alert (' Invalid operation! ') </script> ");
}
Gridview1.editindex =-1;
Gridviewbind ();
}
<summary>
Delete Event
</summary>
protected void Gridview1_rowdeleting (object sender, Gridviewdeleteeventargs e)
{
Remove number
int Num = Convert.ToInt32 ((Label) Gridview1.rows[e.rowindex]. FindControl ("Lblnum")). Text.tostring ());
Update records
String sql = string. Format ("delete dbo.") Grouptype_demo where num={0} ", num);
Try
{
int i = Sqlhelper.executenonquery (Sqlhelper.getconnsting (), CommandType.Text, SQL);
if (i > 0)
{
Clientscript.registerstartupscript (Clientscript.gettype (), "MyScript", "<script language= ' JavaScript" >alert (' Delete succeeded! ') </script> ");
}
Else
{
Clientscript.registerstartupscript (Clientscript.gettype (), "MyScript", "<script language= ' JavaScript" >alert (' Delete failed! ') </script> ");
}
}
catch (Exception ex)
{
Clientscript.registerstartupscript (Clientscript.gettype (), "MyScript", "<script language= ' JavaScript" >alert (' Invalid operation! ') </script> ");
} www.jb51.net
Gridview1.editindex =-1;
Gridviewbind ();
}
<summary>
Add a button
</summary>
protected void btnAdd_Click (object sender, EventArgs e)
{
Response.Redirect ("~/default_add.aspx");
}
protected void Gridview1_selectedindexchanging (object sender, GridViewSelectEventArgs e)
{
Line number
int i = E.newselectedindex;
GridViewRow row = Gridview1.rows[e.newselectedindex];
Btnadd.text = "You have selected the" + (i+1) + "line. ";
}
}
}
The page effect after execution:
