how to bind record to form view from different tables at different time

[sudhashekhar30]

hi all
i am using formview control(asp.net 2.0) 1rst time. don't know much about it.
i want to display record in it from different tables at different time. like 1rst time form view is showing record of tableEmp. 2nd time same formview showing record of tableSalary.i am using c# coding. is it possible to bind data from code behind file? if possible, how?

i would also like to know how i can bind formview from datagrid(select event)
thanks.

regards
sudha

[kunal pawar]

hi all
i am using formview control(asp.net 2.0) 1rst time. don't know much about it.
i want to display record in it from different tables at different time. like 1rst time form view is showing record of tableEmp. 2nd time same formview showing record of tableSalary.i am using c# coding. is it possible to bind data from code behind file? if possible, how?

i would also like to know how i can bind formview from datagrid(select event)
thanks.

regards
sudha

It is posible by Changing Datasource on gridview

[sudhashekhar30]

It is posible by Changing Datasource on gridview

thnks 4r ur reply sir. but u didn't get my question. if u no please reply. 1rst thing how to bind data to form view from "d.aspx.cs" page
i've done dis but not working n also not showing error
---- -----------
// here is coding for query.
SqlDataAdapter sdaSearch = new SqlDataAdapter();
sdaSearch.Fill(ds);

FormView2.DataSource = ds;
FormView2.DataBind();

thnks.
regards
sudha

[kunal pawar]

try this one

// FormView control ////////////////////////////////
<asp:FormView ID="FormView1" runat="server" CellPadding="4" ForeColor="#333333"
DataKeyNames="AutoID" DataSourceID="SqlDataSource1" AllowPaging="true">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<ItemTemplate>
<table border="1">
<tr>
<td>AutoID</td>
<td><%# Eval("AutoID") %></td>
</tr>
<tr>
<td>Name</td>
<td><%# Eval("Name") %></td>
</tr>
<tr>
<td>Address</td>
<td><%# Eval("Address") %></td>
</tr>
<tr>
<td>Phone</td>
<td><%# Eval("Phone") %></td>
</tr>
<tr>
<td>City</td>
<td><%# Eval("City") %></td>
</tr>
<tr>
<td> </td>
<td>
<asp:Button ID="btnEdit" runat="Server" CommandName="Edit" Text="Edit" />
<asp:Button ID="btnInsert" runat="Server" CommandName="New" Text="New" />
<asp:Button ID="btnDelete" runat="Server" CommandName="Delete" Text="Delete" OnClientClick="return confirm('Are you sure to Delete?');" />
</td>
</tr>
</table>
</ItemTemplate>
<EditItemTemplate>
<table border="1">
<tr>
<td>AutoID</td>
<td><%# Eval("AutoID") %></td>
</tr>
<tr>
<td>Name</td>
<td><asp:TextBox ID="TextBox1" runat="Server" Text='<%# Bind("Name")%>'></asp:TextBox></td>
</tr>
<tr>
<td>Address</td>
<td><asp:TextBox ID="TextBox2" runat="Server" Text='<%# Bind("Address")%>'></asp:TextBox></td>
</tr>
<tr>
<td>Phone</td>
<td><asp:TextBox ID="TextBox3" runat="Server" Text='<%# Bind("Phone")%>'></asp:TextBox></td>
</tr>
<tr>
<td>City</td>
<td><asp:TextBox ID="TextBox4" runat="Server" Text='<%# Bind("City")%>'></asp:TextBox></td>
</tr>
<tr>
<td> </td>
<td>
<asp:Button ID="btnUpdate" runat="Server" CommandName="Update" Text="Update" />
<asp:Button ID="Button1" runat="Server" CommandName="Cancel" Text="Cancel" />
</td>
</tr>
</table>
</EditItemTemplate>
<InsertItemTemplate>
<table border="1">
<tr>
<td>AutoID</td>
<td><%# Eval("AutoID") %></td>
</tr>
<tr>
<td>Name</td>
<td><asp:TextBox ID="TextBox1" runat="Server" Text='<%# Bind("Name")%>'></asp:TextBox></td>
</tr>
<tr>
<td>Address</td>
<td><asp:TextBox ID="TextBox2" runat="Server" Text='<%# Bind("Address")%>'></asp:TextBox></td>
</tr>
<tr>
<td>Phone</td>
<td><asp:TextBox ID="TextBox3" runat="Server" Text='<%# Bind("Phone")%>'></asp:TextBox></td>
</tr>
<tr>
<td>City</td>
<td><asp:TextBox ID="TextBox4" runat="Server" Text='<%# Bind("City")%>'></asp:TextBox></td>
</tr>
<tr>
<td> </td>
<td>
<asp:Button ID="btnSave" runat="Server" CommandName="insert" Text="Insert" />
<asp:Button ID="Button1" runat="Server" CommandName="Cancel" Text="Cancel" />
</td>
</tr>
</table>
</InsertItemTemplate>
</asp:FormView>


// SqlDataSource Control ////////////////////////////////
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString='<%$ ConnectionStrings:ConnStr %>'
SelectCommand="Select * FROM SampleForTutorials ORDER BY [Name]"
DeleteCommand="Delete FROM SampleForTutorials WHERE AutoID = @AutoID"
UpdateCommand="UPDATE SampleForTutorials SET Name = @Name, Address = @Address, Phone = @Phone, City = @City WHERE AutoID = @AutoID"
InsertCommand="INSERT INTO SampleForTutorials (Name, Address, Phone, City) VALUES (@Name, @Address, @Phone, @City)">
<DeleteParameters>
<asp:Parameter Name="AutoID" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="AutoID" Type="Int32" />
<asp:Parameter Name="Name" Type="string" Size="50" />
<asp:Parameter Name="Address" Type="string" Size="200" />
<asp:Parameter Name="Phone" Type="string" Size="50" />
<asp:Parameter Name="City" Type="string" Size="20" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Name" Type="string" Size="50" />
<asp:Parameter Name="Address" Type="string" Size="200" />
<asp:Parameter Name="Phone" Type="string" Size="50" />
<asp:Parameter Name="City" Type="string" Size="20" />
<asp:Parameter Name="AutoID" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>