Databases
StackOverflow2013
Postsdbo
POThe conversion of a varchar data type to a datetime data type resulted in an out-of-range value error
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POThe conversion of a varchar data type to a datetime data type resulted in an out-of-range value error
    primarykey
    data
    text
    <p>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value error</p> <p>I'm trying to enter data into my table using a form, the date formats in both the form validation and the sql server are both dd/mm/yy, however when i try to submit data from the form with a day higher than 12 (e.g. 13/12/2012) it throws an exception whose cause is "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value error", and if i try to enter data into the form in a mm/dd/yy format it states "wrong date format" which is suppose means that the dd/mm/yy format is the correct format</p> <p>here's the code for my form below:</p> <pre><code> private void btnAddProject_Click(object sender, EventArgs e) { DateTime startDate; DateTime endDate; if (txtProjectName.Text == "") //client side validation { MessageBox.Show("Enter Project Name"); return; } try { startDate = DateTime.Parse(txtProjectStart.Text); endDate = DateTime.Parse(txtProjectEnd.Text); } catch (Exception) { MessageBox.Show("Wrong Date Format"); return; } fa.CreateProject(txtProjectName.Text, startDate, endDate, (int)cbCustomers.SelectedValue, ptsUser.Id); txtProjectName.Text = ""; txtProjectStart.Text = ""; txtProjectEnd.Text = ""; cbCustomers.SelectedIndex = 0; MessageBox.Show("Project Created"); adminControl.SelectTab(2); }// end btnAddProject </code></pre> <p>And this is the code in my DAO:</p> <pre><code>public void CreateProject(string name, DateTime startDate, DateTime endDate, int customerId, int administratorId) { string sql; SqlConnection cn; SqlCommand cmd; Guid projectId = Guid.NewGuid(); sql = "INSERT INTO Project (ProjectId, Name, ExpectedStartDate, ExpectedEndDate, CustomerId, AdministratorId)"; sql += String.Format("VALUES('{0}', '{1}', '{2}', '{3}', {4}, {5})", projectId, name, startDate, endDate, customerId, administratorId); cn = new SqlConnection(Properties.Settings.Default.WM75ConnectionString); cmd = new SqlCommand(sql, cn); try { cn.Open(); cmd.ExecuteNonQuery(); } catch (SqlException ex) { throw new Exception("Error Creating Project", ex); } finally { cn.Close(); } }//end CreateProject Method </code></pre> <p>This is my code for my facade:</p> <pre><code>public void CreateProject(string name, DateTime startDate, DateTime endDate, int customerId, int administratorId) { dao.CreateProject(name, startDate, endDate, customerId, administratorId); }//end CreateProject </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USD Stanley
    1. USAaron Mohammed
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POThe conversion of a varchar data type to a datetime data type resulted in an out-of-range value error
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload