[Solved] ASP.Net GridView not displaying even if query has results

Dear @jqdesigner,       

Asper your code,

Initially you got the records and you are not set gridview visible true or false. so, the gridview visible. 2nd time you dont got the records and you are set gridview visible false. so, the gridview not visibile. 3rd time you got the records but gridview not visible why because previous gridview visible status is false and now you are not set gridview visible status as true. This is the problem in your code. so, you can set gridview visible true while records found.  'gridview.visible=true' in your if condition.

public void PopulateGrid()
{

string Query = "SELECT RequestStatus, Count(Sno) as NumberofRequest FROM Test where RequestActive = 'Y' " + strDateFromTo + " group by RequestStatus";

Label1.Text = Query;

SqlConnection sqlcon = new SqlConnection(getconn());

SqlDataAdapter oAdapter = new SqlDataAdapter(Query, sqlcon);

DataSet ds = new DataSet();
oAdapter.Fill(ds);

dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
gridView1.DataSource = dt;

gridView1Approver.DataBind();
gridview1Approver.Visible=true;

gridView1Approver.FooterRow.Cells[0].Text = "Total";
gridView1Approver.FooterRow.Cells[1].Font.Bold = true;


int totalAmount = 0;
for (int k = 1; k < dt.Columns.Count; k++)
{
totalAmount = dt.AsEnumerable().Sum(row => row.Field(dt.Columns[k].ToString()));
gridView1Approver.FooterRow.Cells[k].Text = totalAmount.ToString();
gridView1Approver.FooterRow.Cells[k].Font.Bold = true;
gridView1Approver.FooterRow.BackColor = System.Drawing.Color.Beige;
}


}
else
{
Vlable.Text = "No record found.";

gridView1Approver.Visible = false;
}

}

Just checked your code. You can visible or hide grid based on dt rows count value like below.

dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
    gridView1.DataSource = dt;    
    gridView1Approver.DataBind();  

    gridView1Approver.FooterRow.Cells[0].Text = "Total";
    gridView1Approver.FooterRow.Cells[1].Font.Bold = true;
    int totalAmount = 0;
    for (int k = 1; k < dt.Columns.Count; k++)
    {
        totalAmount = dt.AsEnumerable().Sum(row => row.Field<int>(dt.Columns[k].ToString()));
        gridView1Approver.FooterRow.Cells[k].Text = totalAmount.ToString();
        gridView1Approver.FooterRow.Cells[k].Font.Bold = true;
        gridView1Approver.FooterRow.BackColor = System.Drawing.Color.Beige;
    }
} 

Vlable.Text =  dt.Rows.Count > 0 ? "No record found.":"";     
gridView1Approver.Visible = dt.Rows.Count > 0;