datagrid不显示数据问题。

来源：百度知道 编辑：UC知道 时间：2024/05/21 12:47:32
代码如下：
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
SqlConnection newcon=new SqlConnection();
newcon.ConnectionString="Data Source=127.0.0.1;Initial Catalog=web1_login;User ID=iuser;Password=111";
newcon.Open();

SqlCommand newcom=new SqlCommand();
newcom.Connection=newcon;
string stringselect="select id,name,contentnum,content from userinfo";
newcom.CommandText=stringselect;

SqlDataAdapter newda=new SqlDataAdapter(stringselect,newcon);
DataSet newds=new DataSet();
newda.Fill(newds,"userinfo");
Response.Write("open success!");
datagrid1.DataSource=newds.Tables["userinfo"].DefaultView;
datagrid1.DataBind();
}
private void datagrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
this.datagrid1.Cu

代码如下：
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
SqlConnection newcon=new SqlConnection();
newcon.ConnectionString="Data Source=127.0.0.1;Initial Catalog=web1_login;User ID=iuser;Password=111";

newcom.Connection=newcon; //////////********

newcon.Open();

SqlCommand newcom=new SqlCommand();

string stringselect="select id,name,contentnum,content from userinfo";
newcom.CommandText=stringselect;

SqlDataAdapter newda=new SqlDataAdapter(stringselect,newcon);
DataSet newds=new DataSet();
newda.Fill(newds,"userinfo");
Response.Write("open success!");
datagrid1.DataSource=newds.Tables["userinfo"].DefaultView;
datagrid1.DataBind();
}
private void datagrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
this.datagrid1