Databases
StackOverflow2013
Postsdbo
POError: the conversion of a varchar data type to a datetime data type resulted in an out-of-range value
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POError: the conversion of a varchar data type to a datetime data type resulted in an out-of-range value
    primarykey
    data
    text
    <p>I'm trying to enter data into my SQL Server 2008 using data from a form. I am using a DateTimePicker to select dates from a form and enters this data to the db, however when I try to run the form I'm getting the following error:</p> <blockquote> <p><em>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.<br> The statement has been terminated</em></p> </blockquote> <p>This is the code for my form below:</p> <pre><code>private void btnAddBooking_Click(object sender, EventArgs e) { DateTime requested = dtpRequested.Value; DateTime pickup = dtpPickup.Value; DateTime estDropoff = dtpEstimatedDrop.Value; SAF.AddNewBooking(requested, pickup, estDropoff, selectedStatus.StatusId, selectedRate.RateId); dtpRequested.CustomFormat = " "; dtpPickup.CustomFormat = " "; dtpEstimatedDrop.CustomFormat = " "; cbStatus.SelectedIndex = 0; cbRateOfPayment.SelectedIndex = 0; MessageBox.Show("Booking Created"); tabControl2.SelectTab(2); } </code></pre> <p>Here is code in the facade where I store the method:</p> <pre><code>public void AddNewBooking(DateTime requestedD, DateTime pickupD, DateTime estDropOff, int statusId, int rateId) { dao.AddNewBooking(requestedD, pickupD, estDropOff, statusId, rateId); }//end CreateBooking </code></pre> <p>and this is the <code>INSERT</code> statement code in my DAO:</p> <pre><code>sql = "INSERT INTO [Transaction] (TransactionId, RequestedDateOfPickup, ActualDateOfPickup, EstimatedDropOffDate, StatusId, RateId)"; sql += String.Format("VALUES('{0}', '{1}', '{2}', '{3}', {4}, {5})", transactionId, requestedD, pickupD, estDropOff, statusId, rateId); cn = new SqlConnection(Properties.Settings.Default.UKRENTALSConnectionString); cmd = new SqlCommand(sql, cn); cn.Open(); cmd.ExecuteNonQuery(); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmarc_s
    1. USAaron Mohammed
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POError: the conversion of a varchar data type to a datetime data type resulted in an out-of-range value
      1. This table or related slice is empty.
      1. VTUpMod
    1. COUse [Parameters](http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter.aspx) ,will save you from SQL Injection and it might solve your error as well.
      singulars
      1. POError: the conversion of a varchar data type to a datetime data type resulted in an out-of-range value
      1. USHabib
    2. COIt was all going *so* well, until you decided to throw away the data types and treat everything as a string. As @Habib mentions, you ought to use parameters. Also, `Transaction` is a really poor name for a table (as would any other keyword be)
      singulars
      1. POError: the conversion of a varchar data type to a datetime data type resulted in an out-of-range value
      1. USDamien_The_Unbeliever
 

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