want to display the data from database as per the selected value of dropdown.

i want to pass by using selectedtext from the dropdown

protected void ddlDisplayName_SelectedIndexChanged(object sender, EventArgs e)
{
AdminActivityBL ObjAdminActivity = new AdminActivityBL();
ObjAdminActivity.GetDisplayNames_Details(DisplayName);
string SelectedValue = ddlDisplayName.SelectedItem.Value;

}
is this correct?

i really didnot get...that..could you please explain with sample...code

i want to display the data in textboxes according to the selected value in dropdown list. need to select based on selected text. how to pass the selected text value to a stored proc?
pls help me


protected void ddlDisplayName_SelectedIndexChanged(object sender, EventArgs e)
{
AdminActivityBL ObjAdminActivity = new AdminActivityBL();
ObjAdminActivity.GetDisplayNames_Details();
string SelectedValue = ddlDisplayName.SelectedText.Value;

}
Bussines layer:


public DataSet GetDisplayNamesDetails()
{
AdminActivityDB objAdminActivityDB = new AdminActivityDB();
return objAdminActivityDB.GetDisplayNamesDetails();
}

Data access layer:

public DataSet GetDisplayNamesDetails(string SelectedValue)
{
try
{
Database objDB = new SqlDatabase(ConfigurationHelper.ConnectionString);
using (DbCommand objCMD = objDB.GetStoredProcCommand(Constants.USP_GET_DISPLAYNAMES_DETAILS))
{
DataSet retDS = objDB.ExecuteDataSet(objCMD);
return retDS;
}
}
catch (Exception ex)
{
//EventLog objLog = new EventLog();
//objLog.LogError(ex);

throw ex;
}

}