Hi

I have been trying to figure out what went wrong. I followed the example on th code library Automatic insert/update/delete using ObjectDataSource.

please help. Thanks a million.

ALTER PROCEDURE [dbo].[spUpdPerInfo]
@ID as nvarchar(100),
@ContactNo as nvarchar(20),
@Email as nvarchar(100),
@ModDate as datetime,

as

UPDATE [tblPerInfo] SET [ContactNo] = @ContactNo, [Email] = @Email, [ModDate] = @ModDate WHERE [ID] = @ID

--------------------------------------------------------------------------------------------------------------------------------------------------

Public Sub PerInfo_Update(ByVal ID As String, ByVal ContactNo As String, ByVal Email As String)

        Dim sqlcmd As New SqlCommand("spUpdPerInfo", getConn)
        sqlcmd.CommandType = CommandType.StoredProcedure
 
        sqlcmd.Parameters.Add(New SqlParameter("@ID", SqlDbType.NVarChar, 50))
        sqlcmd.Parameters("@ID").Value = ID
        sqlcmd.Parameters.Add(New SqlParameter("@ContactNo", SqlDbType.NVarChar, 50))
        sqlcmd.Parameters("@ContactNo").Value = ContactNo

        sqlcmd.Parameters.Add(New SqlParameter("@Email", SqlDbType.NVarChar, 500))
        sqlcmd.Parameters("@Email").Value = Email

        sqlcmd.Parameters.Add(New SqlParameter("@ModDate", SqlDbType.DateTime))
        sqlcmd.Parameters("@ModDate").Value = DateTime.Now

        sqlcmd.ExecuteNonQuery()

        getConn.Close()

End Sub

-------------------------------------------------------------------------------------------------------------
<telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True"
                    DataSourceID="ObjectDataSource1" GridLines="None" 
                    AutoGenerateColumns="False" AllowAutomaticUpdates="True">
<MasterTableView DataKeyNames="ID" DataSourceID="ObjectDataSource1">
<RowIndicatorColumn Visible="False">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>

<ExpandCollapseColumn Visible="False" Resizable="False">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>

    <Columns>
        <telerik:GridBoundColumn DataField="ID" DataType="System.String" HeaderText="ID"
          readonly="true"  UniqueName="ID" SortExpression="ID">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ContactNo" HeaderText="Contact No"
            UniqueName="ContactNo"  SortExpression="ContactNo">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Email" HeaderText="Email"
            UniqueName="Email"  SortExpression="Email">
        </telerik:GridBoundColumn >
     </Columns>
<telerik:GridEditCommandColumn UniqueName="EditCommandColumn" />
<EditFormSettings>

<PopUpSettings ScrollBars="None"></PopUpSettings>
</EditFormSettings>
</MasterTableView>
                </telerik:RadGrid>
                <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
                    SelectMethod="SearchID" TypeName="DAL" UpdateMethod="PerInfo_Update">
                    <UpdateParameters>
                        <asp:Parameter Name="ID" Type="String" />
                        <asp:Parameter Name="ContactNo" Type="String" />
                        <asp:Parameter Name="Email" Type="String" />                    
                    </UpdateParameters>
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="alpha" Name="choice" SessionField="choice"
                            Type="String" />
                        <asp:SessionParameter DefaultValue="A" Name="search" SessionField="value"
                            Type="String" />
                    </SelectParameters>
                </asp:ObjectDataSource>
          

Hi,

 I am using RadGrid  and I designed the UI with Telerik Controls.

I had 3 Text boxes such as “txt_A”,”txt_B” and “txt_C” and I am adding as “txt_A”,”txt_B” values at client side and displaying in to “txt_C”.

In this manner I  have to implement DML Operations(Insertion/Updation). I am successfully inserting record, but come to the point of implementing Update functionality i am getting the problem.

Before Explaining the problem let me explain how I am implementing the TextBox Calculations…

 Iam performing this Operation as follow …

var price = document.getElementById('ctl00_ContentPlaceHolder1_rgRFQResponseDetails_ctl00_ctl02_ctl03_txtResDetailsPrice');

    var txtPriceinsUS = document.getElementById('ctl00_ContentPlaceHolder1_rgRFQResponseDetails_ctl00_ctl02_ctl03_txtPriceinsUS');

Problem

In this manner I have inserted 3 records and now 3 records are Binded to  Grid.

 But while updating the record I am not getting the Control ID as same Above.. here I am getting 3 Id each..for example here I am mentioning the one Control ID as follows while updating 1^st record.

       price = document.getElementById('ctl00_ContentPlaceHolder1_rgRFQResponseDetails_ctl00_ctl05_txtResDetailsPrice');

var txtPriceinsUS = document.getElementById('ctl00_ContentPlaceHolder1_rgRFQResponseDetails_ctl00_ctl02_ctl05_txtPriceinsUS');

For 2^nd Record Updation:-

price = document.getElementById('ctl00_ContentPlaceHolder1_rgRFQResponseDetails_ctl00_ctl07_txtResDetailsPrice');

var txtPriceinsUS = document.getElementById('ctl00_ContentPlaceHolder1_rgRFQResponseDetails_ctl00_ctl02_ctl07_txtPriceinsUS');

so on…

Please help me how to find the Exact ID even while Updating (static ID)..