In Asp.net 2.0, the gridview control is a very good control. In some cases
All rows are text boxes. How do I update all modified records at a time? There are two methods, one is to use sqldatasource to update
All records, but this method is slow, because every time you update a record, you must establish a data connection and execute updatecommand, which will affect the performance,
But let's first look at the implementation method:
<% @ Page Language = "C #" %>
<SCRIPT runat = "server">
Void button#click (Object sender, eventargs E)
{
For (INT I = 0; I <gridview1.rows. Count; I ++)
{
Gridviewrow ROW = gridview1.rows [I];
Sqldatasource1.updateparameters [0]. defaultvalue = (textbox) Row. cells [0]. findcontrol ("textbox2"). text;
Sqldatasource1.updateparameters [1]. defaultvalue = (textbox) Row. cells [1]. findcontrol ("textbox3"). text;
Sqldatasource1.updateparameters [2]. defaultvalue = gridview1.datakeys [I]. value. tostring ();
Sqldatasource1.update ();
}
}
</SCRIPT>
<HTML xmlns = "http://www.w3.org/1999/xhtml">
<Head runat = "server">
<Title> untitled page </title>
</Head>
<Body>
<Form ID = "form1" runat = "server">
<Div>
<Asp: gridview id = "gridview1" runat = "server" performanceid = "sqlperformance1" datakeynames = "customerid"
Autogeneratecolumns = "false">
<Columns>
<Asp: templatefield sortexpression = "customerid" headertext = "customerid">
<Itemtemplate>
<Asp: textbox runat = "server" text = '<% # BIND ("customerid") %>' Id = "textbox1"> </ASP: textbox>
</Itemtemplate>
</ASP: templatefield>
<Asp: templatefield sortexpression = "companyName" headertext = "companyName">
<Itemtemplate>
<Asp: textbox runat = "server" text = '<% # BIND ("companyName") %>' Id = "textbox2"> </ASP: textbox>
</Itemtemplate>
</ASP: templatefield>
<Asp: templatefield sortexpression = "contactname" headertext = "contacttitle">
<Itemtemplate>
<Asp: textbox runat = "server" text = '<% # BIND ("contacttitle") %>' Id = "textbox3"> </ASP: textbox>
</Itemtemplate>
</ASP: templatefield>
</Columns>
</ASP: gridview>
<Asp: sqldatasource id = "sqldatasource1" runat = "server"
Selectcommand = "select [customerid], [companyName], [contactname], [contacttitle] from [Customers]"
Updatecommand = "Update [MERs] Set [companyName] = @ companyName, [contacttitle] = @ contacttitle where [customerid] = @ customerid"
Connectionstring = "<% $ connectionstrings: appconnectionstring1 %>">
<Updateparameters>
<Asp: parameter type = "string" name = "companyName"> </ASP: parameter>
<Asp: parameter type = "string" name = "contacttitle"> </ASP: parameter>
<Asp: parameter type = "string" name = "customerid"> </ASP: parameter>
</Updateparameters>
</ASP: sqldatasource>
<Asp: button id = "button1" runat = "server" text = "button" onclick = "button#click"/> & nbsp;
</Div>
</Form>
</Body>
</Html> another method is to combine SQL statements, which is fast and easy to understand.
<% @ Page Language = "C #" %>
<% @ Import namespace = "system. Text" %>
<% @ Import namespace = "system. Data. sqlclient" %>
<SCRIPT runat = "server">
Void button#click (Object sender, eventargs E)
{
Stringbuilder query = new stringbuilder ();
For (INT I = 0; I <gridview1.rows. Count; I ++)
{
Gridviewrow ROW = gridview1.rows [I];
String value1 = (textbox) Row. cells [0]. findcontrol ("textbox2"). Text. Replace ("'","''");
String value2 = (textbox) Row. cells [1]. findcontrol ("textbox3"). Text. Replace ("'","''");
String value3 = gridview1.datakeys [I]. value. tostring ();
Query. append ("Update [MERs] Set [companyName] = '")
. Append (value1). append ("', [contacttitle] = '")
. Append (value2). append ("'where [mermerid] = '")
. Append (value3). append ("'; \ n ");
}
Sqlconnection con = new sqlconnection (configurationsettings. connectionstrings ["appconnectionstring1"]. connectionstring );
Sqlcommand command = new sqlcommand (query. tostring (), con );
Con. open ();
Command. executenonquery ();
Con. Close ();
}
Void page_load (Object sender, eventargs E)
{
If (! Page. ispostback)
{
Sqlconnection con = new sqlconnection (configurationsettings. connectionstrings ["appconnectionstring1"]. connectionstring );
Sqlcommand command = new sqlcommand ("select [customerid], [companyName], [contactname], [contacttitle] from [Customers]", con );
Con. open ();
Gridview1.datasource = command. executereader ();
Gridview1.databind ();
Con. Close ();
}
}
</SCRIPT>
<HTML xmlns = "http://www.w3.org/1999/xhtml">
<Head runat = "server">
<Title> untitled page </title>
</Head>
<Body>
<Form ID = "form1" runat = "server">
<Div>
<Asp: gridview id = "gridview1" runat = "server" datakeynames = "customerid"
Autogeneratecolumns = "false">
<Columns>
<Asp: templatefield sortexpression = "customerid" headertext = "customerid">
<Itemtemplate>
<Asp: textbox runat = "server" text = '<% # BIND ("customerid") %>' Id = "textbox1"> </ASP: textbox>
</Itemtemplate>
</ASP: templatefield>
<Asp: templatefield sortexpression = "companyName" headertext = "companyName">
<Itemtemplate>
<Asp: textbox runat = "server" text = '<% # BIND ("companyName") %>' Id = "textbox2"> </ASP: textbox>
</Itemtemplate>
</ASP: templatefield>
<Asp: templatefield sortexpression = "contactname" headertext = "contacttitle">
<Itemtemplate>
<Asp: textbox runat = "server" text = '<% # BIND ("contacttitle") %>' Id = "textbox3"> </ASP: textbox>
</Itemtemplate>
</ASP: templatefield>
</Columns>
</ASP: gridview>
<Asp: button id = "button1" runat = "server" text = "button" onclick = "button#click"/> & nbsp;
</Div>
</Form>
</Body>
</Html>
