Incorrect syntxt near '?'

Israel

Hi,

I worte these codes and its works very well when I use MSAccess Database. Curiosly doesnt works usin sql database. When I make filter its gives this message: Incorrect syntax near '?'

Please any help:

conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
//cmd.CommandText = "select * from taxas_habitacionais where (data between ? and ?) and name = ?";
cmd.CommandText = "select * from livro1 where (data between ? and ?)";
var param1 = new SqlParameter("@StartDate", SqlDbType.Date);
var param2 = new SqlParameter("@EndDate", SqlDbType.Date);
//var param3 = new OleDbParameter("@name", OleDbType.VarChar); // use actual type of 'name' here
param1.Value = dtInicialLivro1.Value.Date;
param2.Value = dtFinalLivro1.Value.Date;
//param3.Value = txtConsFaltasPorNomes.Text; // or whatever
if (dtFinalLivro1.Value <= dtInicialLivro1.Value)
{
cmd.Parameters.Add(param1);
cmd.Parameters.Add(param2);
}
else
{
cmd.Parameters.Add(param2);
cmd.Parameters.Add(param1);
}
//cmd.Parameters.Add(param3);
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
conn.Close();
dgvLivro1.DataSource = dt;

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth8y ago
Accepted answer
Hi,

The query is wrong !! You need to pass a parameter in the command text..
cmd.CommandText = "select * from livro1 where (data between ? and ?)";
Try this code :
cmd.CommandText = "select * from livro1 where data between @data1 and @data2";
Reference :
http://www.dofactory.com/sql/where-between

https://stackoverflow.com/questions/12312898/how-to-pass-int-parameters-in-sql-commandtext?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa
+1
Israel8y ago
Thank you to all. Especially to Rajeesh Menoth. Your codes had resolved the problem.
0
Yogesh Ghorpade8y ago
Remove Brackets And Check Once - (data between ? and ?)";
-1