How display data from DB by selecting from DropdownList

[Praveen 123]

Sir, I am developing an application in ASP.NET.It's using a MS-Access database and I am listing ten Emp_IDs from the table Employee to DropdownList.I want to select particular Emp_Name from Employee table on click on DropdownList. Pleas help me to solve this problem.

Praveen.K System Engineer Graviton Technologies Pvt.Ltd

[varshavmane]

What do u want to do??On select index change of combo u want to display the selected employee details or something else??

[Sandeep Akhare]

Make the auto post back of drop downlist true and use dropdownlist selectedItem prepertyn in the dropdownlist_selectedIndexchanged function ?

[Naveed Kamboh]

Your probelm is not clear when and why you want to select employee , please explain your question. If you are filling dropdownlist use its property autopsotback=true which is false by default. Now use SelectedIndexChange event of your dropdownlist. if you have fetch data from database on the basis of rowselected in the dropdowlist. You have to keep in mind that weahter you are using DataTexFiled property and DataValuefield property of the Dropdownlist if you are using these two then you can query your database like this sql="select * from tbl where field="+ dropdownlist.selectedValue or sql="select * from tbl where field="+ dropdownlist.selectedItem if you are not using these two properties then you can use sql="select * from tbl where field="+ dropdownlist.Text Hope it will help you .

Naveed Kamboh

[Praveen 123]

By using SQLString = "SELECT Name FROM test WHERE ID = +DropDownList1.SelectedValue" I got the selected item from dropdown list.Now how can i place the out put of the query in a DataGrid? i want the syntax or coding? :confused: -- modified at 23:32 Thursday 1st February, 2007

Praveen.K System Engineer Graviton Technologies Pvt.Ltd