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 ...
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...
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...
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...
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...
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 + "...
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 ...
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...
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...
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...
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
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
asked by Jeff
Page 1 of 3