DropDownList Displaying Data from SQL DB

[ratpack]

Hi,

I'm trying to display my coded values from my SQL database in a DropDownList.

Basic functionality is I have a createUser page which has a couple drop down choices. I want the user to be able to edit in the editUser page. When the user selects edit, I have all the information pulling up including the value of the drop down, just not sure how code it to display. I'm working with Visual Studio in C#. Any help would be appreciated.

Thanks,
RatPack

[nateraaaa]

I assume you are using a stored procedure or an sql query to return the data saved for the user. If so you just need to add the record set returned from the database to a dataset. Then create a datatable to hold the table information from your dataset. You will then loop through the rows in your datatable (there should only be one) and set the SelectedValue property of your dropdownlist equal to the value stored in the datatable column. Here is a quick example

Use ADO.NET to add the results of your query to a dataset
.....
sqldataadapter.Fill(ds);

I don't know how you are identifying the user but I usually use a querystring to do that.

if(Request.QueryString["userId"] != null)
{
DataTable dataTable = ds.Tables[0];
for(int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow row = dataTable.Rows[i];
if(row["column1"] != System.DBNull.Value)
{
DropDownList1.SelectedValue = row["column1"].ToString();
}
else
{
DropDownList1.SelectedIndex = -1;
}
}
}

Nathan

[kunal pawar]

Do u mean at time of create user Dropdown should be empty or disabled.

[debasisdas]

You need to fill the dropdown dynamically as per user selection.

[nateraaaa]

Do u mean at time of create user Dropdown should be empty or disabled.

The original question asks how to prepopulate values on an Edit page. The dropdownlist should be already populated (page_load event) and then the example code that I posted should follow the code that populates the dropdownlist (also page_load event).

Nathan