Hi,
Firstly I should clarify that I am very new to VB.net (I have never done any coding at all before), so thank you in advance for any assitance.
I have designed a form and bound a combobox (using the DayTimePicker control) it's bound to a Date field in an SQL Table.

Once the date is chosen, and the other data on screen changed and written to the database, I would like to arrange the code so when that same date is chosen, that the rest of the data on the screen auto populates to the entries from the database.
I didn't realise how difficult this would be to explain actually, so please forgive me if it isn't making sense.
Ultimately, I think the question is, Can I get my combo box to query my database, see if that date already exists, and populate the textboxes, etc that relate to that record? and allow me to either edit, or just view the data?

Thanks in advance again.

D

You cant autopopulate the data.You have to write coding in the code-behind file.In the Combobox control SelectedIndexChanged event ,check in the database for the selected date.If data exists,query the database and set the values to the textboxes you have declared.If data not exists,leave the textboxes blank.

I see, i didnt expect it to be so arduous, makes sense though.
Thanks for your help :)
D

Actually, with your advice in mind I went back to my code, and stared at the screen blankly, googled for hours, and decided that I might find the answer in a bottle of beer. Alas, I am back, none the wiser. The question has now become:
My ComboBox (lets call it DatePicker) is selected, I have used the ValueChanged Event.
If my text box is called "txtWeatherThatDay", my database is called "WeatherMan", the table is called "TableOfWeather", what comman would generically be used to find the "DatePicker" value in my database and then let me say that the database value of "txtWeatherThatDay" = the textbox value of "txtWeatherThatDay"?

I hope that is clear.
Thanks again.

What are the fields present in TableofWeather?I dont know what is the structure of your database.If you are taking weather info from the database,surely date field might be present in that table.Use that to match the DatePicker value.

That is exactly what I am asking .
The Fields in there do comtain the date I am hoping to select from the combo box.
The question ultimately is what is the command line that would be used to tell the combo box to actually look at the database and find if that date selected matches one in the database?