I am getting error while inserting date in sql database :
My SQL Table Structure is
Column Name | DB TYPE
ID ---- INT -----Autogenerated -- PKey
Proj_StartDate ---- Date
In Application i have created a class for holding variable properties then linking this class to another class where my insert method is residing :
public class ProjectMaker
{
public string Proj_StartDate { get; set; }
}
Now the Class in which i am linking above Class Property is :
public class ProjectMaker_DB
{
public static void InsertRecord(ProjectMaker model)
{
var cmd = new SqlCommand
{
CommandType = CommandType.StoredProcedure,
CommandText = "[dbo].[sproc_INSERT_d_project_p]"
};
cmd.Parameters.AddWithValue("@Proj_StDate", model.Proj_StartDate);
cmd.Connection = Con;
Con.Open();
cmd.ExecuteNonQuery();
Con.Close();
}
}
That was my Class library project , Now here's my Coding for button click event in startup project :
protected void SubmitProject_OnServerClick(object sender, EventArgs e)
{
if (SubmitProject.InnerHtml.Contains("Submit"))
{
#region Submit Section
try
{
var rec = new ABC_Library.ProjectMaker()
{
Proj_StartDate = Convert.ToDateTime(Start_CalendarExtender.SelectedDate).ToString(),
};
ProjectMaker_DB.InsertRecord(rec);
MainMessagesPanel.Visible = true;
MainMessagesPanelLabel.Text = "Record Inserted Successfully !";
MainMessagesUpdatePanel.Update();
}
catch (Exception ex)
{
TryCatchPanel.Visible = true;
TryCatchLabel.Text = ex.Message;
}
return;
#endregion
}
}
I am getting start date from Ajax calendar extender toolkit's Selected Date .
after clicking Submit Button it gives me error : "Input string was not in a correct format"