我加载数据是这么写的 string id = Session["id"].ToString(); string sql = "select num,sub,starttime,result from result where num = '"+ id +"'"; DataSet ds = getDataSet(sql); DataTable dt = ds.Tables[0]; GridView1.DataSource = dt; GridView1.DataBind();想知道怎么写判断!~谢谢
if(dt.Tables["表名"]或者用索引.Rows.count==0)
{
//说明没数据
}
Response.Write("<script language='javascript'>alert('no')</script>")
GridView.Visible = False
string id = Session["id"].ToString();
string sql = "select num,sub,starttime,result from result where num = '"+ id +"'";
DataSet ds = getDataSet(sql);
DataTable dt = ds.Tables[0];
GridView1.DataSource = dt;
GridView1.DataBind();想知道怎么写判断!~谢谢
if(ds.Tables[0].Rows.Count>0)
{
DataTable dt = ds.Tables[0];
GridView1.DataSource = dt;
GridView1.DataBind(); }
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "script", "alert('没有符合条件的数据!');", true);}
按照你的写法
应该是
if(dt.Tables[0].Rows.Count>0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "script", "alert('没有符合条件的数据!');", true); }