CODEWITHSUNDEEP
c#sqlsql-serverado.net
user1501969
user1501969

Reputation: 127

Must declare scalar variable error

I am trying to display sql select results from code-behind and however this error occurred:

Must declare the scalar variable "@poNum".

Line 75: sdsUsers.SelectParameters.Add("@poNum", poNum.Text.Trim());
Line 76:
Line 77: DataView dvMember = (DataView)sdsUsers.Select(DataSourceSelectArguments.Empty); //here the error
Line 78: DataTable tblMember = dvMember.Table;

Code:

string connectionString2 = ConfigurationManager.ConnectionStrings["WholesaleConnectionString"].ConnectionString;
string selectSql = "SELECT invoiceNum, poNum FROM SendInvoice where poNum = @poNum";

SqlDataSource sdsUsers = new SqlDataSource(connectionString2, selectSql); 
sdsUsers.SelectParameters.Clear(); 
sdsUsers.SelectParameters.Add("@poNum", poNum.Text.Trim());

DataView dvMember = (DataView)sdsUsers.Select(DataSourceSelectArguments.Empty); //error occured here 
DataTable tblMember = dvMember.Table;

for(int i=0;i<tblMember.Rows.Count;i++) { 
            if (i==0){ 
             Label aaa = new Label();
             aaa.Text = tblMember.Rows[i].ItemArray[0].ToString();
            } 
        }

I am stuck with this problems for days and I couldn't find a solution

Upvotes: 1

Views: 1476

Answers (2)

Achir Jerome
Achir Jerome

Reputation: 1

sdsUsers.SelectParameters.Clear();

should come after

sdsUsers.SelectParameters.Add("@poNum", poNum.Text.Trim());

Upvotes: 0

sgeddes
sgeddes

Reputation: 62851

I would try removing the @ from the paramater name (leave it in your SQL though):

sdsUsers.SelectParameters.Add("poNum", poNum.Text.Trim());

or (assuming poNum is an int):

sdsUsers.SelectParameters.Add(new Parameter("poNum", System.TypeCode.Int32, poNum));

Good luck.

Upvotes: 2

Related Questions