SqlBulkCopy Tutorial - Knowledge Base (KB)
60 results in tag: asp.net
SqlBulkCopy Not Working
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
Add text when using SQLBulkCopy to SQL Server from excel
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
Converting String to bit before inserting into the database
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
Using SQLBulkCopy to Insert/Update database
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 problem
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
Get SqlDateTime overflow in SqlBulkCopy.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
SqlBulkCopy causes Deadlock on SQL Server 2000
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 this strange behavior of sqlbulkcopy in a asp.net website running under 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
Timeout expired with SqlBulkCopy
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
bulk copy duplicating each row when it is added to database
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
Bulk import from MS Access 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
XML to MS-Access 2007 using ASP.Net (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
How to insert a constant value into a column using ASP.Net SqlBulkCopy
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
SqlBulkCopy with Informix
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
SqlBulkCopy giving InvalidOperationException Error that I am inserting Null Values, but all values are non-null in the table
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
ASP.Net SqlBulkCopy some text data type values converting to exponential values
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 My SqlBulkCopy Is Not Working
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 SQL Server Table With Data From Other 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
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
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
sql bulk copy from data table will 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