ASP C# Gridview filtering from DropDownLis

Question

I want to fill my gridview1 with DropDownList1. DropDownList1 is one column in one table, about 2000 hyperlink addresses in text or varchar whatever. The GridView1 needs to show the actual hyperlink address in a real hyperlink format. which will take 2 tables joined. I am using a template within my gridview. I have everything working except the DropDownList1 will not update the gridview based on selection. I need to figure out how to do this part on the cs file. Please help????????????

Vincent Maverick Durano · Answer

Here's a quick example using the ADO.NET way: 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); } Note: Make sure to set AutoPostback to TRUE in your dropdownlist to trigger the selectedindexchanged event.

Ravi Kumar · Answer

hi on selection of item in drop down. you want to display the grid view details. this way means you can do in drop down selected index changed event.

ASP C# Gridview filtering from DropDownLis

Sandeep Shekhawat

Suthish Nair