How to hide the gridview row once it is used

Question

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

Sachin Singh · 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 Thangamma · Answer

Thank you so much Sachin Singh Sir and Rajanikant Hawaldar Sir...it was helpful and it worked!!

Rajanikant Hawaldar · Answer

can you check this https://www.c-sharpcorner.com/forums/how-to-hide-gridview-rows-with-conditions-in-asp-net-c-sharp

Preetham Thangamma · Answer

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 Hawaldar · Answer

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 ; }