OdbcDataAdapter batch inserts

paul.d.mcswain

This has probably already been answered, but it didn't show up when I
did a search.

I need to be able to perform a batch insert using the ODBC ADO.NET
objects (OdbcCommand, OdbcDataAdapter, etc).

I know that there are ODBC method to perform this via the DLL, but
want to do this via ADO.NET. Is this possible?

If so, can you point me to an example?

Apr 19 '07 #1

Subscribe Reply

3412

Nicholas Paldino [.NET/C# MVP]

Paul,

It doesn't look like the OdbcDataAdapter class supports this out of the
box.

If anything, you are going to have to access the functions that do this
directly through the P/Invoke layer.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

<pa************@gmail.comwrote in message
news:11*********************@d57g2000hsg.googlegro ups.com...

This has probably already been answered, but it didn't show up when I
did a search.

I need to be able to perform a batch insert using the ODBC ADO.NET
objects (OdbcCommand, OdbcDataAdapter, etc).

I know that there are ODBC method to perform this via the DLL, but
want to do this via ADO.NET. Is this possible?

If so, can you point me to an example?

Apr 19 '07 #2

Similar topics

1108

Batch Multiple Database Inserts/Updates?

by: Steve - DND | last post by:

Is there a way to perform multiple inserts and updates to SQL Server with stored procedures and the Command object's named parameters all at once? The only way to do this that I'm gathering so far...

C# / C Sharp

1840

How do I read a row with the odbcdataadapter without using a web control?

by: jm | last post by:

I do not want to use the datagrid, datalist, etc. I want to retrieve simply the value from the query. I know the sql is returning data, because, if I use a grid, I can populate it. I have...

ASP.NET

1544

Handling large batch looping database update process from ASP.NET page?

by: ML | last post by:

We have a large batch type update process that the user needs to launch from a button on an ASP.NET webpage. The process basically does some queries against SQL Server, loops through the result...

ASP.NET

2328

Settings for autovacuum for batch uploading of data?

by: Carlos | last post by:

Hello Forum, I would appreciate it if you could recommend settings to use auto-vacuum in my version 7.4 database. I am uploading several thousands records in the database at a rate of ~1 second...

PostgreSQL Database

5093

Batch commands & Ms-Access

by: Selva Chinnasamy | last post by:

Hi I am using batch commands against Ms-Access and getting an error Message "Characters found after end of SQL statement." String Here is my sql Dim str_screens As String = "Select * from Screens...

Visual Basic .NET

3744

consecutive ids in a batch insert?

by: varac | last post by:

Hi list, I am new to mysql and would appreciate any advice that you have to offer. I am attempting to batch insert 100 rows into a table, and I need to know the 100 id's of all the inserted...

MySQL Database

2355

JDBC batch inserts seem very slow.

by: Private Pyle | last post by:

We are prototyping an application that is inserting 500 rows into a table. One method is to using batching and make one database call to insert all 500 rows, the other method is to make 500...

DB2 Database

5598

OdbcDataAdapter Insert Command

by: monteiro | last post by:

Hi, I am using OdbcDataAdapter to insert data to postgreeSQL.. Everything’s seems to be fine, but nothing is inserting in the database. Andy Idea?? Thanks in advance string selectCommand =...

PostgreSQL Database

3553

Any suggestion on how to speed up large batch inserts?

by: Amber | last post by:

We are using 8.2.9 Windows 64 edtion, in one of our projects we need to recreate a few lager tables which have many millions of rows each, we have used concurrent Java threads to read from data...

DB2 Database

7121

What is ONU?

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,...

General

7162

Problem With Comparison Operator <=> in G++

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,...

C / C++

6881

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

7375

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

4899

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

Microsoft Access / VBA

4584

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

3088

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

650

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

287

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General