Conversion failed when converting date and/or time

Jan 23 2015 7:36 AM

Hello all,

I am stuck with below error i am unable to understand the error. Please help me out.

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

below is my source code and C# code.

Source code

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

<!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></title>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:Panel ID="popUpPanel" runat="server">

<table frame="border">
<tr>
<td>
<asp:Label ID="lblName" runat="server" Text="Task Name"></asp:Label></td>
<td class="style1">
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtName" ErrorMessage="Enter TaskName"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label Id="lblDescription" runat="server" Text="Description"></asp:Label>
</td>
<td class="style1">
<asp:TextBox ID="txtdescription" runat="server" TextMode="MultiLine"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ControlToValidate="txtdescription" ErrorMessage="Enter description"
ForeColor="Red"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblAssigned" runat="server" Text="Assign To"></asp:Label>
</td>
<td class="style1">
&nbsp;
<asp:TextBox ID="TextBox1" runat="server" ReadOnly="true"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblDate" runat="server" Text="Task Date"></asp:Label>
</td>
<td class="style1">
<asp:TextBox ID="txtdate" runat="server"></asp:TextBox>
<asp:Button ID="Calendarbtn" runat="server" Text="..." CausesValidation="false" onclick="Calendarbtn_Click"
/>
<asp:calendar id="cdrCalendar" runat="server"
backcolor="#ffffff" width="250px" height="200px"
font-size="12px" font-names="Arial" borderwidth="2px"
bordercolor=175"#000000" nextprevformat="shortmonth"
daynameformat="firsttwoletters" Visible="False" onselectionchanged="cdrCalendar_SelectionChanged"
>
<TodayDayStyle ForeColor="White" BackColor="Black"></TodayDayStyle>
<NextPrevStyle Font-Size="12px" Font-Bold="True" ForeColor="#333333">
</NextPrevStyle>
<DayHeaderStyle Font-Size="12px" Font-Bold="True"></DayHeaderStyle>
<TitleStyle Font-Size="14px" Font-Bold="True" BorderWidth="2px"
ForeColor="#000055"></TitleStyle>
<OtherMonthDayStyle ForeColor="#CCCCCC"></OtherMonthDayStyle>
</asp:calendar>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate="txtdate" ErrorMessage="Select Date"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblTaskStart" runat="server" Text="Start Time"></asp:Label></td>
<td class="style1">
<asp:DropDownList ID="drpdwnhr" runat="server">
<asp:ListItem>01</asp:ListItem>
<asp:ListItem>02</asp:ListItem>
<asp:ListItem>03</asp:ListItem>
<asp:ListItem>04</asp:ListItem>
<asp:ListItem>05</asp:ListItem>
<asp:ListItem>06</asp:ListItem>
<asp:ListItem>07</asp:ListItem>
<asp:ListItem>08</asp:ListItem>
<asp:ListItem>09</asp:ListItem>
<asp:ListItem>10</asp:ListItem>
<asp:ListItem>11</asp:ListItem>
<asp:ListItem>12</asp:ListItem>
<asp:ListItem>11</asp:ListItem>
<asp:ListItem>12</asp:ListItem>
<asp:ListItem>13</asp:ListItem>
<asp:ListItem>14</asp:ListItem>
<asp:ListItem>15</asp:ListItem>
<asp:ListItem>16</asp:ListItem>
<asp:ListItem>17</asp:ListItem>
<asp:ListItem>18</asp:ListItem>
<asp:ListItem>19</asp:ListItem>
<asp:ListItem>20</asp:ListItem>
<asp:ListItem>21</asp:ListItem>
<asp:ListItem>22</asp:ListItem>
<asp:ListItem>23</asp:ListItem>
<asp:ListItem>24</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="drpdwnmin" runat="server">
<asp:ListItem>00</asp:ListItem>
<asp:ListItem>15</asp:ListItem>
<asp:ListItem>30</asp:ListItem>
<asp:ListItem>45</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblend" runat="server" Text="End Time"></asp:Label></td>
<td class="style1">
<asp:DropDownList ID="DropDownListhr" runat="server">
<asp:ListItem>01</asp:ListItem>
<asp:ListItem>02</asp:ListItem>
<asp:ListItem>03</asp:ListItem>
<asp:ListItem>04</asp:ListItem>
<asp:ListItem>05</asp:ListItem>
<asp:ListItem>06</asp:ListItem>
<asp:ListItem>07</asp:ListItem>
<asp:ListItem>08</asp:ListItem>
<asp:ListItem>09</asp:ListItem>
<asp:ListItem>10</asp:ListItem>
<asp:ListItem>11</asp:ListItem>
<asp:ListItem>12</asp:ListItem>
<asp:ListItem>11</asp:ListItem>
<asp:ListItem>12</asp:ListItem>
<asp:ListItem>13</asp:ListItem>
<asp:ListItem>14</asp:ListItem>
<asp:ListItem>15</asp:ListItem>
<asp:ListItem>16</asp:ListItem>
<asp:ListItem>17</asp:ListItem>
<asp:ListItem>18</asp:ListItem>
<asp:ListItem>19</asp:ListItem>
<asp:ListItem>20</asp:ListItem>
<asp:ListItem>21</asp:ListItem>
<asp:ListItem>22</asp:ListItem>
<asp:ListItem>23</asp:ListItem>
<asp:ListItem>24</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="DropDownListmin" runat="server">
<asp:ListItem>00</asp:ListItem>
<asp:ListItem>15</asp:ListItem>
<asp:ListItem>30</asp:ListItem>
<asp:ListItem>45</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Label Id="lblHours" runat="server" Text="Task hours"></asp:Label>
</td>
<td class="style1">
<asp:TextBox ID="txthours" runat="server" ></asp:TextBox>

</td>
</tr>
<tr>
<td>
<asp:Label Id="lblPriorty" runat="server" Text="Task Priority"></asp:Label>
</td>
<td class="style1">
<asp:DropDownList ID="Priority" runat="server">
<asp:ListItem></asp:ListItem>
<asp:ListItem>Very High*</asp:ListItem>
<asp:ListItem>High</asp:ListItem>
<asp:ListItem>Medium</asp:ListItem>
<asp:ListItem>Low</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Button ID="btnsave" runat="server" Text="Save" onclick="btnsave_Click" />
</td>
<td class="style1">
<asp:Button ID="btnCancel" runat="server" Text="Cancel" />
</td>
</tr>
</table>
</asp:Panel>

</div>

</form>
</body>
</html>

C# code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void btnsave_Click(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["NewTaskConnectionString"].ConnectionString);
try
{
if (con1.State == ConnectionState.Open)
con1.Close();
con1.Open();
string strQuery = "INSERT INTO Task(Taskname,Taskdescription,Assignedto,Taskdate,Starttime,Endtime,Hours,Priority) VALUES('" + txtName.Text + "','" + txtdescription.Text + "','" + Session["Username"].ToString() + "','" + txtdate.Text + "','" + drpdwnhr.SelectedItem.Text.Trim() + "-" + drpdwnmin.SelectedItem.Text.Trim() + "-" + "','" + drpdwnhr.SelectedItem.Text.Trim() + "-" + drpdwnmin.SelectedItem.Text.Trim() + "','" + txthours.Text + "','" + Priority.SelectedValue + "')";
SqlCommand sqlcmd = new SqlCommand(strQuery, con1);
int i = Convert.ToInt32(sqlcmd.ExecuteNonQuery());
con1.Close();
if (i == 0)
{
Response.Write( "Error");
}

else if (i >= 1)
{
Response.Write ("Data Saved Successfully");

}
}
catch (Exception ex)
{
throw ex;
}
}
protected void Calendarbtn_Click(object sender, EventArgs e)
{
try
{
if (txtdate.Text.Trim() != "")
cdrCalendar.SelectedDate = Convert.ToDateTime(txtdate.Text);
}
catch
{ }
cdrCalendar.Visible = true;
}
protected void cdrCalendar_SelectionChanged(object sender, EventArgs e)
{
txtdate.Text = cdrCalendar.SelectedDate.ToShortDateString();
cdrCalendar.Visible = false; //hiding the calendar.
}
}

Thanks,
Laxman


Answers (1)