dropdown select item show the another grid

ashok kumar

11y1.2k.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.

ashok kumar11y ago
dropdownselected value highlight row in my gridview and my grid page 10 i selected value is 12 th value its selected but not show

thanks,
Khargesh Rajput11y ago
set autopostback =true

Autopostback="True" OnSelectedIndexChanging="DropDownList1_SelectedIndexChanging">
Select
School
Collage
Office

and on selectedindexchenged

check if(DropDownList1.selectedItem.Text=="School")
{
//bind grd from School table
}
else
{
// bind from Office
}
Manoj Kumar Mandal11y ago
you can use a varibale to store index value and using that value you can fetch the data from your procedure

Sample Code
protected void DropDownList1_SelectedIndexChanging(object sender, EventArgs e)
{
int TypeId= Convert.ToInt32(DropDownList1.SelectedValue);
//Call your procedure with TypeId as argument

}

Inside Procedure use condition

IF (TypeId = 1 )
BEGIN
//Query to fetch data of School
END
ELSE IF (TypeId = 2)
BEGIN
//Query to fetch data of College
END
ELSE
BEGIN
//Query to fetch data of Office
END