Inserted date from textbox to datagridview showing wrong format ? I want to show date dd/mm/yyyy format.

Question

1.00/5 (1 vote)

See more:

what changes i do in update command for Date format ?

What I have tried:

i am using

Val(TextBox2.Text)
'textbox2 contains date

Posted 21-Nov-17 2:42am

shiwajee

Updated 22-Nov-17 0:13am

v4

Add a Solution

Comments

ZurdoDev 21-Nov-17 8:51am

The way you display a date has nothing to do with the way you save it in the db. As I recall, Access wants #'s around the date. Post the code that is causing an error and what the error is. Otherwise, there isn't enough here to help you.

Richard Deeming 21-Nov-17 12:26pm

Your question makes me suspect that your code is vulnerable to SQL Injection:

Everything you wanted to know about SQL injection (but were afraid to ask) | Troy Hunt[^]
How can I explain SQL injection without technical jargon? | Information Security Stack Exchange[^]
Query Parameterization Cheat Sheet | OWASP[^]

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2017-11-21T03:11:00

There is no such thing as a "format" for a DateTime value in a database. The format is applied when the date is displayed, and you have control over that.

If you're saving dates as text in your database, you're most assuredly doing it wrong. NEVER save DateTime values as text. Always use the proper date type for your data.

phil.o · Answer 2 · 2017-11-21T02:58:00

Solution 1

For everything that is related to parsing a string to a value (integers, reals, dates, etc...), you should always use the TryParse method of the target valuetype.
In your example, that would be:

VB.NET

Dim myDate As DateTime
If (DateTime.TryParse(TextBox2.Text, myDate))
   '' DateTime correct format
Else
   '' DateTime incorrect format
End If

The TryParseExact method gives you even more control on the input format.
DateTime.TryParse Method[^]
DateTime.TryParseExact Method[^]

Posted 21-Nov-17 2:58am

phil.o

Comments

shiwajee 21-Nov-17 12:16pm

Dim myDate As DateTime
If (DateTime.TryParse(TextBox2.Text, myDate)) Then
'' DateTime correct format
TextBox2.Text = FormatDateTime(TextBox2.Text, DateFormat.ShortDate)
End If
Solution not working yet

Richard Deeming 22-Nov-17 10:59am

Dim myDate As DateTime
If DateTime.TryParse(TextBox2.Text, myDate) Then
    TextBox2.Text = myDate.ToString("d")
End If

Standard Date and Time Format Strings[^]

phil.o 21-Nov-17 12:21pm

Your goal is unclear. Please clarify.