得到错误“''''附近的语法不正确

问题描述

当我在txtdate1中传递日期时，它给出了错误

，当我在两个文本框中都传递日期时，它会给出错误'之间的错误语法'

when i pass date in txtdate1 it give me the error
and when i pass date in both textbox then it give me the error "Incorrect syntax near 'between'

string search = "SELECT Id,Category,Subject,Date FROM News ";
if (txtdate1.Text != "" && txtdate2.Text != "")
{
    search = search + "Where Date between '" + date1 + "' and '" + date2 + "'";
}
else if (txtdate1.Text != "" && txtdate2.Text == "")
{
    search = search + "Where Date = '" + date1 +  "'";
}
else if (txtdate2.Text != "")
{
    search = search + "Where Date = '" + date2 + "'";
}
cmd.CommandText = search;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
gvImages.DataSource = ds;
gvImages.DataBind();

推荐答案

这篇关于得到错误“''''附近的语法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！