I am having one error and don't know how to solve.

Conversion failed when converting date and/or time from character string.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Conversion failed when converting date and/or time from character string.

Source Error:

Line 29:         string s1 = "insert into Registration values('"+TextBox1.Text+"','"+TextBox2.Text+"','"+RadioButtonList1.SelectedItem.Text+"','"+DropDownList3.SelectedItem.Text+"','"+TextBox5.Text+"','"+TextBox6.Text+"','"+TextBox7.Text+"','"+TextBox8.Text+"','"+DropDownList1.SelectedItem.Text+"','"+DropDownList2.SelectedItem.Text+"','"+TextBox9.Text+"')"; Line 30:         SqlCommand cmd = new SqlCommand(s1, con); Line 31:         cmd.ExecuteNonQuery(); Line 32:         Response.Redirect("RegAck.aspx"); Line 33:     }

Source File: c:\Users\Dixit\Desktop\DOWNLOADED PROJECT\online-e\online-e\78\onlineexamination\Register.aspx.cs Line: 31

Stack Trace:

[SqlException (0x80131904): Conversion failed when converting date and/or time from character string.]    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1961130    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4890575    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2412    System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +317    System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137    Register.Button1_Click(Object sender, EventArgs e) in c:\Users\Dixit\Desktop\DOWNLOADED PROJECT\online-e\online-e\78\onlineexamination\Register.aspx.cs:31    System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111    System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110    System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Version Information: Microsoft .NET Framework Version:2.0.50727.8009; ASP.NET Version:2.0.50727.8015

HERE IS MY register.aspx file :

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Register.aspx.cs" Inherits="Register" %>

Untitled Page

BorderWidth="2px" Height="416px" Style="z-index: 100; left:96px; position: absolute;

top: 32px" Width="792px" BackImageUrl="~/pictures/img30.jpg">

Registration Form

top: 96px">

top: 88px">

position: absolute; top: 128px" Width="152px">

--select--

.Net

top: 192px" OnTextChanged="TextBox5_TextChanged">

top: 272px">

top: 272px" TextMode="Password">

top: 320px">

left: 264px; position: absolute; top: 368px" Text="Submit" Height="30px" Width="70px" />

left: 448px; position: absolute; top: 368px" Text="Cancel" Height="30px" Width="70px" />

Style="z-index: 110; left: 0px; position: absolute; top: 56px" Text="Personnel Details"

Width="784px">

position: absolute; top: 96px" Text="Name">

position: absolute; top: 96px" Text="DOB">

position: absolute; top: 144px" Text="Gender">

position: absolute; top: 136px" Text="Branch">

position: absolute; top: 192px" Text="College">

Style="z-index: 116; left: 0px; position: absolute; top: 232px" Text="Login Details"

Width="784px">

position: absolute; top: 272px" Text="User Id">

position: absolute; top: 272px" Text="Password">

position: absolute; top: 328px" Text="Answer">

position: absolute; top: 328px" Width="152px">

--select--

Admin

Instructor

Student

position: absolute; top: 328px" Width="160px">

--select--

what is your pet name?

who is your favourite cricketer?

what is your ssn ?

position: absolute; top: 328px" Text="Question">

position: absolute; top: 328px" Text="User Type">

left: 512px; position: absolute; top: 264px" Text="Re-Enter Password" Width="72px">

Style="z-index: 102; left: 72px; position: absolute; top: 136px">

Female

Male

HERE IS MY register.aspx.cs file :

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class Register : System.Web.UI.Page

{

SqlConnection con = new SqlConnection();

public Register()

{

con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();

}

protected void Page_Load(object sender, EventArgs e)

{

con.Open();

}

protected void Button1_Click(object sender, EventArgs e)

{

Session["sid"] = TextBox6.Text;

string s1 = "insert into Registration values('"+TextBox1.Text+"','"+TextBox2.Text+"','"+RadioButtonList1.SelectedItem.Text+"','"+DropDownList3.SelectedItem.Text+"','"+TextBox5.Text+"','"+TextBox6.Text+"','"+TextBox7.Text+"','"+TextBox8.Text+"','"+DropDownList1.SelectedItem.Text+"','"+DropDownList2.SelectedItem.Text+"','"+TextBox9.Text+"')";

SqlCommand cmd = new SqlCommand(s1, con);

cmd.ExecuteNonQuery();

Response.Redirect("RegAck.aspx");

}

protected void Button2_Click(object sender, EventArgs e)

{

TextBox1.Text = "";

TextBox2.Text = "";

TextBox5.Text = "";

TextBox6.Text = "";

TextBox7.Text = "";

TextBox8.Text = "";

TextBox9.Text = "";

DropDownList1.SelectedItem.Text = DropDownList1.Items[0].Text;

DropDownList2.SelectedItem.Text = DropDownList2.Items[0].Text;

DropDownList3.SelectedItem.Text = DropDownList3.Items[0].Text;

RadioButtonList1.Items[0].Selected = false;

RadioButtonList1.Items[1].Selected = false;

}

protected void TextBox5_TextChanged(object sender, EventArgs e)

{

}

11 Replies

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

Amit Kumar Singh10y ago
Good
stelle thomas10y ago
I got the solution for that..... by referring this : DateConverted.ToString("dd-MM-yyyy")
stelle thomas10y ago
I got it thank you so much....my problem is solved by applying below solution

DateTime DateConverted;
bool IsValid = DateTime.TryParse(TextBox2.Text.Trim(), out DateConverted);
if(IsValid == false)
{
return; //value in TextBox2 is not valid
}
string s1 = "insert into Registration values('" + TextBox1.Text + "','" + DateConverted + "')";

If I want to change the date format i.e. from yyyy-mm-dd to dd-mm-yyyy then what changes should I do?
Amit Kumar Singh10y ago
u r using datetime datatype

So, yyyy-mm-dd try this..if still error is there
then
cast it
stelle thomas10y ago
2014
Amit Kumar Singh10y ago
SQL SERVER MGT STUDIO VERSION
Chandu Kumawat10y ago
if you want to use CAST, replace with:
```
CAST('2014-07-23 09:37:00.000' AS datetime2)
```
Amit Kumar Singh10y ago
Insert date in this order

dd/mm/yyyy
stelle thomas10y ago
have a look at my Registration table :

CREATE TABLE [dbo].[Registration]
(
[Id] INT IDENTITY (100, 1) NOT NULL,
[name] VARCHAR (50) NOT NULL,
[DOB] DATETIME NOT NULL,
[gender] VARCHAR (50) NOT NULL,
[branch] VARCHAR (50) NOT NULL,
[college] VARCHAR (50) NOT NULL,
[uid] VARCHAR (50) NOT NULL,
[pwd] VARCHAR (50) NOT NULL,
[rpwd] VARCHAR (50) NOT NULL,
[utype] VARCHAR (50) NOT NULL,
[que] VARCHAR (500) NOT NULL,
[ans] VARCHAR (5000) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);

then also same error is coming
Chandu Kumawat10y ago
set properly datatype in database field like datetime column have datetime datatype
Amit Kumar Singh10y ago
Hey refer this

1.http://stackoverflow.com/questions/24907360/conversion-failed-when-converting-date-and-or-time-from-character-string-in-sql

2.http://stackoverflow.com/questions/14119133/conversion-failed-when-converting-date-and-or-time-from-character-string-while-i