DTpicker componanat in Vb

[Jaseem Ahmed]

how can i can save date in database from dtpicker..
and what is the way to assign date field of database to dtpicker.

[AndreRet]

Try the following -

Text1.Text = dtPicker1.Value

rsAddNew.AddNew
rsAddNew!Date = Text1.Text
rsAddNew.Update

[AndreRet]

To show the date value -

Text1.Text = rsAddNew!Date

[Jaseem Ahmed]

i used dt picker, y i should use text box, i have used dtpickr for date.

[Jx_Man]

also to asign database field to dtpicker DTPicker1 = rs.Fields("birthday")

[AndreRet]

I know you have used the dtPicker to select a date. You must still do something with the returned value though. I have found that by calling the value when using a database tends to screw up from time to time, hence the text box value. You can also add the value to a variable -

Dim xDate As Date 'At the top of your code form

'Under your dtPicker_Click event
xDate = dtPicker.Value.
'Now use the code above to add the date to your table.

Have a look at your "ADODC" post, I gave a full on tutorial there.

[Jaseem Ahmed]

thanks....can u plz tell me, when i press Add New Button, all fields will b clear, but i want to Dtpicker show the system date...how it will b?

[AndreRet]

Its a pleasure.:)

By using the code I gave you above.

Daclare a variable for the date at the TOP of your form -

Option Explicit

Dim xDate As Date

Private sub Command1_Click()
'All text boxes has been cleared...
xDate = dtPicker1.Value
'This will hold the variable until you clear it.

'After adding new record, use...
xDate = vbnullstring

[Jaseem Ahmed]

i said that when a button is pressed, the dtpicker should show system date, which date is stored in my computer, dtpicker should show that one, then it should b user's choice,which one he is selecting..

[AndreRet]

dtPicker1.Value = Now

[Jaseem Ahmed]

thnks andre.....

[AndreRet]

It was a pleasure. Happy coding Jaseem.:)