grid view

ashok kumar

11y161.NET

My Aspx Code:

Select
School
Collage
Office

I have one dropdownlist which contain value of school and office i have also table in school and office i have also grid. when i select school in dropdownlist the grid display must the school table and vivice-versa.

Thank You,

3 Replies

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

g s11y ago
Useful Below Link

http://dotnetdrizzles.blogspot.in/2015/03/sorting-gridview-selected-dropdownlist.html

http://screenshotdrizzles.blogspot.in/2015/03/sorting-gridview-selected-dropdownlist.html
Vincent Maverick Durano11y ago
Here's a quick example:

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();
using(SqlConnection connection = new SqlConnection(GetConnectionString())){
connection.Open();
string sql = "SELECT * FROM TableName WHERE ColumnName = @Value1";
using(SqlCommand cmd = new SqlCommand(sql,connection)){
cmd.Parameters.AddWithValue("@Value1", field);
using(SqlDataAdapter ad = new SqlDataAdapter(cmd)){
ad.Fill(dt);
if (dt.Rows.Count > 0) {
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}
}

protected void Button1_Click(object sender, EventArgs e)
{
BindGridView(DropDownList1.SelectecItem.Text);
}
Dipankar Biswas11y ago
hi

see this link to help..

http://www.c-sharpcorner.com/Blogs/46917/