Ad:

ASP.NET Discussion Thread
Unsolved
Views: 1417

Feb 5th, 2010

-1

Gridview will not update using sqldata source

Expand Post »

Hi,

I'm new to Asp.net and I'm using Oracle database. I'm having no luck getting my gridview to update. When I test my update query in the datasource it updates but when I use the gridview it gives me this error "ORA-01036: illegal variable name/number".
Please help.

ASP.NET Syntax (Toggle Plain Text)
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:chrhrdm %>"
        ProviderName="<%$ ConnectionStrings:chrhrdm.ProviderName %>" SelectCommand='SELECT UNIQUE_NO, SURNAME, INITIALS, DIVISION, BU_SUBAREA, EMPLOYEE_TYPE, SALARY_MODELING, APPL_GA20, LETTER_APP FROM SSU_EMPDETAILS' EnableCaching="True" UpdateCommand='UPDATE SSU_EMPDETAILS SET SALARY_MODELING = :sal, APPL_GA20 = :appl, LETTER_APP = :letter WHERE (UNIQUE_NO = :unq_no)'>
    <UpdateParameters>
        <asp:Parameter Name="sal" />
        <asp:Parameter Name="appl" />
        <asp:Parameter Name="letter" />
        <asp:Parameter Name="unq_no" />
        </UpdateParameters>
    </asp:SqlDataSource>
    &nbsp;&nbsp;
    <asp:Label ID="Label1" runat="server" Text="Please select date to view data" Width="192px"></asp:Label><br />
    <asp:DropDownList ID="ddl_PayrolDate" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2"
        DataTextField="PAYROLL_DATE" DataValueField="PAYROLL_DATE">
    </asp:DropDownList>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:chrhrdm %>"
        ProviderName="<%$ ConnectionStrings:chrhrdm.ProviderName %>" SelectCommand="SELECT DISTINCT PAYROLL_DATE FROM SDM_PERSON" UpdateCommand='UPDATE SSU_EMPDETAILS SET SURNAME = @Surname, INITIALS = @Initials'>
    </asp:SqlDataSource>
    &nbsp; &nbsp; &nbsp;&nbsp;
    <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="False" DataKeyNames="UNIQUE_NO">
              <Columns>
                  <asp:CommandField ShowEditButton="True" ShowSelectButton="True" />
                  <asp:BoundField DataField="UNIQUE_NO" HeaderText="UNIQUE_NO" ReadOnly="True" SortExpression="UNIQUE_NO" />
                  <asp:BoundField DataField="SURNAME" HeaderText="SURNAME" SortExpression="SURNAME" ReadOnly="True" />
                  <asp:BoundField DataField="INITIALS" HeaderText="INITIALS" SortExpression="INITIALS" ReadOnly="True" />
                  <asp:BoundField DataField="DIVISION" HeaderText="DIVISION" SortExpression="DIVISION" ReadOnly="True" />
                  <asp:BoundField DataField="BU_SUBAREA" HeaderText="BU_SUBAREA" SortExpression="BU_SUBAREA" ReadOnly="True" />
                  <asp:BoundField DataField="EMPLOYEE_TYPE" HeaderText="EMPLOYEE_TYPE" SortExpression="EMPLOYEE_TYPE" ReadOnly="True" />
                  <asp:BoundField DataField="SALARY_MODELING" HeaderText="SALARY_MODELING" SortExpression="SALARY_MODELING" />
                  <asp:BoundField DataField="APPL_GA20" HeaderText="APPL_GA20" SortExpression="APPL_GA20" />
                  <asp:BoundField DataField="LETTER_APP" HeaderText="LETTER_APP" SortExpression="LETTER_APP" />
        </Columns>
    </asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:chrhrdm %>"
        ProviderName="<%$ ConnectionStrings:chrhrdm.ProviderName %>" SelectCommand='SELECT UNIQUE_NO, SURNAME, INITIALS, DIVISION, BU_SUBAREA, EMPLOYEE_TYPE, SALARY_MODELING, APPL_GA20, LETTER_APP FROM SSU_EMPDETAILS' EnableCaching="True" UpdateCommand='UPDATE SSU_EMPDETAILS SET SALARY_MODELING = :sal, APPL_GA20 = :appl, LETTER_APP = :letter WHERE (UNIQUE_NO = :unq_no)'>
    <UpdateParameters>
        <asp:Parameter Name="sal" />
        <asp:Parameter Name="appl" />
        <asp:Parameter Name="letter" />
        <asp:Parameter Name="unq_no" />
        </UpdateParameters>
    </asp:SqlDataSource>
    &nbsp;&nbsp;
    <asp:Label ID="Label1" runat="server" Text="Please select date to view data" Width="192px"></asp:Label><br />
    <asp:DropDownList ID="ddl_PayrolDate" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2"
        DataTextField="PAYROLL_DATE" DataValueField="PAYROLL_DATE">
    </asp:DropDownList>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:chrhrdm %>"
        ProviderName="<%$ ConnectionStrings:chrhrdm.ProviderName %>" SelectCommand="SELECT DISTINCT PAYROLL_DATE FROM SDM_PERSON" UpdateCommand='UPDATE SSU_EMPDETAILS SET SURNAME = @Surname, INITIALS = @Initials'>
    </asp:SqlDataSource>
    &nbsp; &nbsp; &nbsp;&nbsp;
    <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="False" DataKeyNames="UNIQUE_NO">
              <Columns>
                  <asp:CommandField ShowEditButton="True" ShowSelectButton="True" />
                  <asp:BoundField DataField="UNIQUE_NO" HeaderText="UNIQUE_NO" ReadOnly="True" SortExpression="UNIQUE_NO" />
                  <asp:BoundField DataField="SURNAME" HeaderText="SURNAME" SortExpression="SURNAME" ReadOnly="True" />
                  <asp:BoundField DataField="INITIALS" HeaderText="INITIALS" SortExpression="INITIALS" ReadOnly="True" />
                  <asp:BoundField DataField="DIVISION" HeaderText="DIVISION" SortExpression="DIVISION" ReadOnly="True" />
                  <asp:BoundField DataField="BU_SUBAREA" HeaderText="BU_SUBAREA" SortExpression="BU_SUBAREA" ReadOnly="True" />
                  <asp:BoundField DataField="EMPLOYEE_TYPE" HeaderText="EMPLOYEE_TYPE" SortExpression="EMPLOYEE_TYPE" ReadOnly="True" />
                  <asp:BoundField DataField="SALARY_MODELING" HeaderText="SALARY_MODELING" SortExpression="SALARY_MODELING" />
                  <asp:BoundField DataField="APPL_GA20" HeaderText="APPL_GA20" SortExpression="APPL_GA20" />
                  <asp:BoundField DataField="LETTER_APP" HeaderText="LETTER_APP" SortExpression="LETTER_APP" />
        </Columns>
    </asp:GridView>

Similar Threads

GridView Update on Single row in ASP.NET
Gridview Update Problem in ASP.NET
Ajax post back problem when using GridView with Object Data Source in ASP.NET
Display Image in GridView in ASP.NET
Editing in GridView Control in ASP.NET

Nonki

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Feb 2010

Permalink

Feb 6th, 2010

Re: Gridview will not update using sqldata source

Quote ...

<UpdateParameters>

<asp: Parameter Name="SALARY_MODELINGl" />
<asp: Parameter Name="APPL_GA20" />

<asp: Parameter Name="LETTER_APP" />

<asp: Parameter Name="UNIQUE_NO" />
</UpdateParameters>

change parameter name like above . sortexpression and query parameter may be mismatch

kdcorp87

Reputation Points: 14

Solved Threads: 9

Junior Poster in Training

Offline

54 posts
since Jan 2010

Permalink

Feb 8th, 2010

Re: Gridview will not update using sqldata source

Hi,

I've changed the parameter name as you did but I still get the same error.

Nonki

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Feb 2010

Permalink

Feb 8th, 2010

Re: Gridview will not update using sqldata source

ASP.NET Syntax (Toggle Plain Text)

UpdateCommand='UPDATE SSU_EMPDETAILS SET SALARY_MODELING = :sal, APPL_GA20 = :appl, LETTER_APP = :letter WHERE (UNIQUE_NO = :unq_no)'>

do u cng parameter name in here? cause i fall in same error some week ago, when i maintain name parameter name pron was solve

kdcorp87

Reputation Points: 14

Solved Threads: 9

Junior Poster in Training

Offline

54 posts
since Jan 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: How to check session object is deleted or not

Next Thread in ASP.NET Forum Timeline: C#/Commented code running

DaniWeb Message

Cancel Changes

User Name
Password