我在窗口初始化里写了如下内容,现在我要接着判断,如果数据集为空,则不显示DataGrid,
如果数据集不为空,则显示DataGrid
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection conn=new SqlConnection();
conn.ConnectionString="server=wshss;database=ASPNETOA;user id=sa;pwd=123";
string strsql="SELECT name,comname,duty,comtel,handtel FROM grmp";
SqlDataAdapter da=new SqlDataAdapter(strsql,conn);
DataSet ds=new DataSet();
da.Fill(ds,"grmp");
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
//
}
如果数据集不为空,则显示DataGrid
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection conn=new SqlConnection();
conn.ConnectionString="server=wshss;database=ASPNETOA;user id=sa;pwd=123";
string strsql="SELECT name,comname,duty,comtel,handtel FROM grmp";
SqlDataAdapter da=new SqlDataAdapter(strsql,conn);
DataSet ds=new DataSet();
da.Fill(ds,"grmp");
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
//
}
{
SqlConnection conn=new SqlConnection();
conn.ConnectionString="server=wshss;database=ASPNETOA;user id=sa;pwd=123";
string strsql="SELECT name,comname,duty,comtel,handtel FROM grmp";
SqlDataAdapter da=new SqlDataAdapter(strsql,conn);
DataSet ds=new DataSet();
da.Fill(ds,"grmp");
if (ds.Tables[grmp] == null || ds.Tables["grmp"].Rows.Count == 0)
DataGrid.Visible = false;
else
{
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
}
//
}
这样不行么
{
SqlConnection conn=new SqlConnection();
conn.ConnectionString="server=wshss;database=ASPNETOA;user id=sa;pwd=123";
string strsql="SELECT name,comname,duty,comtel,handtel FROM grmp";
SqlDataAdapter da=new SqlDataAdapter(strsql,conn);
DataSet ds=new DataSet();
da.Fill(ds,"grmp");
DataGrid1.DataSource=ds;
DataGrid1.DataBind();if (ds.Tables["grmp"].Rows.Count == 0)
DataGrid.Visible = false;
}