how can i get multiple columns value from dropdown list ?

Surendra singh

i have a tabe (Employee) which have 4 coloumns (empID,Name,Age,salary).
now i have filled data in dropdownlist. datatext field is Name and datavaluefield is EmpID.
Now i have disposed dataset object ds.
now hw cn i get salary of selected employee from dropdownlist without interecting with database. i dont wnt to fire any query again to database. i wnt to take infromation abt salary from table that is bind with dropdown list

        ddlEmployee.DataSource = ds.table[0];
        ddlEmployee.DataTextField = "Name";
        ddlEmployee.DataValueField = "EmpID";
        ddlEmployee.DataBind();
        ddlEmployee.Items.Insert(0, "select");

pls help me

Thank you

3 Replies

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

Surendra singh15y ago
Thanks vulpes
Vulpes15y ago
You could also save the DataTable to which you're binding to Session state:

Session["DataTable"] = ds.Tables[0];

and then do something like this to get the salary (assuming it's a double) of the selected employee:

if (ddlEmployee.SelectedIndex > 0)
{
DataTable dt = (DataTable)Session["DataTable"];
double salary = (double)dt.Rows[ddlEmployee.SelectedIndex - 1]["Salary"];
lblSalary.Text = salary.ToString();
}
Mayur Dighe15y ago
if you dont want to fire any query against DataBase then you can get salaries of particular selected employee if you store the salary information in array and write appropriate code for selecting EmpID from array which is same as Database EmpID field.