ASP C# Gridview filtering from DropDownLis

Jennifer Kilman

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????????????

2 Replies

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

Vincent Maverick Durano11y ago
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 Kumar11y ago
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.