Click here to Skip to main content
15,921,174 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: enumerate Microsoft sql server instance in local network Pin
Henry Minute3-Jul-09 8:53
Henry Minute3-Jul-09 8:53 
QuestionProblem Reading, Saving from Excel file Pin
Trupti Mehta3-Jul-09 5:48
Trupti Mehta3-Jul-09 5:48 
QuestionDateTimePicker problem with Month and Day Pin
Nielvh3-Jul-09 3:12
Nielvh3-Jul-09 3:12 
AnswerRe: DateTimePicker problem with Month and Day Pin
Nagy Vilmos3-Jul-09 3:46
professionalNagy Vilmos3-Jul-09 3:46 
GeneralRe: DateTimePicker problem with Month and Day Pin
Nielvh3-Jul-09 3:59
Nielvh3-Jul-09 3:59 
GeneralRe: DateTimePicker problem with Month and Day Pin
Enver Maroshi3-Jul-09 4:06
Enver Maroshi3-Jul-09 4:06 
GeneralRe: DateTimePicker problem with Month and Day Pin
Nielvh3-Jul-09 4:15
Nielvh3-Jul-09 4:15 
GeneralRe: DateTimePicker problem with Month and Day Pin
Enver Maroshi3-Jul-09 4:23
Enver Maroshi3-Jul-09 4:23 
i guess you are doing something like:

Dim VisitDate as Date
VisitDate = DateTimePicker.Value

"INSERT INTO Table (VisitDate) VALUES ('" & VisitDate & "')"

which looks like this then:
"INSERT INTO Table (VisitDate) VALUES ('7/3/2009')"

SQL parameters will fix this, and as a beginner, you should start using them, it's best way to work with sql server.

Btw, only way you can make sure sql server (set up on any pc, no matter if it's set up as usa, english, spanish, german, etc... format) is to format date to "yyyyMMdd". SQL server will always know that first 4 is year, second 2 is month, and third 2 is day. And in your code you would have to do something like this:

"INSERT INTO Table (VisitDate) VALUES ('" & VisitDate.ToString("yyyyMMdd") & "')"
GeneralRe: DateTimePicker problem with Month and Day Pin
Nielvh3-Jul-09 4:33
Nielvh3-Jul-09 4:33 
GeneralRe: DateTimePicker problem with Month and Day Pin
Nielvh5-Jul-09 23:34
Nielvh5-Jul-09 23:34 
QuestionWeb Query- Com Addin Excel 2003 Pin
YakomozB3-Jul-09 2:57
YakomozB3-Jul-09 2:57 
QuestionHow to show DataTable in ReportViewer contral as Local Report (.rdlc) Pin
angel0in2-Jul-09 22:30
angel0in2-Jul-09 22:30 
AnswerRe: How to show DataTable in ReportViewer contral as Local Report (.rdlc) Pin
anas.safar14-Nov-10 22:11
anas.safar14-Nov-10 22:11 
QuestionHow to unlock a PC programmatically [modified] Pin
Uwe1234562-Jul-09 21:46
Uwe1234562-Jul-09 21:46 
AnswerRe: How to unlock a PC programmatically Pin
Enver Maroshi3-Jul-09 2:44
Enver Maroshi3-Jul-09 2:44 
GeneralRe: How to unlock a PC programmatically Pin
Uwe1234563-Jul-09 3:01
Uwe1234563-Jul-09 3:01 
GeneralRe: How to unlock a PC programmatically Pin
Enver Maroshi3-Jul-09 3:28
Enver Maroshi3-Jul-09 3:28 
GeneralRe: How to unlock a PC programmatically Pin
Uwe1234563-Jul-09 3:33
Uwe1234563-Jul-09 3:33 
GeneralRe: How to unlock a PC programmatically Pin
Enver Maroshi3-Jul-09 3:40
Enver Maroshi3-Jul-09 3:40 
GeneralRe: How to unlock a PC programmatically Pin
Enver Maroshi3-Jul-09 3:35
Enver Maroshi3-Jul-09 3:35 
AnswerRe: How to unlock a PC programmatically Pin
Dave Kreskowiak3-Jul-09 6:47
mveDave Kreskowiak3-Jul-09 6:47 
AnswerRe: How to unlock a PC programmatically Pin
Fahad Sadah3-Jul-09 8:10
Fahad Sadah3-Jul-09 8:10 
GeneralRe: How to unlock a PC programmatically Pin
Uwe1234563-Jul-09 8:41
Uwe1234563-Jul-09 8:41 
GeneralRe: How to unlock a PC programmatically Pin
swap.kamble30-Sep-09 20:42
swap.kamble30-Sep-09 20:42 
Questionrotate images in picturebox on button click Pin
KIDYA2-Jul-09 20:54
KIDYA2-Jul-09 20:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.