|
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Text" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
void Button1_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 [Customers] SET [CompanyName] = ’")
.Append value1).Append "’ , [ContactTitle] = ’")
.Append value2).Append "’ WHERE [CustomerID] = ’")
.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="Button1_Click" />
</div>
</form>
</body>
</html>
| 
