Gridview and dropdown list and buttons Hiding

Question

Hi All, I need to hide Gridview 1 and some controls on the webpage like dropdown, textbox,radiobuttons..etc. when i click on dropdown item. And i need to display another new Gridview which contains records from different table.Without any javascript or jquery can we do it? If yes please post answers Please share your answers Regards, Vamsi

Jignesh Kumar · Answer

Hi Vamsi, Please find below link, https://www.aspsnippets.com/Articles/Populate-Display-data-in-GridView-based-on-DropDownList-Selected-value-Selection-in-ASPNet.aspx

Vincent Maverick Durano · Answer

You would need to handle DropDownList SelectedIndexChanged event and write the logic there for hiding and populating your GridViews with data. A quick example would be: private string GetConnectionString(){ //DBConnection is the name of the connection string that was set up from the web config file return System.Configuration.ConfigurationManager.ConnectionStrings[ "DBConnection" ].ConnectionString; } private void BindGridView( string field){ DataTable dt = new DataTable(); SqlConnection connection = new SqlConnection(GetConnectionString()); try { connection.Open(); string sqlStatement = "SELECT * FROM TableName WHERE ColumnName = @Value1" ; SqlCommand sqlCmd = new SqlCommand(sqlStatement, connection); sqlCmd.Parameters.AddWithValue( "@Value1" , field); SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); sqlDa.Fill(dt); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } else { // NO RECORDS FOUND } } catch (System.Data.SqlClient.SqlException ex) { string msg = "Fetch Error:" ; msg += ex.Message; throw new Exception(msg); } finally { connection.Close(); } } protected void DropDownLis1_SelectedIndexChanged( object sender, EventArgs e) { BindGridView(DropDownList1.SelectecItem.Value); } If you are new to GridView, then feel free to grab a copy of my eBook here: https://www.c-sharpcorner.com/ebooks/asp-dot-net-gridview-control-pocket-guide

Vamsi k · Answer

requirement is currently web page has one dropdown which contains years like 2018,2019 so when i click on 2018 in dropdown , then it displays 2018 records in the gridview, as well as for 2019 also. But here new requirement came that is old Gridview should be there but we need to take one more dropdown which contains 2018 and 2019 years and we need to show some other table data into another gridview( in the new grid should). So whenever we are selecting 2018 in the new dropdown , then immediately existing Gridview should be hidden. And if i choose old dropdown item then its Gridview should be display, new grid should be hidden. dropdown1 its gridview1 should display.Gridview2 should be hidden if i select dropdown2 new gridview2 should be display old gridview1 should be hidden

Suraj Kumar · Answer

Request you to provide what you have tried so far?