Loading

save a date value in sql from textbox in asp.

manish berwal

13y7.9k.NET

hi friends i am saving a text box value in sql database but here is some error in my code. my sql database colum datatype is datetime.
i want to use this textbox for date entry in DD/MM/YYYY format....please help me out. waiting for good response.

2 Replies

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

Rodrigo Bereta13y ago
Hi Manish,

Try this:

DateTime myDate;

if(!DateTime.TryParse(TextBox1.Text, out myDate))
myDate = DateTime.MinValue;

To format the textbox you can use jquery .mask.

Regards.

0
Vishal Gilbile13y ago
Hello Friend,
you could simply store the value in DB in DD/MM/YYYY format by using the following snippet.

string str=textBox1.Text.ToString("dd/MM/yyyy");

now pass this str variable value to your database query.

cmd.Parameters.AddWithValue("@date",str);

Hope that solves your problem.

With Regards,
Vishal Gilbile.
0