How to hide the gridview row once it is used

Preetham Thangamma

Good Morning,

As i have created a gridview and when the gridview button for the particular row is clicked, a sqlcoulmn named Flag will be set to 1.....so when i load the page again,i want to hide all the gridview rows where flag is set to 1...please do help me solve this!!

Thank you

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
you can use RowDataBound event of gridview as@Rajnikant sir has stated or you can filter rows while binding the Gridview that will automatically bind only rows having flag equal to 1.
private Page_Load()
{
LoadGrid();
}

private void LoadGrid()
{
using(SqlConnection con=new SqlConnection(cs)){
SqlCommand cmd=new SqlCommand("Select * from table where flag=1",con);
con.Open();
  Gridview1.DataSource=cmd.ExecuteReader();
  GridView1.DataBind();
  }
Preetham Thangamma5y ago
Thank you so much Sachin Singh Sir and Rajanikant Hawaldar Sir...it was helpful and it worked!!
Rajanikant Hawaldar5y ago
can you check this
https://www.c-sharpcorner.com/forums/how-to-hide-gridview-rows-with-conditions-in-asp-net-c-sharp
Preetham Thangamma5y ago
Hello Rajnikant Hawaldar,

Thank you for the answer but ur solution is valid only after clicking the button of the gridview...i want to make invisible during page load!!

Thank you
Rajanikant Hawaldar5y ago
Hello Preetham, you can try it inside RowDatBound or DataBound events.
private void GridView_RowDataBound(Object sender, GridViewRowEventArgs e)
{
     if (e.Row.Cells[2].Text == "1")
e.Row.Visible = false;
}