how to set default value in dropdown list

[arial]

Hi all,

I have couple drop down list in my web forms.
All of them are bounded by database table.

so, what happens is even if user doesn't select anything from a drop down list it autometically insert the first value into database.

so, i like to insert at first position of drop downlist like, select one ?

Is there a way to do this in asp.net drop down which is bind by database table?

Thank You,

[Plater]

The dropdownlist is going to be bound to whatever data that you bound to it.
You could either make the first entry in the bound data be "empty" of some sort.
Or unbind the dropdown and assign a value to the SelectedValue proeprty.

Actually you might be able to do that to a bound dropdownlist as well.

[arial]

Can you explain in little bit more.

I understand the first value being empty. but I did not get you second comment bound to actual database?

Thank You,

[Plater]

You had said your dropdownlists are bound to a datatable.

Is it bound to a table that JUST contains values FOR the dropdown list, or is it bound to an overall table, and will therefor just display values from the column it is bound to, with the selected one being the value from the current row?

[arial]

Also, anotherthing I am trying to do is.

I have datapicker control on my web form for user to select the date.

Now, when user click on edit, I need to put the date into that datepicker field based on value from database date field.

How can I do this?

I tried:

Datercv.SelectedDate = Datercv.SelectedDate(dsgingupdate1.Tables[0].Rows["DATE_RCV"].ToString());

but, its not working.

Thank You,

[arial]

My dropdown list is bouned to the table that contains the value for the dropdownlist and my table does not have value like "select one".

Thank You,

[Plater]

Then after you call the databind function for the dropdown lists, set the selectedindex to the desired index? (It could be selectedItem and not SelectedIndex)

[arial]

Thank You.

This problem is resolved now.