Odbc stored proc won't accept NULL

Question

0.00/5 (No votes)

See more:

Hi Guys,

Im using a ODBC Connection to call a SP (Sybase Stored Proc), It takes 41 parameters, But only needs 10 of the params to execute.

Works fine in SQL but when i use it in my code im not sure how to supply die blank/NULL Values?

Should it be left out or should i use Quotes ("")?

Here is my code:

C#

OdbcConnection cn;
OdbcCommand cmd;

OdbcDataReader dr;
string connetionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString;

    //Change the connection string to use your SQL Server.
    cn = new OdbcConnection(connetionString);

    //Use ODBC call syntax.
    cmd = new OdbcCommand("{call p_MemberAdd_p ("WHAT DO I DO WITH THE EMPTY ARGUMENTS HERE?")}", cn);

    cn.Open();

    dr = cmd.ExecuteReader();

    //List each product.
    while (dr.Read())
        Label1.Text = dr.GetString(1);
        //Label2.Text = dr.GetString(0);

    //Clean up.
    dr.Close();
    cn.Close();

Posted 19-Mar-12 3:05am

man_in_marak

Updated 19-Mar-12 3:07am

V.

v3

Add a Solution

Comments

V. 19-Mar-12 9:07am

Added Code tags.

2 solutions

Solution 2

This is my code:

cmd = new OdbcCommand("{call p_MemberAdd_p (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}", cn);

SQL

CIS = cmd.Parameters.Add("@CIS", OdbcType.VarChar);
                CIS.Value = DBNull.Value;
                OrgId = cmd.Parameters.Add("@OrgId", OdbcType.VarChar, 20);
                OrgId.Value = "CBS";
                ProductId = cmd.Parameters.Add("@ProductId", OdbcType.VarChar, 20);
                ProductId.Value = "AGR";
                MPAcc = cmd.Parameters.Add("@MPAcc", OdbcType.VarChar, 20);
                MPAcc.Value = DBNull.Value;

With all the other params ofcourse

THANKS!!

Posted 19-Mar-12 3:26am

man_in_marak

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

V. · Accepted Answer · 2012-03-19T03:08:00

Solution 1

Try submitting DBNull.Value

Posted 19-Mar-12 3:08am

V.

Comments

man_in_marak 19-Mar-12 9:15am

Tried this? Same error cmd = new OdbcCommand("{call p_MemberAdd_p (" + DBNull.Value + ")}", cn);

V. 19-Mar-12 9:19am

I think you need to pass it as a parameter, not inline.
Inline is always dangerous btw. (look up : SQL injection)
In this case DBNull.Value will be serialized as a string and this is not what you want to do.

Odbc stored proc won't accept NULL

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Odbc stored proc won't accept NULL

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us