Use a DateTime Picker to update records in a Sql database
Hi there. I don't yet have any code for this and am hoping that there is an off-the-shelve piece of code I can use to update records to a Sql database, using a DateTime Picker.
If anyone recently used this control, please share.
if this is the incorrect forum for this kind of help, just let me know, as I can then remove the question.
The question is- I'm looking for a sample of how to commit records to a SQL database using values selected via a DateTime Picker control in VB.net.
I basically just need to see how it works, then I'll continue on my own
If anyone recently used this control, please share.
if this is the incorrect forum for this kind of help, just let me know, as I can then remove the question.
The question is- I'm looking for a sample of how to commit records to a SQL database using values selected via a DateTime Picker control in VB.net.
I basically just need to see how it works, then I'll continue on my own
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
What you're asking doesn't make a lot of sense. A DateTime Picker is just a control - it shows a value and allows the user to choose a value.
If you want to update records in a database, you can do it several ways. You can use the SQLCommand method, for instance:
Imports System.Data.SQLClient
Using con As New SQLConnection("Your connection string")
con.Open
Using cmd As New SQLCommand
cmd.Connection = con
cmd.CommandText = "INSERT INTO SomeTable(SomeField) VALUES('" & YourDateTimePicker.Value & "')"
cmd.ExecuteNonQuery
End Using
End Using
If you're using bound controls then you have builtin methods for doing this. There are quite a lot of tutorials on this on the MSDN website. Here's one:
https://support.microsoft.com/en-us/kb/308055
If you want to update records in a database, you can do it several ways. You can use the SQLCommand method, for instance:
Imports System.Data.SQLClient
Using con As New SQLConnection("Your connection string")
con.Open
Using cmd As New SQLCommand
cmd.Connection = con
cmd.CommandText = "INSERT INTO SomeTable(SomeField) VALUES('" & YourDateTimePicker.Value & "')"
cmd.ExecuteNonQuery
End Using
End Using
If you're using bound controls then you have builtin methods for doing this. There are quite a lot of tutorials on this on the MSDN website. Here's one:
https://support.microsoft.com/en-us/kb/308055
Premium Content
You need an Expert Office subscription to comment.Start Free Trial