by: Roy |
last post by:
For SqlBulkCopy class, is there a way to add columns that are not persisted
when WriteToServer(DataTable) is called? I have information to be cache
temperarily with the record and not need to be...
|
by: Oscar Thornell |
last post by:
Hi,
I am trying to enlist an instance of SqlBulkCopy into a transaction. When I
executes and try to write to the database IŽll get an exception indicating a
transactional deadlock.
...
|
by: Cwappy |
last post by:
I have a class that builds a DataTable and then, when the process is
exiting, tries to write that DataTable to SQL Server 2000 via the
SqlBulkCopy class. I know the process is exiting because I'm...
|
by: harleedavidson |
last post by:
Using SqlBulkCopy.WriteToServer to upload a datatable and getting:
System.Data.SqlClient.SqlException
Line 1: Incorrect syntax near 'COLLATE'.
Database Server is SQL2000, database in in 6.5...
|
by: Chris |
last post by:
I have created a datatable from a csv file. One of the columns is an integer
which sometimes can be blank. When it is blank I add a dbnull.value to the
column when I add to the datatable. This...
|
by: TheSteph |
last post by:
Using : MS-SQL 2005 / .NET 2.0 / VS2005
I have two server with the same database def but different data.
I would like to import data from Server2.TableA to Server1.TableA. If a row
doesn't...
|
by: Dave |
last post by:
I'm using the SqlBulkCopy object to bulk insert large DataTable's into
SQL Server. Its working well except tables with IDENTITY columns in
them.
When calling...
|
by: Amar |
last post by:
Hi,
I need to insert a large amount of records pretty frequently through
my application. The quickest way to achive this seems to be
SQLBulkcopy class. I have implemented the solution using the...
|
by: Sergey Zenyuk |
last post by:
In VB.net windows application I use following
code implementing SqlBulkCopy import:
Using connODBC As New OdbcConnection(ConnStrODBC)
connODBC.Open()
Dim dbcmd As New OdbcCommand(String....
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|