Show Hide ASP.Net GridView based on condition using C#

Hi akhter,

You need to check condition with DataTable Row Count. 

Use below code.

private void Loadinvoicgv()
{
    con.Open();
    // SqlCommand cmd = new SqlCommand("[SP_Retreive_Customer_Legder]");

    SqlCommand cmd = new SqlCommand("[Sp_Ret_Import_Detail_ID]");
    cmd.Connection = con;

    cmd.CommandType = CommandType.StoredProcedure;
    SqlDataAdapter daf = new SqlDataAdapter(cmd);
    cmd.Parameters.AddWithValue("@ID", lbimpid.Text);
    DataTable dtf = new DataTable();
    daf.Fill(dtf);
    con.Close();
    if (dtf.Rows.Count > 0)
    {
        gvtrans0.Visible = true;
        gvtrans0.DataSource = dtf;
        gvtrans0.DataBind();
        gvtrans.Visible = false;
    }
    else
    {
        gvtrans0.Visible = false;
        gvtrans.Visible = true;
    }
}