how to insert selected datepicker in database

Question

5.00/5 (1 vote)

See more:

Hi, i'm trying to use datepicker but when i insert date selected in datepicker i get error.
here is html code :

XML

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.5/themes/base/jquery-ui.css" type="text/css" media="all" />
            <link rel="stylesheet" href="http://static.jquery.com/ui/css/demo-docs-theme/ui.theme.css" type="text/css" media="all" />
            <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>
            <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.5/jquery-ui.min.js" type="text/javascript"></script>

   
    <script type="text/javascript">
        $(function () {
            $("#TextBox1").datepicker({
                changeMonth: true,
                changeYear: true
            });
        });
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <%--<input runat="server" type="text" id="txtFoo"  />--%>
    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    <asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" /></div>
    <asp:Label ID="Label1" runat="server" ></asp:Label>
    </form>
</body>
</html>

here is code:

C#

namespace datepicker
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        SqlConnection cn = new SqlConnection("Data Source=AB19726;Initial Catalog=datepicker;Integrated Security=True");
        SqlCommand cmd = new SqlCommand();
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            cn.Open();
            //DateTime dat= DateTime.Parse(TextBox1.Text.ToString());
            cmd = new SqlCommand("insert into date (ID,date)values(3," +Convert.ToDateTime(TextBox1.Text.ToString()) + ")", cn);
            cmd.ExecuteNonQuery();
            Label1.Text = "insert successed !!";
            cn.Close();

        }
    }
}

i get this error :

The string was not recognized as a valid DateTime.

Posted 14-Apr-14 16:50pm

youseph

Updated 14-Apr-14 19:01pm

Tom Marvolo Riddle

v3

Add a Solution

Comments

Rahul VB 15-Apr-14 0:54am

An important question, people do get this error....

Ajay_Babu 15-Apr-14 3:00am

i posted an answer which plays good in any type of situation.Just check that once..

youseph 15-Apr-14 8:17am

plz can give link to your post??

Ajay_Babu 15-Apr-14 8:41am

sol4 in your question

5 solutions

Solution 1

Try this.

C#

DateTime dat = DateTime.ParseExact(TextBox1.Text.ToString().Trim(), "M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture);

Make sure the format and what inside the textbox match.

Posted 14-Apr-14 18:28pm

Midnight Ahri

Solution 2

Hi,
Try this

DateTime dat = Convert.ToDateTime(TextBox1.Text);

Hope this helps
Cheers

Posted 14-Apr-14 18:31pm

jacobjohn196

Solution 4

DateTime dt;
DateTime.TryParseExact(TextBox1.Text,
                       "dd/MM/yyyy",
                       CultureInfo.InvariantCulture,
                       DateTimeStyles.None,
                       out dt);
TextBox1.Text = dt.ToString("yyyy/MM/dd");

It works good in many cases..

Posted 14-Apr-14 20:59pm

Ajay_Babu

Comments

youseph 15-Apr-14 8:52am

i try it but not working for me

Ajay_Babu 16-Apr-14 0:48am

which error u got?

Solution 3

what datatype did you give in (database) table column?

Posted 14-Apr-14 18:41pm

Umapathi K

Comments

youseph 15-Apr-14 7:48am

datetime for this datadype

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)

youseph · Accepted Answer · 2014-04-15T15:13:00

Solution 5

Hi, thnx all i've solved here the code:

dt = DateTime.ParseExact(TextBox1.Text.ToString().Trim(), "M/d/yyyy", CultureInfo.InvariantCulture);

Posted 15-Apr-14 15:13pm

youseph