Question

如何将数据库查询结果显示在另外一个页面上的gridview

Answer 1

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
public void bind()
{
string myStr = ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection myConn = new SqlConnection(myStr);
myConn.Open();
SqlDataAdapter myda = new SqlDataAdapter("select * from tb_Usertab", myConn );
DataSet ds = new DataSet();
myda.Fill(ds, "tb_Usertab");
DataView dv = ds.Tables["tb_Usertab"].DefaultView;
this.GridView1.DataKeyNames = new string[] { "用户编号" };
GridView1.DataSource = dv;
this.GridView1.DataBind();
myConn .Close();
}

Answer 2

gridview.databind=datatable;

追问

不行

追答

gridview.datasource= datatable;
gridview.databind();
上面那个有点问题。

Answer 3

两个页面调用同一个Dll