我用的是Vs2005,想在当前页用条件模糊查询另一页,另一页是个gridview列表,把查询结果显示在另一页的gridview中,应该怎么弄?请给出全部代码,谢谢
解决方案 »
- 点一个btn,然后手动绑定同页面的DownDropList,不要刷新,能用什么办法
- 请教: seo套路(Baidu)
- 帮帮忙
- 请教BLOG或是网络商城中个人,注册后个人网页的问题
- 网页中显示xml怎样加隔行,每个节点按照格式化的节点输出?内附代码
- 超级简单!Response.Write的问题!快来抢啊!!
- 如何解决中文参数传递
- 孟子老大来帮忙啊!!!!!!!我没分了55555555555555问题发好多遍都没解决
- 自定义的类,报“找不到类型或命名空间名称”。
- 谁能帮我!?谢谢
- 求助...ASP.NET:Regex.Replace在UBB替换[img][/img]标签时出了个怪问题
- <httpModules>加载的程序集,是不是只有项目根目录的才有效果??
protected void Button1_Click(object sender, EventArgs e)
{
string strConn = "Server=song;uid=sa;pwd=;Database=hs_px";
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
DataSet ds = new DataSet();
string strsql="select * from pxjl where 1=1";
cmd.CommandText =strsql ;
adapter.Fill(ds, "pxjl");
GridView gv = new GridView();
gv.DataSource = ds.Tables["pxjl"].DefaultView;
gv.DataBind();
if (Txtnf.Text != "")
{
strsql = strsql + "and nf like '%" + Txtnf.Text + "%'";
Session["nf"] = Txtnf.Text;
}
Response.Redirect("lb.aspx?search");
conn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{ Txtnf.Text = Request.QueryString["nf"];
} protected void Button1_Click(object sender, EventArgs e)
{
string strConn = "Server=song;uid=sa;pwd=;Database=hs_px";
SqlConnection conn = new SqlConnection(strConn);
string strsql = "select * from pxjl";
if (this.Txtnf.Text.Trim()!= "")
{
strsql = strsql+" where nf like '%" + this.Txtnf.Text.Trim() + "%'";
}
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(strsql, conn);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds,"pxjl");
conn.Close();
Response.Redirect("lb.aspx?search");
}
catch
{
Response.Write("<script language='JavaScript'>alert('查询失败!请稍后再试!');window.location='cx.aspx';</script>");
}
conn.Close();
}