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

SqlBulkCopy Tutorial - Knowledge Base (KB)

60 results in tag: asp.net

SqlBulkCopy Doesn't Work

I have a ...DataSet... populated from Excel Sheet. I wanted to use SQLBulk Copy to Insert Records in ...Lead_Hdr... table where ...LeadId... is PK. ...I am having following error while executing the code below:...The given ColumnMapping does not match up ...
asp.net c# sqlbulkcopy
asked by Sandhurst

When using SQLBulkCopy to SQL Server from Excel, you may add text.

I've created a page where our partners can upload excel files with statistics using SQLBulkCopy. The file has multiple sheets and I need to add the name of the sheet into a column in the DB for each row. The names of the sheets will not change so hardcodi...
asp.net import-from-excel sqlbulkcopy
asked by Marcus Lindholm

Before putting into the database, convert String to bit.

Can anyone help in converting string value in C# to bit equivalent in Sql. I'm trying to bulkcopy the values of a datatable into Sql table. All the values I've in the datatable are in string format. When I try to bulkcopy to SQL table I'm getting an er...
asp.net c# sql sqlbulkcopy sql-server
asked by vix

Insert/Update Database using SQLBulkCopy

I have a datatable with the records.I'm inserting records into Sql table using SqlBulkCopy.It works fine.Next time when get the datatable with same records with few changed values SqlBulkCopy is inserting another set of records without updating the previo...
asp.net sqlbulkcopy
asked by vix

SqlBulkCopy error

i use SqlBulkCopy to insert data from OleDbDataReader (contains data from xls) to mssql-2005 i have a cloumn on the OleDbDataReader that contains number stored as text (in the xls) ...when i look into the mssql data i see null in that column all other c...
asp.net c# sqlbulkcopy sql-server-2005
asked by eyalb

In SqlBulkCopy, get SqlDateTime overflow. WriteToServer()

I insert data from a typed dataset into my MSSQL database by using SqlBuldCopy class:...foreach (DataTable dt in ds.Tables) { using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn)) { bulkCopy.DestinationTableName = "dbo." + dt.TableName + "...
asp.net sql sqlbulkcopy
asked by Jack Black

On SQL Server 2000, SqlBulkCopy creates a deadlock.

I have a customized data import executable in .NET 3.5 which the SqlBulkCopy to basically do faster inserts on large amounts of data. The app basically takes an input file, massages the data and bulk uploads it into a SQL Server 2000. It was written by a ...
.net asp.net sql sqlbulkcopy sql-server
asked by stevenjmyu

Why is sqlbulkcopy behaving strangely in an asp.net website based on IIS?

I'm using ...SqlClient.SqlBulkCopy... to try and bulk copy a csv file into a database. I am getting the following error after calling the ..WriteToServer method...."The given value of type String from the data source cannot be converted to type decim...
asp.net c# iis sqlbulkcopy
asked by ACP

With SqlBulkCopy, the timeout has elapsed.

I'm using SqlBulkCopy to restore tables from xml backups. One of the table backup is ~200MB large and has a lot of records....I'm having error:...Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not respond...
.net asp.net sql sqlbulkcopy sql-server
asked by HasanG

When each record is added to the database, bulk copy duplicates it.

Why is my bulk copy duplicating each row, so in my database table the row shows twice. ...Label1.Visible = True Dim tourid As New List(Of String) tourid.Add(TextBox1.Text) Dim tasktype As New List(Of String) Dim tourname1 As New List(Of...
asp.net sqlbulkcopy vb.net
asked by MyHeadHurts

MS Access bulk import and insert into SQL Server

I want to read records from MS Access database and Insert into Sql server database, the process should be bulk insertion. I'm using asp.net/vb.net
asp.net c# ms-access sqlbulkcopy sql-server
asked by hotcoder

ASP.Net to MS-Access 2007 conversion (Bulk Insert, Bulk Copy)

I am download a XML file comprising thousands of records. I want that XML file to convert it to MS-Access 2007 Database using ASP.Net (VB) and run further queries on it. Its worth mentioning that the conversion should be done in bulk because its very heav...
asp.net sqlbulkcopy vb.net xml
asked by Mehboob

ASP.Net SqlBulkCopy is used to insert a constant value into a column.

In the below code, I am trying insert the records from excel to Database table, but an additional column is not passed through the excel, which has to be populated with a constant value(foreach loop with a different value) assigned from the requested page...
asp.net bulkinsert sqlbulkcopy
asked by Ganesha

Informix and SqlBulkCopy

Is there any way to use the ...SqlBulkCopy... class with Informix database, or any alternative, because really I need this class behavior with my Informix database....What I try to do is described in ...SO 6856004.......EDIT :...I don't find ...IfxBulkCop...
.net-3.5 asp.net informix sql sqlbulkcopy
asked by Anyname Donotcare

I'm getting an InvalidOperationException error from SqlBulkCopy because I'm adding null data, yet the table has no null values.

I have a table where one of the fields is "InDatabase" (SQL Server "bit" type) which does not allow nulls....I create a table and add a few hundred rows to it, where InDatabase is always assigned a value (InDatabase refers to whether the row is in another...
asp.net c# sqlbulkcopy
asked by user1004944

Copy certain text data type values to exponential values using ASP.Net SqlBulk.

ASP.Net SqlBulkCopy some text data type values converting to exponential values ...bulkCopy.DestinationTableName = "TABLE NAME"; bulkCopy.ColumnMappings.Add("Mobilenumber", "Mobilenumber"); bulkCopy.WriteToServer(dr); ...above code inserting excel column...
asp.net sqlbulkcopy
asked by Ganesha

Why Doesn't My SqlBulkCopy Work?

I am using SqlBulkCopy object to write a datatable into an sql server table. However, everytime I recheck my database it remains intact with no changes. A...I have tried to do Google search to determine my problem but i am unable to resolve it....The data...
asp.net c# sqlbulkcopy sql-server-2005
asked by rofans91

How to Update a SQL Server Table Using Data from a Different Source (DataTable)

I have a ...DataTable... which is generated from .xls table....I would like to store this ...DataTable... into an existing table in SQL Server database....I use ...SqlBulkCopy... to store rows which have ...unique PK.......Problem is, I also have other ro...
asp.net c# datatable sqlbulkcopy sql-server-2005
asked by rofans91

On the local computer, the 'Microsoft.ACE.OLEDB.12.0' provider is not registered.

i have followed the answer to this thread ...C# import excel filesheet to sql database error... and am able to import excel data into an SQL Server Database. The only problem am having is that the Import works only when am running the website locally from...
asp.net oledb sqlbulkcopy sql-server-2005
asked by StackTrace

The bulk copy from the data table in sql does not upload.

Hello I have the code below that for some reason is not working:...I use oledb to fill a dataset from a pipe delimited file that is uploaded through a fileupload control on an asp.net web application. I then take the data table and then use sql bulk copy ...
asp.net c# sql sqlbulkcopy
asked by Jeff

Page 1 of 3
  • 1
  • 2
  • 3
  • ยป

Prime Library

Performance

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

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!