zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

9 results for: in tag: datetime

Error inserting data using SqlBulkCopy

I'm trying to batch insert data into SQL 2008 using ...SqlBulkCopy.......Here is my table:...IF OBJECT_ID(N'statement', N'U') IS NOT NULL DROP TABLE [statement] GO CREATE TABLE [statement]( [ID] INT IDENTITY(1, 1) NOT NULL, [date] DATE NOT NULL DEFAUL...
ado.net c# datetime sqlbulkcopy sql-server
asked by abatishchev

SQLBulkCopy and Dates (1/1/1753)

I've got an application which has been working fine for quite a while, but there is an annoying item that continues to get in the way on occasion. ...Let's say that I use an object such as OracleDataReader or MySQLDataReader to pass the data to the sqlbul...
ado.net datetime sqlbulkcopy sql-server
asked by mdjtlj

Using the SQL bulk copy in C# and deleting the string headers

The code below is what I use for inserting the data stored in txt file to sql:... public void extract_data() { openFileDialog1.ShowDialog(); DataTable dt = new DataTable(); StreamReader sr = new StreamReader(openFileDialog1.Fil...
c# datetime sql sqlbulkcopy sql-server
asked by Lucas Juan

Date Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM OverFlow error SqlBulkCopy

I am reading data from an access db and storing it in a temporary sql table then truncate the main sql table and insert the fresh data set and i am accomplishing that task using the code below but the datetime is giving me issues:...Console.WriteLine("Net...
c# console-application datetime sqlbulkcopy sql-server-2008
asked by ExpertWannaBe

insert data using WriteToServer method datetime column gives exception

I am trying to insert a ...DateTime... into a column who data type is datetime. The value is assigned using ...DateTime.Now..., so I know that there isn't an issue with incorrect types in the code....The exception I get is:...The given value of type Strin...
c# datetime sqlbulkcopy sql-server
asked by Neha Thakur

sqlbulkcopy - When converting string to DateTime

I am using this code to insert a csv file to my database:... private void InsertDataIntoSQLServerUsingSQLBulkCopy(DataTable csvFileData) { using (SqlConnection dbConnection = new SqlConnection(ConnectionString)) { dbConn...
c# csv datetime excel sqlbulkcopy
asked by TeaAnyOne

CSV to SQL - Add 1 day to a Date in a datacolumn

I am trying to add 1 day to all dates that are in a certain datacolumn ['RecordAddedDate']...csvData.Columns.AddRange(new DataColumn[3] { new DataColumn("Manufacturer", typeof(string)), new DataColumn("SupplierCode", typeof(string)), ...
c# csv datacolumn datetime sqlbulkcopy
asked by TeaAnyOne

Powershell inserting DataTable with SqlBulkCopy, that hold datetime columns

I'm trying to insert a predefined ...DataTable... into a SQL Server database, using ...Data.SqlClient.SqlBulkCopy.......There are different datatypes in the ...DataTable..., but the problem is with ...Datetime... columns....Like this one:...$Datatable.Col...
datatable datetime powershell sqlbulkcopy sql-server
asked by Simon Bruun

SQL Bulkcopy coverting data type

In my .Net project I am loading in a CSV file so I can take that data, do some stuff with it, and fire out the results into an excel file. ...I'm handling this through a data table inside my code. In my results file, I have added a new column which I call...
c# datetime parsing sqlbulkcopy sql-server
asked by N0xus

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...