stelle thomas

NA
19
3.8k

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

Mar 16 2016 2:26 AM

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" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

</head>

<body>

<div>

<asp:Panel ID="Panel1" runat="server" BackColor="Transparent" BorderColor="Black"

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

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

    <span style="text-decoration: underline">Registration Form</span>       

<asp:TextBox ID="TextBox1" runat="server" Style="z-index: 100; left: 72px; position: absolute;

top: 96px"></asp:TextBox>

<asp:TextBox ID="TextBox2" runat="server" Style="z-index: 101; left: 464px; position: absolute;

top: 88px"></asp:TextBox>

<asp:DropDownList ID="DropDownList3" runat="server" Style="z-index: 125; left: 464px;

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

<asp:ListItem>--select--</asp:ListItem>

<asp:ListItem>.Net</asp:ListItem>

</asp:DropDownList>

<asp:TextBox ID="TextBox5" runat="server" Style="z-index: 103; left: 336px; position: absolute;

top: 192px" OnTextChanged="TextBox5_TextChanged"></asp:TextBox>

<asp:TextBox ID="TextBox6" runat="server" Style="z-index: 104; left: 80px; position: absolute;

top: 272px"></asp:TextBox>

<asp:TextBox ID="TextBox7" runat="server" Style="z-index: 105; left: 328px; position: absolute;

top: 272px" TextMode="Password"></asp:TextBox>

<asp:TextBox ID="TextBox8" runat="server" Style="z-index: 106; left: 600px; position: absolute;

top: 272px" TextMode="Password"></asp:TextBox>

<asp:TextBox ID="TextBox9" runat="server" Style="z-index: 107; left: 600px; position: absolute;

top: 320px"></asp:TextBox>

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Style="z-index: 108;

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

<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Style="z-index: 109;

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

<asp:Label ID="Label1" runat="server" BackColor="LemonChiffon" Font-Bold="True" ForeColor="Red"

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

Width="784px"></asp:Label>

<asp:Label ID="Label2" runat="server" Font-Bold="True" Style="z-index: 111; left: 8px;

position: absolute; top: 96px" Text="Name"></asp:Label>

<asp:Label ID="Label3" runat="server" Font-Bold="True" Style="z-index: 112; left: 336px;

position: absolute; top: 96px" Text="DOB"></asp:Label>

<asp:Label ID="Label4" runat="server" Font-Bold="True" Style="z-index: 113; left: 8px;

position: absolute; top: 144px" Text="Gender"></asp:Label>

<asp:Label ID="Label5" runat="server" Font-Bold="True" Style="z-index: 114; left: 336px;

position: absolute; top: 136px" Text="Branch"></asp:Label>

<asp:Label ID="Label6" runat="server" Font-Bold="True" Style="z-index: 115; left: 256px;

position: absolute; top: 192px" Text="College"></asp:Label>

<asp:Label ID="Label7" runat="server" BackColor="LemonChiffon" Font-Bold="True" ForeColor="Red"

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

Width="784px"></asp:Label>

<asp:Label ID="Label8" runat="server" Font-Bold="True" Style="z-index: 117; left: 0px;

position: absolute; top: 272px" Text="User Id"></asp:Label>

<asp:Label ID="Label9" runat="server" Font-Bold="True" Style="z-index: 118; left: 248px;

position: absolute; top: 272px" Text="Password"></asp:Label>

<asp:Label ID="Label11" runat="server" Font-Bold="True" Style="z-index: 119; left: 536px;

position: absolute; top: 328px" Text="Answer"></asp:Label>

<asp:DropDownList ID="DropDownList1" runat="server" Style="z-index: 120; left: 80px;

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

<asp:ListItem>--select--</asp:ListItem>

<asp:ListItem>Admin</asp:ListItem>

<asp:ListItem>Instructor</asp:ListItem>

<asp:ListItem>Student</asp:ListItem>

</asp:DropDownList>

<asp:DropDownList ID="DropDownList2" runat="server" Style="z-index: 121; left: 352px;

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

<asp:ListItem>--select--</asp:ListItem>

<asp:ListItem>what is your pet name?</asp:ListItem>

<asp:ListItem>who is your favourite cricketer?</asp:ListItem>

<asp:ListItem>what is your ssn ?</asp:ListItem>

</asp:DropDownList>

<asp:Label ID="Label12" runat="server" Font-Bold="True" Style="z-index: 122; left: 280px;

position: absolute; top: 328px" Text="Question"></asp:Label>

<asp:Label ID="Label13" runat="server" Font-Bold="True" Style="z-index: 123; left: 0px;

position: absolute; top: 328px" Text="User Type"></asp:Label>

<asp:Label ID="Label14" runat="server" Font-Bold="True" Height="8px" Style="z-index: 124;

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

<asp:RadioButtonList ID="RadioButtonList1" runat="server" Font-Bold="True" RepeatDirection="Horizontal"

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

<asp:ListItem>Female</asp:ListItem>

<asp:ListItem>Male</asp:ListItem>

</asp:RadioButtonList>

</asp:Panel>

</div>

</form>

</body>

</html>

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)

{

}

Answers (11)

Lock form by password

Dropdownlist error.