Issue With Getting Values From Child Controls In A Gridview, To Use For The Update Using A SQLDataSource Control

Hi all,

I have a gridview bound with a SQLDataSource. I am using the Update feature of the SQLDataSource to update a SQL Server database with values entered into the gridview. However I am not getting it to work. I believe this is due to the controls that contain the user entries are not the gridview itself, but rather child controls within the gridview. I have been using the names of the actual controls but nothing happens. Upon submit, the screen returns blank, and the database is not updated. Here is some code:

 

<asp:GridView ID="GridEditSettlement" runat="server" AutoGenerateColumns="False" BackColor="Navy"

BorderColor="IndianRed" BorderStyle="Solid" Font-Names="Verdana" Font-Size="X-Small" DataSourceID="SqlDataSource_grid" AllowPaging="True" AllowSorting="True" ForeColor="White" DataKeyNames="legid">

<Columns>

<asp:CommandField ShowEditButton="True" CancelImageUrl="~/App_Graphics/quit.gif" CancelText="" EditImageUrl="~/App_Graphics/EditGrid.GIF" EditText="" UpdateImageUrl="~/App_Graphics/save.gif" UpdateText="" ButtonType="Image" />

<asp:BoundField DataField="StartDate" HeaderText="Start Date" ReadOnly="True" />

<asp:BoundField DataField="EndDate" HeaderText="End Date" ReadOnly="True" />

<asp:BoundField DataField="CounterpartDealRef" HeaderText="CP Deal Ref" ReadOnly="True" />

 

<asp:TemplateField HeaderText="Preliminary Settlement Price" ><ItemTemplate>

<asp:Label ID=lblPreliminary runat=server Text='<%# Bind("PrimarySettlementPrice") %>' />

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox runat="server" ID=txtPrimaryPrice Text='<%# Bind("PrimarySettlementPrice") %>'></asp:TextBox>

 

</EditItemTemplate></asp:TemplateField>

 

<asp:TemplateField HeaderText="Agreed Settlement Price"><ItemTemplate>

<asp:Label ID=lblAgreed runat=server Text='<%# Bind("AgreedSettlementPrice") %>' />

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox runat="server" ID=txtAgreedPrice Text='<%# Bind("AgreedSettlementPrice") %>'></asp:TextBox>

 

</EditItemTemplate></asp:TemplateField>

 

 

<asp:BoundField DataField="Volume" HeaderText="Volume" ReadOnly="True" />

<asp:BoundField DataField="Price" HeaderText="Price" ReadOnly="True" />

<asp:BoundField DataField="TotalVolume" HeaderText="Total Volume" ReadOnly="True" />

<asp:BoundField DataField="InstrumentName" HeaderText="Instrument" ReadOnly="True" />

<asp:BoundField DataField="NominalValue" HeaderText="Nominal Value" ReadOnly="True" />

<asp:BoundField DataField="Strike" HeaderText="Strike" ReadOnly="True" />

<asp:BoundField DataField="DeliveryDate" HeaderText="Delivery Date" ReadOnly="True" />

<asp:TemplateField HeaderText="LegId" SortExpression="LegId">

<ItemTemplate>

<asp:Label ID="lblLegID" runat="server" Text='<%# Bind("LegId") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox runat="server" ID=txtLegID Text='<%# Bind("LegId") %>'></asp:TextBox>

 

</EditItemTemplate>

</asp:TemplateField>

 

 

</Columns>

<RowStyle BackColor="#FFFF66" ForeColor="#333333" />

<EditRowStyle BackColor="#FFFF66" Font-Names="Verdana" Font-Size="X-Small" ForeColor="#333333" />

<PagerStyle ForeColor="White" />

<AlternatingRowStyle BackColor="White" ForeColor="#333333" />

</asp:GridView>

&nbsp;<br />

 

<asp:SqlDataSource ID="SqlDataSource_grid" runat="server" ConnectionString="<%$ ConnectionStrings:DealCaptureDev %>" SelectCommand="sp_get_single_deal" SelectCommandType="StoredProcedure" UpdateCommand="Update trDealLeg Set PrimarySettlementPrice=@primarysettlement, AgreedSettlementprice=@agreedsettlement, LastUpdate=GetDate(), LastUpdateBy=Session('userid') Where LegID=@legid" EnableCaching="True" ConflictDetection="CompareAllValues" ProviderName="System.Data.SqlClient">

<SelectParameters>

<asp:QueryStringParameter DefaultValue="" Name="dealnum" QueryStringField="deal"

Type="String" />

</SelectParameters>

<UpdateParameters>

<asp:ControlParameter ControlID="txtLegId" PropertyName="Text" Name="legId" />

<asp:ControlParameter ControlID="txtPrimarySettlement" Name="primarysettlement" PropertyName="Text" />

<asp:ControlParameter ControlID="txtAgreedSettlement" Name="agreedsettlement" PropertyName="Text"/>

<asp:SessionParameter DefaultValue="" Name="userid" SessionField="userid" />

</UpdateParameters>

</asp:SqlDataSource>

 

As seen above, controls such as txtPrimarySettlement are referenced but the update is not successful. The text boxes are within the GridEditSettlement gridview.  In the .aspx code I cannot use FindControl (at least I don't think it will work).

So the questions are:  Is it possible to reference the child controls, if so - how?  Is there another way to do this, such as in the vb code behind - in the either the gridview's RowUpdating event or the SQLDataSource's Updating event.

What is the best approach?  Anyone come up against this issue before?

 Thanks,

KB