Hello,
I have a gridview wherein I've added functionality for Edit. Now, when
I click on the Edit button, and modify a field, and click on the Update
button, the new values disappear and the old values are retained.
Here is my source code:
<%@ Page Language="C#" AutoEventWireup ="true"
CodeFile="Defau lt.aspx.cs" Inherits="_Defa ult" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitl ed Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server"
AutoGenerateCol umns="False" DataKeyNames="O rderID"
DataSourceID="S qlDataSource1" AllowPaging="Tr ue"
AllowSorting="T rue" OnRowDataBound= "GridView1_RowD ataBound"
OnRowUpdated="G ridView1_RowUpd ated"
OnRowUpdating=" GridView1_RowUp dating">
<Columns>
<asp:CommandFie ld ShowSelectButto n="True"
ShowEditButton= "True" />
<asp:BoundFie ld DataField="Orde rID"
HeaderText="Ord erID" InsertVisible=" False" ReadOnly="True"
SortExpression= "OrderID" />
<asp:BoundFie ld DataField="Cust omerID"
HeaderText="Cus tomerID" SortExpression= "CustomerID " />
<asp:BoundFie ld DataField="Orde rDate"
HeaderText="Ord erDate" SortExpression= "OrderDate" />
<asp:BoundFie ld DataField="Ship City"
HeaderText="Shi pCity" SortExpression= "ShipCity" />
<asp:TemplateFi eld HeaderText="Emp loyeeID"
SortExpression= "EmployeeID ">
<ItemTemplate >
<asp:GridView ID="GridView2" runat="server"
AutoGenerateCol umns="False"
DataKeyNames="E mployeeID" DataSourceID="S qlDataSource2">
<Columns>
<asp:CommandFie ld ShowSelectButto n="True"
ShowEditButton= "True" />
<asp:BoundFie ld DataField ="EmployeeID " />
<asp:BoundFie ld DataField="Last Name" />
<asp:BoundFie ld DataField ="FirstName" />
<asp:BoundFie ld DataField ="Title" />
<asp:TemplateFi eld HeaderText="Cit y">
<EditItemTempla te>
<asp:TextBox ID="TextBox1"
runat="server"> </asp:TextBox>
</EditItemTemplat e>
<ItemTemplate >
<asp:Label ID="Label1"
runat="server" Text='<%# Bind("City") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
</Columns>
</asp:GridView>
<asp:SqlDataSou rce ID="SqlDataSour ce2"
runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:NorthwindCon nectionString %>" SelectCommand=' <%#
Eval("EmployeeI D", "Select EmployeeID, LastName, FirstName, Title, City
from Employees where EmployeeID={0}" )%>' UpdateCommand = '<%#
Eval("EmployeeI d" , "update employees set
firstname=@firs tname,lastname= @lastname,title =@title,city=@c ity where
employeeid={0}" )%>'></asp:SqlDataSour ce>
</ItemTemplate>
</asp:TemplateFie ld>
</Columns>
</asp:GridView>
<asp:SqlDataSou rce ID="SqlDataSour ce1"
OldValuesParame terFormatString ="original_{ 0}"
runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:NorthwindCon nectionString %>"
SelectCommand=" select * from orders" UpdateCommand=" update
orders set
customerid=@cus tomerid,orderda te=@orderdate,s hipcity=@shipci ty where
employeeid=@emp loyeeid">
<UpdateParamete rs>
<asp:Paramete r Name="customeri d" />
<asp:Paramete r Name="orderdate " />
<asp:Paramete r Name="shipcity" />
<asp:Paramete r Name="employeei d" />
<asp:Paramete r Name="orderid" />
</UpdateParameter s>
</asp:SqlDataSour ce>
</div>
</form>
</body>
</html>
Any help is greatly appreciated.
Thanks in advance
