本文介绍了我有一个错误，不知道如何解决。错误详情如下的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
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
What I have tried:
hare 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">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<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="font-size: 24pt; color: #000033; font-family: Monotype Corsiva">
<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 ID="TextBox2" runat="server" Style="z-index: 101; left: 464px; position: absolute;
top: 88px">
<asp:DropDownList ID="DropDownList3" runat="server" Style="z-index: 125; left: 464px;
position: absolute; top: 128px" Width="152px">
<asp:ListItem>--select--
<asp:ListItem>.Net
<asp:TextBox ID="TextBox5" runat="server" Style="z-index: 103; left: 336px; position: absolute;
top: 192px" OnTextChanged="TextBox5_TextChanged">
<asp:TextBox ID="TextBox6" runat="server" Style="z-index: 104; left: 80px; position: absolute;
top: 272px">
<asp:TextBox ID="TextBox7" runat="server" Style="z-index: 105; left: 328px; position: absolute;
top: 272px" TextMode="Password">
<span style="text-decoration: underline"> </span>
<asp:TextBox ID="TextBox8" runat="server" Style="z-index: 106; left: 600px; position: absolute;
top: 272px" TextMode="Password">
<span style="text-decoration: underline"></span>
<asp:TextBox ID="TextBox9" runat="server" Style="z-index: 107; left: 600px; position: absolute;
top: 320px">
<span style="text-decoration: underline"></span></span>
<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 ID="Label2" runat="server" Font-Bold="True" Style="z-index: 111; left: 8px;
position: absolute; top: 96px" Text="Name">
<asp:Label ID="Label3" runat="server" Font-Bold="True" Style="z-index: 112; left: 336px;
position: absolute; top: 96px" Text="DOB">
<asp:Label ID="Label4" runat="server" Font-Bold="True" Style="z-index: 113; left: 8px;
position: absolute; top: 144px" Text="Gender">
<asp:Label ID="Label5" runat="server" Font-Bold="True" Style="z-index: 114; left: 336px;
position: absolute; top: 136px" Text="Branch">
<asp:Label ID="Label6" runat="server" Font-Bold="True" Style="z-index: 115; left: 256px;
position: absolute; top: 192px" Text="College">
<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 ID="Label8" runat="server" Font-Bold="True" Style="z-index: 117; left: 0px;
position: absolute; top: 272px" Text="User Id">
<asp:Label ID="Label9" runat="server" Font-Bold="True" Style="z-index: 118; left: 248px;
position: absolute; top: 272px" Text="Password">
<asp:Label ID="Label11" runat="server" Font-Bold="True" Style="z-index: 119; left: 536px;
position: absolute; top: 328px" Text="Answer">
<asp:DropDownList ID="DropDownList1" runat="server" Style="z-index: 120; left: 80px;
position: absolute; top: 328px" Width="152px">
<asp:ListItem>--select--
<asp:ListItem>Admin
<asp:ListItem>Instructor
<asp:ListItem>Student
<asp:DropDownList ID="DropDownList2" runat="server" Style="z-index: 121; left: 352px;
position: absolute; top: 328px" Width="160px">
<asp:ListItem>--select--
<asp:ListItem>what is your pet name?
<asp:ListItem>who is your favourite cricketer?
<asp:ListItem>what is your ssn ?
<asp:Label ID="Label12" runat="server" Font-Bold="True" Style="z-index: 122; left: 280px;
position: absolute; top: 328px" Text="Question">
<asp:Label ID="Label13" runat="server" Font-Bold="True" Style="z-index: 123; left: 0px;
position: absolute; top: 328px" Text="User Type">
<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: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>Male
</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)
{
}
}推荐答案
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 + "','" //string to DateTime conversion
+ RadioButtonList1.SelectedItem.Text + "','"
+ DropDownList3.SelectedItem.Text + "','"
+ TextBox5.Text + "','"
+ TextBox6.Text + "','"
+ TextBox7.Text + "','"
+ TextBox8.Text + "','"
+ DropDownList1.SelectedItem.Text + "','"
+ DropDownList2.SelectedItem.Text + "','"
+ TextBox9.Text + "')";
And, take a look at []
Follow the guidelines on Solution 1.
And, take a look at Casting and Type Conversions (C# Programming Guide)[^]
Follow the guidelines on Solution 1.
这篇关于我有一个错误，不知道如何解决。错误详情如下的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！