Example 1 -

This is a example of upadating a GridView at run time.

Step 1:

Drag one GridView Control and one SqlDatasurce from toolbox onto your aspx page..

Step 2:

Create a table in Sql Server, details as follows-

Sql Table Fields.

Table Name -Customers

Column Name-

1:-CustomerID-Varchar(50) with Primary Key
2:-ContactName-Varchar(50)with NoT Null
3:-CompanyName-Varchar(50)

Step 3:

Go to aspx part of asp.net web page-

And add the following mannually

Note:- You can write a custom connection String in place of

ConnectionString="<%$ ConnectionStrings:empConnectionString %>"

Like............

ConnectionString="server=yourservername or use dot(.) only on place of server name;database=databasename;Integrated Security=true or SSPI"

<form id="form1" runat="server">
<asp:SqlDataSource ID="ds1" runat="server"
ConnectionString="<%$ ConnectionStrings:empConnectionString %>"
SelectCommand="SELECT * FROM [Customers]"
UpdateCommand="Update [Customers] set [ContactName]=@ContactName,[CompanyName]=@CompanyName
WHERE ([CustomerID] = @CustomerID)">
<UpdateParameters>
<asp:Parameter Name="CustomerId" Type="String" />
<asp:Parameter Name="ContactName" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>

Step 4:

Set DataKeyNames="CustomerID" in Grid View Control.

<asp:GridView ID="GridView1" Runat="server"
DataSourceID="ds1" DataKeyNames="CustomerID"
AutoGenerateColumns="False" AllowPaging="True" >
<Columns>
<asp:CommandField ShowEditButton="True"></asp:CommandField>
<asp:BoundField ReadOnly="True" HeaderText="CustomerId" InsertVisible="False" DataField="CustomerID" SortExpression="CustomerID">
</asp:BoundField>
<asp:BoundField HeaderText="ContactName" DataField="ContactName" SortExpression="ContactName">
</asp:BoundField>
<asp:BoundField HeaderText="CompanyName" DataField="CompanyName" SortExpression="CompanyName">
</asp:BoundField>
</Columns>
</asp:GridView>
</form>

Output:

1.gif

Example 2:

This is an example of selecting record from a GridView at run time using details view.

Step 1:

Drag one GridView Control, one Details View Control and Two SqlDatasource from toolbox onto your aspx page..

Step 2:

Create a table in Sql Server, details as follows-

Sql Table Fields.

Table Name -Customers

Coloumn Name-

1:-CustomerID-Varchar(50) with Primary Key
2:-ContactName-Varchar(50)with NoT Null
3:-CompanyName-Varchar(50)

Step 3:

Go to aspx part of asp.net web page-

And add the following mannually

Note:- You can write a custom connection String in place of

ConnectionString="<%$ ConnectionStrings:empConnectionString %>"

Like............

ConnectionString="server=yourservername or use dot(.) only in place of server name;database=databasename;Integrated Security=true or SSPI"

<form id="form1" runat="server">
<asp:SqlDataSource ID="ds1" runat="server"
ConnectionString="<%$ ConnectionStrings:empConnectionString %>"
SelectCommand="SELECT [CustomerID] FROM [Customers]">
</asp:SqlDataSource>

Set DataKeyNames="CustomerID" in Grid View Control.

<asp:gridview ID="Gridview1" runat="server" AutoGenerateSelectButton="True"
DataSourceID="ds1" DataKeyNames="CustomerID">
</asp:gridview>
<asp:SqlDataSource ID="ds2" runat="server"
ConnectionString="<%$ ConnectionStrings:empConnectionString2 %>" SelectCommand="SELECT * FROM [Customers] WHERE ([CustomerID] = @CustomerID)">
<SelectParameters>
<asp:ControlParameter ControlID="Gridview1" Name="CustomerID"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<asp:DetailsView ID="DetailsView1" runat="server" DataSourceID="ds2">
</asp:DetailsView>
</form>

Output
2.gif