Problem of convert date (Formate :- dd/MM/yyyy)

Viral Patel

11y1.2kVisual Basic .NET

Fetch Date into Databse and Display All The Details Of Yhis Date.

But Problem Date Format : dd/MM/yyyy

Eample:

SqlDataAdapter da = new SqlDataAdapter("select * from customer3 where Date= '"+txtdate.Text+"'", con);

Datatable dt=new Datatable;

da.Fill(dt);

Description:

txtdate.text input date are not match in database How this problem are solved

plz.

16 Replies

Know the answer? Post it — somebody with the same question will find it here.

Viral Patel11y ago
Ok
Rajeesh Menoth11y ago
Hi Viral Patel,

Welcome :)
Your problem is solved ? Then accept the answer it will help for others...
Viral Patel11y ago
Thanks sir
Viral Patel11y ago
Thanks sir
Rajeesh Menoth11y ago
Hi,
Your database value contain date with time so before searching the report you can use the same format for date and trim the time like below example..
Textbox.text = dd/mm/yyyy;
Datbasevalue = dd/mm/yyyy;//use sql convert method to trim the date
if (dd/mm/yyyy == dd/mm/yyyy)
{
//code
}
Upendra Pratap Shahi11y ago
1. using System.Globalization;//namespace
4. DateTime From = DateTime.ParseExact(txtFrom.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture)
Viral Patel11y ago
Occur Error Will Be: Conversion failed when converting date and/or time from character string.
Rajeesh Menoth11y ago
Hi,

Both format are different that's why you got the error..

using System.Globalization;//namespace

DateTime From = DateTime.ParseExact(txtFrom.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture);
Viral Patel11y ago
22-08-2015 input to the textbox
Rajeesh Menoth11y ago
Hi,

Can you show your date format in textbox....
Sumit Joshi11y ago
Hi viral,

For this problem i suggest you to use JQuery Calender control your problem will be solved.

If helpful mark as Correct Answer
Viral Patel11y ago
date insert to database in dd/MM/yyyy with time Display Daily report using this date but not match this date in input textbox date fier error
Sumit Joshi11y ago
Hi Viral,

Below is a link that solves your problem

https://msdn.microsoft.com/en-us/library/8kb3ddd4(v=vs.110).aspx

If helpful mark as Correct Answer
Rajeesh Menoth11y ago
Hi,

Check the above link..if not that error please explain your question..
Viral Patel11y ago
Which Not Work Error:String was not recognized as a valid DateTime.
Rajeesh Menoth11y ago
Hi,

Check this : http://www.c-sharpcorner.com/code/1459/string-was-not-recognized-as-a-valid-datetime.aspx