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

Question

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.

Viral Patel · Answer

Ok

Rajeesh Menoth · Answer

Hi Viral Patel , Welcome :) Your problem is solved ? Then accept the answer it will help for others...

Viral Patel · Answer

Thanks sir

Viral Patel · Answer

Thanks sir

Rajeesh Menoth · Answer

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 Shahi · Answer

using System.Globalization; //namespace DateTime From = DateTime.ParseExact(txtFrom.Text, "dd/MM/yyyy" , CultureInfo.InvariantCulture)

Viral Patel · Answer

Occur Error Will Be: Conversion failed when converting date and/or time from character string.

Rajeesh Menoth · Answer

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 Patel · Answer

22-08-2015 input to the textbox

Rajeesh Menoth · Answer

Hi, Can you show your date format in textbox....

Sumit Joshi · Answer

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 Patel · Answer

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 Joshi · Answer

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 Menoth · Answer

Hi, Check the above link..if not that error please explain your question..

Viral Patel · Answer

Which Not Work Error:String was not recognized as a valid DateTime.

Rajeesh Menoth · Answer

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