Gridview.aspx
<%@ Page Language="C#"
AutoEventWireup="true" CodeFile="19_Gridview.aspx.cs"
Inherits="_19_Gridview" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form
id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="Name"
HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="City"
HeaderText="City" SortExpression="City" />
<asp:CommandField ShowEditButton="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1"
runat="server" ConnectionString="<%$
ConnectionStrings:ConnectionString %>" SelectCommand="SELECT *
FROM [detail]" UpdateCommand="UPDATE detail set Name=@Name,City=@city
where City=@City"></asp:SqlDataSource>
</div>
</form>
</body>
</html>
Step:-
Click on Controls right manu
select new SqlDataSource1 on dropdownlist
Select database
click next
select data table
Click next
Click finish
Click on Controls right manu
select new SqlDataSource1 on dropdownlist
Select database
click next
select data table
Click next
Click finish
………………WE not require write any think in cs file (Don’t
delete cs file).
Don’t display data in declarative binding every time (It is not strong connection)