我的DataGrid控件,我已经成功将DataSet邦定到了datagrid,但是为什么我在测试浏览时,
只显示出表的字段名,而数据却显示不出来。(DataSet里边肯定是有数据的).我的代码:
SqlConnection conn2=new SqlConnection(strconn);
SqlCommand comm2=conn2.CreateCommand();
comm2.CommandText="select * from worker_info";
SqlDataAdapter da=new SqlDataAdapter();
da.SelectCommand=comm2;
DataSet dss=new DataSet();
conn2.Open();
dss.Clear();
int r=da.Fill(dss,"worker");
label1.Text=r.ToString();
conn2.Close();
datagrid.DataSource=dss.Tables["worker"];
datagrid.DataBind();
只显示出表的字段名,而数据却显示不出来。(DataSet里边肯定是有数据的).我的代码:
SqlConnection conn2=new SqlConnection(strconn);
SqlCommand comm2=conn2.CreateCommand();
comm2.CommandText="select * from worker_info";
SqlDataAdapter da=new SqlDataAdapter();
da.SelectCommand=comm2;
DataSet dss=new DataSet();
conn2.Open();
dss.Clear();
int r=da.Fill(dss,"worker");
label1.Text=r.ToString();
conn2.Close();
datagrid.DataSource=dss.Tables["worker"];
datagrid.DataBind();
myCommand.Fill(ds, "Authors"); MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();
myCommand.Fill(ds, "Authors"); MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();
SqlCommand comm2=conn2.CreateCommand();
comm2.CommandText="select * from worker_info";
SqlDataAdapter da=new SqlDataAdapter();
da.SelectCommand=comm2;
DataSet dss=new DataSet();
conn2.Open();
int r=da.Fill(dss,"worker");
label1.Text=r.ToString();
datagrid.DataSource=dss.Tables["worker"];
datagrid.DataBind();
conn2.Close();