页面上有一个dropdownlist、一个textbox,和一个已经绑定数据的gridview,前两个主要是来设置查询条件的,点击button按钮后,按照查询条件gridview显示符合查询条件的数据信息:
其中ProntoName、Status、ModuleName都是表Pronto的字段
运行后显示‘and’附近有语法错误,各位高手请指点指点
代码如下:
protected void Button8_Click(object sender, EventArgs e)
{
string sql = "select *from Pronto ";
if (ProntoName.Text != "")
sql = sql + " and ProntoName like '%" + ProntoName.Text.ToString() + "%'";
if (DropDownList1.SelectedItem.Value != "")
sql = sql + " and Status " + DropDownList1.SelectedValue.ToString() ;
if (DropDownList2.SelectedItem.Value != "")
sql = sql + " and ModuleName " + DropDownList2.SelectedValue.ToString();
SqlDataSource1.SelectCommand = sql;
dy.DataBind();
int li_row;
int li_rowcount = dy.Rows.Count;
for (int i = 0; i < li_rowcount; i++)
{ li_row = i + 1;
dy.Rows[i].Cells[1].Text = li_row.ToString();
}
if (li_rowcount == 0)
{
Response.Write("没有找到任何记录。");
}
其中ProntoName、Status、ModuleName都是表Pronto的字段
运行后显示‘and’附近有语法错误,各位高手请指点指点
代码如下:
protected void Button8_Click(object sender, EventArgs e)
{
string sql = "select *from Pronto ";
if (ProntoName.Text != "")
sql = sql + " and ProntoName like '%" + ProntoName.Text.ToString() + "%'";
if (DropDownList1.SelectedItem.Value != "")
sql = sql + " and Status " + DropDownList1.SelectedValue.ToString() ;
if (DropDownList2.SelectedItem.Value != "")
sql = sql + " and ModuleName " + DropDownList2.SelectedValue.ToString();
SqlDataSource1.SelectCommand = sql;
dy.DataBind();
int li_row;
int li_rowcount = dy.Rows.Count;
for (int i = 0; i < li_rowcount; i++)
{ li_row = i + 1;
dy.Rows[i].Cells[1].Text = li_row.ToString();
}
if (li_rowcount == 0)
{
Response.Write("没有找到任何记录。");
}
using System.Text;
...
StringBuilder sb = new StringBuilder();
sb.Append("select * from Pronto where 1=1 ");
if (ProntoName.Text != "")
sb.Append(" and ProntoName like '%" + ProntoName.Text.ToString() + "%' ");
if (DropDownList1.SelectedItem.Value != "")
sb.Append(" and Status " + DropDownList1.SelectedValue.ToString()) ;
if (DropDownList2.SelectedItem.Value != "")
sb.Append(" and ModuleName " + DropDownList2.SelectedValue.ToString());
SqlDataSource1.SelectCommand = sb.ToString();
还有,不需要 dy.DataBind(); 吗?
还有,不需要 dy.DataBind(); 吗?
using System.Text;
...
StringBuilder sb = new StringBuilder();
sb.Append("select * from Pronto where 1=1 ");
if (ProntoName.Text != "")
sb.Append(" and ProntoName like '%" + ProntoName.Text.ToString() + "%' ");
if (DropDownList1.SelectedItem.Value != "")
sb.Append(" and Status= '" + DropDownList1.SelectedItem.Value.ToString().Trim()+"' ") ;
if (DropDownList2.SelectedItem.Value != "")
sb.Append(" and ModuleName= '" + DropDownList2.SelectedItem.Value.ToString().Trim()+"' ");
SqlDataSource1.SelectCommand = sb.ToString();
using System.Text;
...
StringBuilder sb = new StringBuilder();
sb.Append("select * from Pronto where 1=1 ");
if (ProntoName.Text != "")
sb.Append(" and ProntoName like '%" + ProntoName.Text.ToString() + "%' ");
if (DropDownList1.SelectedItem.Text != "")
sb.Append(" and Status=' " + DropDownList1.SelectedItem.Text.ToString().Trim()+"' ") ;
if (DropDownList2.SelectedItem.Text != "")
sb.Append(" and ModuleName='" +DropDownList2.SelectedItem.Text.ToString().Trim()+"' ") ;
SqlDataSource1.SelectCommand = sb.ToString();