:
Html Code
Copy code The Code is as follows: <Table align = "center" bgcolor = "# c0de98" border = "0" cellpadding = "0" cellspacing = "1" width = "99%">
<Tr>
<TH colspan = "2">
Gridview demonstration </Th>
</Tr>
<Tr>
<TD colspan = "2" style = "width: 100%;">
<Asp: gridview id = "gridview" runat = "server" width = "100%" autogeneratecolumns = "false" allowpaging = "true" onpageindexchanging = "inline" pagesize = "12" onrowdeleting = "gridview_rowdeleting "onrowdatabound =" gridview_rowdatabound ">
<Columns>
<Asp: boundfield datafield = "userid" headertext = "userid" readonly = "true"/>
<Asp: boundfield datafield = "c_name" headertext = "Chinese name" readonly = "true"/>
<Asp: boundfield datafield = "e_name" headertext = "English name" readonly = "true"/>
<Asp: boundfield datafield = "QQ" headertext = "QQ account"/>
<Asp: commandfield headertext = "delete" showdeletebutton = "true"/>
</Columns>
<Rowstyle horizontalalign = "center"/>
<Pagerstyle horizontalalign = "right"/>
</ASP: gridview>
</TD>
</Tr>
</Table>
C # codeCopy codeThe Code is as follows: using system;
Using system. Data;
Using system. Data. sqlclient;
Using system. configuration;
Using system. collections;
Using system. Web;
Using system. Web. Security;
Using system. Web. UI;
Using system. Web. UI. webcontrols;
Using system. Web. UI. webcontrols. webparts;
Using system. Web. UI. htmlcontrols;
Public partial class demo11: system. Web. UI. Page
{
Protected void page_load (Object sender, eventargs E)
{
If (page. ispostback = false)
{
Binddata ();
}
}
Public void binddata ()
{
String strsql = "select userid, c_name, e_name, QQ from demo_user ";
Datatable dt = sqlhelper. executedataset (sqlhelper. conn_string, commandtype. Text, strsql, null). Tables [0];
Gridview. datasource = DT;
Gridview. datakeynames = new string [] {"userid"}; // primary key
Gridview. databind ();
}
Protected void gridview_pageindexchanging (Object sender, gridviewpageeventargs E)
{
Gridview. pageindex = E. newpageindex;
Binddata ();
}
Protected void gridview_rowdeleting (Object sender, gridviewdeleteeventargs E)
{
Int userid = (INT) gridview. datakeys [E. rowindex]. value;
String strsql = "delete demo_user where userid = @ userid ";
Sqlparameter [] para = {
New sqlparameter ("@ userid", userid ),
};
Sqlhelper. executenonquery (sqlhelper. conn_string, commandtype. Text, strsql, para );
Binddata ();
}
protected void gridview_rowdatabound (Object sender, gridviewroweventargs e)
{< br> If (E. row. rowtype = datacontrolrowtype. datarow)
{< br> If (E. row. rowstate = datacontrolrowstate. normal | E. row. rowstate = datacontrolrowstate. alternate)
{< br> (linkbutton) E. row. cells [4]. controls [0]). attributes. add ("onclick", "javascript: Return confirm ('Are you sure you want to delete: \" "+ E. row. cells [1]. text +? ') ");
}< BR >}