Passing String through C# Code Behind to SQL in .ASPX

Question

I am pretty new at working with this kind of thing so forgive me if my question seems too easy. I have been trying for a while at this and have searched through every relevant article I can find but I cannot get my code to work.

I want to pass a string from 'BadgeNum.Text' through a parameter on the other side and have it execute a query. I cannot get the value to pass correctly and thus cannot get any records to appear out of my query. I have tested the query multiple times using the hard-coded data and it works fine.

Any help here would be greatly appreciated.

<asp:SqlDataSource ID="GridDataSource" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Oracle1TestString %>" 
            ProviderName="<%$ ConnectionStrings:Oracle1TestString.ProviderName %>" 
            SelectCommand="SELECT MODEL_NUMBER, SERIAL_NUMBER, DEFECT_CODE, RECORD_DATE, RECORD_TIME, PRODUCTION_DATE, AUDIT_TYPE FROM AUDITENT WHERE AUDITOR_BADGE = @BadgeNum" 
            onselecting="GridDataSource_Selecting">

            <SelectParameters>
                <asp:Parameter Name="BadgeNum" Direction="Input" DbType="String" />
            </SelectParameters>
        </asp:SqlDataSource>

Here is the code behind (C#):

protected void Page_Load(object sender, EventArgs e) {

        BadgeNum.Text = "0205096";
        Parameter badge = new Parameter();
        badge.DefaultValue = BadgeNum.Text;
        badge.Type = TypeCode.String;
        badge.Name = "BadgeNum";
        GridDataSource.SelectParameters.Add(badge);
        GridDataSource.DataBind();
}

Gratzy · Accepted Answer · 2012-05-16 20:21:23Z

1

OK then is your prefix possibly wrong in your select statement

@BadgeNum

vs

:BadgeNum

edited May 16, 2012 at 20:21

answered May 16, 2012 at 20:05

Gratzy

9,4174 gold badges32 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

se_brandon Over a year ago

That change made the page crash completely with the following server error: Exception Details: System.Data.OracleClient.OracleException: ORA-01036: illegal variable name/number

se_brandon Over a year ago

Actually, I just got the same error by removing the <SelectParameters> section from above. I think the value is actually getting through except that the Oracle DB is having a hard time handling it.

se_brandon Over a year ago

That did it! Thank you so much. You have no idea how much time I spent on this stupid little bug.

Gratzy Over a year ago

No problem, I didn't notice it was the oracle at first look

se_brandon Over a year ago

Actually, now that I got that working, I tried working in my string dates into the code. It looks like this: WHERE AUDITOR_BADGE = :BadgeNum AND RECORD_DATE => TO_DATE(:StartDate, 'MM/DD/YYYY') AND RECORD_DATE <= TO_DATE(:EndDate, 'MM/DD/YYYY') This caused an exception now too as well.

|

Collectives™ on Stack Overflow

Passing String through C# Code Behind to SQL in .ASPX

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related