473,781 Members | 2,413 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Batch Update ADO.Net

Using SQL Server 2000, and VS.Net 2003

I want to load a datatable from a local server into a dataset and update it
into a linked server. The linked server will have the exact same structured
table, and it will be empty. Can I open a blank dataset from the linked
server, and fill it with the dataset from the local server? I have been
trying every which way to get this working. Is it possible? It is too slow
doing a transact sql statement that does the insert from the local to the
linked, so I am trying this method. Any thoughts?

Derek
May 20 '06 #1
2 1856
.... A more "SQL" approach

EXEC sp_addlinkedser ver 'your server'
EXEC sp_addlinkedsrv login 'your server', 'false', 'luser', 'rmtuser',
'rmtPassword'
SELECT * INTO YOUR_TABLE FROM YOUR_SERVER.DAT ABASE.dbo.TABLE

or

INSERT INTO YOUR_TABLE (COLUMNS) SELECT COLUMNS FROM
YOUR_SERVER.DAT ABASE.dbo.TABLE
Regards,
Tasos

May 20 '06 #2
Forgot to mention that you should

EXEC sp_dropserver 'your server', 'droplogins'

after finishing.

Tasos

May 20 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1965
by: Rick | last post by:
Does anyone have any resources on how to conduct a batch update for a checkboxlist web control? ie. After the user checks/unchecks items from the checkbox list, conduct a postback (via a button or some other form) and create a batch update of the records? Thanks in advance.
2
6562
by: Paul Reddin | last post by:
Hi, (V8.1 Fp2) Our application uses JDBC batch to execute mutiple insert statements and we saw a strange thing this morning. There were 4 SQL Insert statements in the batch, and we know the 2nd would have violated a Unique Constraint and failed, but the SQL error returned was related to the 3rd statement (which had a FK dependent on the 2nd
0
1930
by: jayson_13 | last post by:
Hi, I would like to execute a batch update (mysql) with C#. How do I do that? For example, OdbcCommand cmd = New OdbcCommand(); Cmd.Connection = Conn;
6
11238
by: Charles Neitzel | last post by:
I'm trying to write a windows application in C# (Using Microsoft Visual C# 2005 Express) that is nothing more than a simple UI with buttons on it. The buttons do various things like running programs and executing registry entries. The majority of my buttons work however, I have come upon a problem. I need a few of the buttons to run DOS batch files, the batch files in turn run program installers (specifically windows update runtime .exe...
1
3204
by: Charles | last post by:
I'm trying to write a windows application in C# (Using Microsoft Visual C# 2005 Express) that is nothing more than a simple UI with buttons on it. The buttons do various things like running programs and executing registry entries. The majority of my buttons work however, I have come upon a problem. I need a few of the buttons to run DOS batch files, the batch files in turn run program installers (specifically windows update runtime .exe...
0
1197
by: Steve | last post by:
ASP.net 2.0 SQL 2005 I need to insert/delete multiple records from a database. Error checking and exceptions are not a problem, the data being added/deleted are simple integer IDs. The number of records being affected would typically be in the 1 to 50 range.
1
5496
by: cedgell | last post by:
Is it possible to create a batch file of a sql script that would allow end user to update a single field of a table? For example, a number field is populated but needs to be updated on a daily basis by end user. Say the current value is 10002345 and needs to be updated to 12345678. Can a script be ran that would prompt the end user for the current value and a 'replace' or 'update' value? Would like to have this in a batch file to be placed...
1
3601
by: bravo | last post by:
hi using mysql 4.1 i wish to update records using batch update but for a batch of 100, records and table having only 5000 records execution time is approx 2.4 sec i want to know whether this time is fine or i can further reduce it with some performance tunning ... the table which i am using is having 19 columns the update is on a single column .... one more thing when i use the batch update for deletion batch size 100 along with update...
2
1268
by: rbrowning1958 | last post by:
Hello, Doing my first ASP project so this may be simple and I'm missing something...could someone please calrify this for me? 1. I have an ASP page with a grich which allows user to add, edit and delete records. 2. The grid is linked to an objectdatasource which points to a business class
1
2074
by: SagarDoke | last post by:
Is it possible to use batch update on store procedure with register out parameter? If not then is there any way to get register out parameter values with batch update?
0
9474
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10076
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9939
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8964
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6729
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5507
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4040
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3633
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2870
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.