search.aspx页面后台代码,说明:这是让用户填写搜索条件的页面protected void Button1_Click(object sender, System.EventArgs e)
{
//重定向到搜索结果页,并传送搜索条件
Session["Bclass_Name"] = TB_Author.Text;
Session["p_name"] = TextBox1.Text;
this.Response.Redirect("searched.aspx?Bclass_Name=" + TB_Author.Text + "&p_name=" + TextBox1.Text + "&p_text=" + TB_Q_Note.Text);
}
searched.aspx页面后台代码,说明:这是显示用户搜索结果的页面public partial class searched : System.Web.UI.Page
{
public void BindGrid()
{
string con, tpf,Bid=null ,Name=null;
string DBtype = ConfigurationManager.AppSettings["DBtype"];
tpf = "%";
if (Request.QueryString["p_text"] == "%")
con = tpf;
else
con = tpf + Request.QueryString["p_text"].ToString() + tpf;
if (Request.QueryString["Bclass_Name"].ToString() != null)
Bid = tpf + Request.QueryString["Bclass_Name"].ToString() + tpf;
if (Request.QueryString["p_name"].ToString() != null)
Name = tpf + Request.QueryString["p_name"].ToString() + tpf;
string sql1;
if (Request.QueryString["p_name"].ToString() == null)
{
if (Request.QueryString["Bclass_Name"].ToString() == null)
{
sql1 = "SELECT p_id,p_name, BigClass_ID,p_count , p_price, p_text FROM Parts" +
" WHERE (p_text LIKE @p_text)";
}
else
{
sql1 = "SELECT p_id,p_name,Parts.BigClass_ID,b.BigClass_ID, b.BigClass_Name,p_count , p_price, p_text FROM Parts,Bclass as b" +
" WHERE (Parts.BigClass_ID=b.BigClass_ID)AND(BigClass_Name =@BigClassName) AND (p_text LIKE @p_text)";
}
}
else
{
if (Request.QueryString["Bclass_Name"].ToString() == null)
{
sql1 = "SELECT p_id,p_name, BigClass_ID,p_count , p_price, p_text FROM Parts" +
" WHERE (p_text LIKE @p_text) AND (p_name =@p_name)";
}
else
{
sql1 = "SELECT p_id,p_name,Parts.BigClass_ID,b.BigClass_ID, b.BigClass_Name,p_count , p_price, p_text FROM Parts,Bclass as b" +
" WHERE (Parts.BigClass_ID=b.BigClass_ID)AND(BigClass_Name =@BigClassName) AND (p_text LIKE @p_text) AND (p_name =@p_name)";
}
} if (DBtype == "Accsee")
{
DBsql exsql = new DBsql();
exsql.Open();
OleDbDataAdapter da = new OleDbDataAdapter(sql1, exsql.con); if (Request.QueryString["BID"] != null)
{
da.SelectCommand.Parameters.Add("@BigClassName", OleDbType.VarChar, 160, "BigClass_Name").Value = Bid; }
if (Request.QueryString["p_name"] != null)
{
da.SelectCommand.Parameters.Add("@p_name", OleDbType.VarChar, 160, "p_name").Value = Name; }
da.SelectCommand.Parameters.Add("@p_text", OleDbType.VarChar, 160, "p_text").Value = con; DataSet ds = new DataSet();
da.Fill(ds);
exsql.Close();
this.DL_Main.DataSource = ds.Tables[0];
this.DL_Main.DataBind();
}protected void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (Request.QueryString["p_text"]==null)
Lblsearch.Text="没有输入关键字";
else
{
Lblsearch.Text="关键字:"+Request.QueryString["p_text"].ToString();
BindGrid();
}
}
{
//重定向到搜索结果页,并传送搜索条件
Session["Bclass_Name"] = TB_Author.Text;
Session["p_name"] = TextBox1.Text;
this.Response.Redirect("searched.aspx?Bclass_Name=" + TB_Author.Text + "&p_name=" + TextBox1.Text + "&p_text=" + TB_Q_Note.Text);
}
searched.aspx页面后台代码,说明:这是显示用户搜索结果的页面public partial class searched : System.Web.UI.Page
{
public void BindGrid()
{
string con, tpf,Bid=null ,Name=null;
string DBtype = ConfigurationManager.AppSettings["DBtype"];
tpf = "%";
if (Request.QueryString["p_text"] == "%")
con = tpf;
else
con = tpf + Request.QueryString["p_text"].ToString() + tpf;
if (Request.QueryString["Bclass_Name"].ToString() != null)
Bid = tpf + Request.QueryString["Bclass_Name"].ToString() + tpf;
if (Request.QueryString["p_name"].ToString() != null)
Name = tpf + Request.QueryString["p_name"].ToString() + tpf;
string sql1;
if (Request.QueryString["p_name"].ToString() == null)
{
if (Request.QueryString["Bclass_Name"].ToString() == null)
{
sql1 = "SELECT p_id,p_name, BigClass_ID,p_count , p_price, p_text FROM Parts" +
" WHERE (p_text LIKE @p_text)";
}
else
{
sql1 = "SELECT p_id,p_name,Parts.BigClass_ID,b.BigClass_ID, b.BigClass_Name,p_count , p_price, p_text FROM Parts,Bclass as b" +
" WHERE (Parts.BigClass_ID=b.BigClass_ID)AND(BigClass_Name =@BigClassName) AND (p_text LIKE @p_text)";
}
}
else
{
if (Request.QueryString["Bclass_Name"].ToString() == null)
{
sql1 = "SELECT p_id,p_name, BigClass_ID,p_count , p_price, p_text FROM Parts" +
" WHERE (p_text LIKE @p_text) AND (p_name =@p_name)";
}
else
{
sql1 = "SELECT p_id,p_name,Parts.BigClass_ID,b.BigClass_ID, b.BigClass_Name,p_count , p_price, p_text FROM Parts,Bclass as b" +
" WHERE (Parts.BigClass_ID=b.BigClass_ID)AND(BigClass_Name =@BigClassName) AND (p_text LIKE @p_text) AND (p_name =@p_name)";
}
} if (DBtype == "Accsee")
{
DBsql exsql = new DBsql();
exsql.Open();
OleDbDataAdapter da = new OleDbDataAdapter(sql1, exsql.con); if (Request.QueryString["BID"] != null)
{
da.SelectCommand.Parameters.Add("@BigClassName", OleDbType.VarChar, 160, "BigClass_Name").Value = Bid; }
if (Request.QueryString["p_name"] != null)
{
da.SelectCommand.Parameters.Add("@p_name", OleDbType.VarChar, 160, "p_name").Value = Name; }
da.SelectCommand.Parameters.Add("@p_text", OleDbType.VarChar, 160, "p_text").Value = con; DataSet ds = new DataSet();
da.Fill(ds);
exsql.Close();
this.DL_Main.DataSource = ds.Tables[0];
this.DL_Main.DataBind();
}protected void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (Request.QueryString["p_text"]==null)
Lblsearch.Text="没有输入关键字";
else
{
Lblsearch.Text="关键字:"+Request.QueryString["p_text"].ToString();
BindGrid();
}
}
解决方案 »
- Excel导出页面Web.UI.HtmlControl一直是导出前面的缓存
- juniper 开放80端口 www.sxsjjzx.com:8080如何去掉8080
- AjaxPro.Method调用为什么总是返回null
- 关于SESSION不稳定的问题
- 郁闷阿!用户控件缓存莫名其妙的问题
- 从客户端(FONT style= FONT-FA... )中检测到有潜在危险Request.Form 值
- 高手请进 SQL图片显示问题
- 请问可以选择日期的控件在哪里,也就是可以选择日期的textbox
- 把freetextbox添加到工具箱时报错?请大家帮忙看看
- asp.net获取用户所用的浏览器的类型
- c#光标问题
- asp.net 上的错误
string sql="select * from Tb where 1=1";
sql+=string.IsNullorEmpty(值)?"":" and ";
public partial class EditBClass : System.Web.UI.Page
{ protected void Page_Load(object sender, System.EventArgs e)
{
} public void BindGrid()
{
DGBClass.DataSource = (DataTable)Session["dt"];
this.Page.DataBind(); }
public void BindList()
{
DropDownList1.DataSource = DBOperate.SelectFormForum("SELECT pro_name FROM project ");
DropDownList1.DataBind();
}
看是不是SQL出错了 还是怎么回事?
或用上楼说的试下。
以及SQL查询语句的编写问题!!!
这是涉及到数据库后台的问题!!!