How to popluat value form database into combo box using Asp.net

Question

I want to fetch list of students into combo box and on the base of combo box slection I will fetch their related record into another grid. please guide me regarding this task.

what do you have already? code? structure of database tables? some ORM? — DarkSquirrel42
– DarkSquirrel42, Commented May 7, 2011 at 13:30

santosh singh · Accepted Answer · 2011-05-07 13:41:19Z

1

You can bind DropDownList as below

DropDownList1.DataSource=GetStudentDataSet();
DropDownList1.DataTextField="StudentName";
DropDownList1.DataValueField="StudentID";
DropDownList1.DataBind();

Put GridView bind code on selected change event of DropDownList as below

void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        //Fecth selected student id 
         int studentId = Convert.ToInt32(DropDownList1.SelectedValue);
        //Bind Grdivew
    }

edited May 7, 2011 at 13:41

answered May 7, 2011 at 13:30

santosh singh

28.8k27 gold badges88 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Touseef Khan Over a year ago

I have database only and I want to fetch only name from student table in dropdown list,, then after fetching name, on change drop down I wana to fetch particular record related to that selected student

Touseef Khan Over a year ago

int studentname = Convert.ToInt32(ddstd.SelectedValue); it gives FormatException, Input string was not in a correct format.

santosh singh Over a year ago

@Touseef:If you want to fetch Student name then there is no need to convert to int.Simply collect the selected value in string variable like string studentname=DropDownList1.SelectedValue;

Collectives™ on Stack Overflow

How to popluat value form database into combo box using Asp.net

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related