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: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
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...
|