Have kept format of ajaxcalendar control as "dd/mm/yyyy" and want to save in database as mm/dd/yyyy

Question

I m using ajax calendar control to a textbox, have set its format as "dd/mm/yyyy" .

  Bapur.Date = txtdate.Text;

in data access layer

 cmd.Parameters.Add("@Date", SqlDbType.DateTime).Value = bapur.Date;

on saving, like above ( where Date is a string Bapur is object of businesslayer class) in the database where datatable in database has date as datetime format. m getting an error : cant convert string to datetime i dint get error when format was "mm/dd/yyyy" .

Basically, I want users to view date in dd/mm/yyyy but on saving i want it in

mm/dd/yyyy

Have tried a lot but not working.

here is my answer ---- https://stackoverflow.com/a/11720162/1445836 -----

is Bapur.Date string or DateTime? – Amol Kolekar Jul 30 '12 at 10:51 — Amol Kolekar, Jul 30 '12 at 10:51
obect of business layer class, dont bother with that – Zoya Jul 30 '12 at 10:51 — Zoya, Jul 30 '12 at 10:51
I think bapur is the object and Date is its property right? – Amol Kolekar Jul 30 '12 at 10:54 — Amol Kolekar, Jul 30 '12 at 10:54
http://stackoverflow.com/a/11720162/1445836 check my answer – Zoya Jul 30 '12 at 11:03 — Zoya, Jul 30 '12 at 11:03

score 2 · Answer 1 · answered Jul 30 '12 at 10:55

2

You can use:

DateTime.ParseExact("yourDate","formatinWhichYouWant",culture of current string);

ex:

DateTime dt =DateTime.ParseExact("yourDate","formatinWhichYouWant",culture of current string);

answered Jul 30 '12 at 10:55

yes this is the best way to convert date I have also tried to find some other more precise manner but not able to find any one – Jul 30 '12 at 11:08

score 0 · Answer 2 · answered Jul 30 '12 at 10:52

0

string myDate = bapur.Text.Split("/");
string dateString = myDate[1] + "/" + myDate[0] + "/" + myDate[2];

answered Jul 30 '12 at 10:52

Lajos Arpad

64,414
37
100
175

score 0 · Accepted Answer · answered Jul 30 '12 at 11:02

0

got my answer

            string old = txtdate.Text;
            string newDate = DateTime.ParseExact(old, "dd/MM/yyyy", null).ToString("MM/dd/yyyy");

            Bapur.Date = newDate.ToString();

answered Jul 30 '12 at 11:02

Zoya

405
3
10
21

upvoted for constant search and effort in finding answer after asking the question – Jul 30 '12 at 11:35

Have kept format of ajaxcalendar control as "dd/mm/yyyy" and want to save in database as mm/dd/yyyy

3 Answers3