通过搜索数据库用gridview显示.代码如下:
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=addperson;pwd=sa;uid=sa;");
con.Open();
string cmdtxt3 = "select id,kb,jz,gh,xm,rsr,csnyr,dlrq from personlist where gh=" + this.TextBox1.Text.Trim() + "";
SqlDataAdapter da = new SqlDataAdapter(cmdtxt3, con);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
Response.Write("<script language=javascript> window.open('xiangxi.aspx?id=" + TextBox1 + "','查询结果','height=600,width=500,status=no,scrollbars=yes,toolbar=no,menubar=no,location=no') </script>");
}
}在通过选择详细按钮,弹出 xiangxi.aspx这个页面,这个页面用detailsview接收显示数据库的所有数据.请问这个怎么实现?
请详细一点说明吧,我都搞了一天都没有搞定..
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=addperson;pwd=sa;uid=sa;");
con.Open();
string cmdtxt3 = "select id,kb,jz,gh,xm,rsr,csnyr,dlrq from personlist where gh=" + this.TextBox1.Text.Trim() + "";
SqlDataAdapter da = new SqlDataAdapter(cmdtxt3, con);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
Response.Write("<script language=javascript> window.open('xiangxi.aspx?id=" + TextBox1 + "','查询结果','height=600,width=500,status=no,scrollbars=yes,toolbar=no,menubar=no,location=no') </script>");
}
}在通过选择详细按钮,弹出 xiangxi.aspx这个页面,这个页面用detailsview接收显示数据库的所有数据.请问这个怎么实现?
请详细一点说明吧,我都搞了一天都没有搞定..
在通过获取到的id值进行数据库查询
select id,title,xxx from table where id=@id
....
在按钮的Click事件用Response.Redirect("新页面.aspx?参数=值");新页面的Page_Load事件用Request.QueryString["参数"]来获取