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

[Johan Hakkesteegt]

Hi Praveen, You are actually asking the wrong people, this being the Visual Basic / VB.NET Q&A. But as the languages are similar, I suggest trying something like: Dim Emp_ID as string Dim MySqlSentence as string Emp_ID = DropdownList.SelectedItem MySqlSentence = "SELECT Emp_Name FROM Employee_table WHERE Emp_ID = " & Emp_ID Good luck, Johan

My advice is free, and you may get what you paid for.

[Ahmed El Badry]

OleDbDataAdapter1.SelectCommand.CommandText = "select AID,name from Admin ORDER BY [AID]" OleDbDataAdapter1.Fill(DataSet21, "Admin") ComboBox1.DataSource = DataSet21.Tables("Admin") ComboBox1.DisplayMember = "name" ComboBox1.ValueMember = "AID" :rose:

Ahmed El-Badry