Syntax error in SELECT WHERE using ADO.Net parameters [closed]

Question

Syntax error in SELECT WHERE using ADO.Net parameters [closed]

Navigation

#1 by (5 votes)
#2 by (4 votes)

1

Does anyone understand this error and get a solution?

Code:

OleDbConnectionConSelect=newOleDbConnection();ConSelect.ConnectionString=Properties.Settings.Default.dbInvoice;ConSelect.Open();OleDbCommandCmmSelect=newOleDbCommand();CmmSelect.CommandText="SELECT Qtd, UnitPriceInv FROM JAN WHERE EmgPartInv = ? AND CodCliInv = ? AND InvoiceName = ? ";
CmmSelect.Parameters.Add("@EmgPart", OleDbType.VarChar, 10).Value = txtEmg.Text;
CmmSelect.Parameters.Add("@CodCli", OleDbType.Integer, 18).Value = txtCodCli.Text;
CmmSelect.Parameters.Add("@Invoice", OleDbType.VarChar, 15).Value = label45.Text;

CmmSelect.CommandType = CommandType.Text;
CmmSelect.Connection = ConSelect;
OleDbDataReader DRSelectCond;
DRSelectCond = CmmSelect.ExecuteReader();
DRSelectCond.Read();

sql sql-server c# .net ado.net

asked by anonymous 29.08.2016 / 18:09

2 answers

4

This will make it right:

"SELECT Qtd, UnitPriceInv FROM JAN WHERE EmgPartInv = @EmgPart AND CodCliInv = @CodCli AND InvoiceName = @Invoice"

Documentation .

29.08.2016 / 18:32

How the switch works How to transform text into input text when clicking?

score 5 · Accepted Answer

It seems simple, replace the commas with AND :

"... EmgPartInv = ? AND CondCliInv=? AND InvoiceName = ?"

Next for "No value given for one or more required parameters." You're saying there's no pro-parameter value, change your query to:

CmmSelect.CommandText = "SELECT Qtd, UnitPriceInv FROM JAN WHERE EmgPartInv = @EmgPart AND CodCliInv = @CodCli AND InvoiceName = @Invoice ";
CmmSelect.Parameters.Add("@EmgPart", OleDbType.VarChar, 10).Value = txtEmg.Text;
CmmSelect.Parameters.Add("@CodCli", OleDbType.Integer, 18).Value = txtCodCli.Text;
CmmSelect.Parameters.Add("@Invoice", OleDbType.VarChar, 15).Value = label45.Text;