This Example will show how Updating using a gridview is done in ASP.NET 2.0 with the SqlDatasource command.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
<HTML>
<BODY>
<FORM runat="server">
<asp:SqlDataSource
id="SqlDataSource1"
runat="server"
DataSourceMode="DataSet"
ConnectionString=
"<%$ ConnectionStrings:MyNorthwind%>"
SelectCommand="SELECT EmployeeID,FirstName,
LastName,Title FROM Employees"
UpdateCommand="Update Employees
SET FirstName=@FirstName,
LastName=@LastName, Title=@Title
WHERE EmployeeID=@EmployeeID">
</asp:SqlDataSource>
<asp:GridView
id="GridView1"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="EmployeeID"
AutoGenerateEditButton="True"
DataSourceID="SqlDataSource1">
<columns>
<asp:BoundField HeaderText="First Name"
DataField="FirstName" />
<asp:BoundField HeaderText="Last Name"
DataField="LastName" />
<asp:BoundField HeaderText="Title"
DataField="Title" />
</columns>
</asp:GridView>
</FORM>
</BODY>
</HTML>
Look at
"<%$ ConnectionStrings:MyNorthwind%>"
Here
"<%$ %>"is used to databind the Key in web.config.
Its another new feature of asp.net 2.0.
No comments:
Post a Comment