GridView / FormView binding question

[Bob]

Hi All:
I have a GridView with several pages and a FormView linked via a
ControlParamete r. The FormView populates correctly when the user makes
a selection from the first page of the grid. However, when the user
goes to the next page of the grid, the ControlParamete r is passing in a
null (or the default value) to the FormView. I want to populate the
formview with the data from the first item of the grid. I've set
GridView1.Selec tedIndex in GridView1_PageI ndexChanging, but no luck.
Any ideas?

[Muhammad Mosa]

I don't know why this is happening with you but try the following ASP.NET 2.0
script on your aspx page, note that I didn't use any code behind and I'm
using SqlDataSource and the same aspect will work for ObjectDataSourc e.

<asp:GridView ID="GridView1" runat="server" AllowPaging="Tr ue"
AutoGenerateCol umns="False"
DataKeyNames="P roductID" DataSourceID="S qlDataSource1">
<Columns>
<asp:CommandFie ld ShowSelectButto n="True" />
<asp:BoundFie ld DataField="Prod uctID" HeaderText="Pro ductID"
InsertVisible=" False"
ReadOnly="True" SortExpression= "ProductID" />
<asp:BoundFie ld DataField="Prod uctName"
HeaderText="Pro ductName" SortExpression= "ProductNam e" />
</Columns>
</asp:GridView>
<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:NorthwindCon nectionString %>"
SelectCommand=" SELECT [ProductID], [ProductName] FROM
[Products]"></asp:SqlDataSour ce>
<asp:FormView ID="FormView1" runat="server" DataKeyNames="P roductID"
DataSourceID="S qlDataSource2">
<EditItemTempla te>
ProductID:
<asp:Label ID="ProductIDLa bel1" runat="server" Text='<%#
Eval("ProductID ") %>'></asp:Label><br />
ProductName:
<asp:TextBox ID="ProductName TextBox" runat="server"
Text='<%# Bind("ProductNa me") %>'>
</asp:TextBox><br />
UnitPrice:
<asp:TextBox ID="UnitPriceTe xtBox" runat="server" Text='<%#
Bind("UnitPrice ") %>'>
</asp:TextBox><br />
UnitsInStock:
<asp:TextBox ID="UnitsInStoc kTextBox" runat="server"
Text='<%# Bind("UnitsInSt ock") %>'>
</asp:TextBox><br />
<asp:LinkButt on ID="UpdateButto n" runat="server"
CausesValidatio n="True" CommandName="Up date"
Text="Update">
</asp:LinkButton>
<asp:LinkButt on ID="UpdateCance lButton" runat="server"
CausesValidatio n="False" CommandName="Ca ncel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplat e>
<InsertItemTemp late>
ProductName:
<asp:TextBox ID="ProductName TextBox" runat="server"
Text='<%# Bind("ProductNa me") %>'>
</asp:TextBox><br />
UnitPrice:
<asp:TextBox ID="UnitPriceTe xtBox" runat="server" Text='<%#
Bind("UnitPrice ") %>'>
</asp:TextBox><br />
UnitsInStock:
<asp:TextBox ID="UnitsInStoc kTextBox" runat="server"
Text='<%# Bind("UnitsInSt ock") %>'>
</asp:TextBox><br />
<asp:LinkButt on ID="InsertButto n" runat="server"
CausesValidatio n="True" CommandName="In sert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButt on ID="InsertCance lButton" runat="server"
CausesValidatio n="False" CommandName="Ca ncel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTempl ate>
<ItemTemplate >
ProductID:
<asp:Label ID="ProductIDLa bel" runat="server" Text='<%#
Eval("ProductID ") %>'></asp:Label><br />
ProductName:
<asp:Label ID="ProductName Label" runat="server" Text='<%#
Bind("ProductNa me") %>'>
</asp:Label><br />
UnitPrice:
<asp:Label ID="UnitPriceLa bel" runat="server" Text='<%#
Bind("UnitPrice ") %>'></asp:Label><br />
UnitsInStock:
<asp:Label ID="UnitsInStoc kLabel" runat="server" Text='<%#
Bind("UnitsInSt ock") %>'>
</asp:Label><br />
</ItemTemplate>
</asp:FormView>
<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:NorthwindCon nectionString %>"
SelectCommand=" SELECT [ProductID], [ProductName], [UnitPrice],
[UnitsInStock] FROM [Products] WHERE ([ProductID] = @ProductID)">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="Grid View1" Name="ProductID "
PropertyName="S electedValue"
Type="Int32" />
</SelectParameter s>
</asp:SqlDataSour ce>

Hope this will help you

[Muhammad Mosa]

Note the behaviour when you select a record and then move to next page.
suppose that you select record number 2, when you move to next page or any
other page, the record number 2 will on the seeked page will be apear as
selected.