Dynamic insert/update (ala EXEC SQL DESCRIBE)

[Tim Nelson]

I am coming from a ESQL/C environment and I have the need to create
an application that builds an insert and an update statement dynamically
by querying a the schema for a database table.

With .Net it seems there are too many tools to work with. Basically, the
application takes 3 parameters:

1. A database connection string
2. A table name
3. An import file of pipe-delimited records

What I need to do is get a description of the table (and it's primary index)
and then dynamically create the insert and update. Consider:

create table foo (foo1 integer,foo2 varchar(20),pri mary key foo1)

I want to dynamically create:

insert into foo (foo1,foo2) values ( ?, ?)

and

update foo set foo2 = ? where foo1 = ?

Which System.Data classes should I be looking at to do this with the least
amount
of headache?
Thanks. Tim

[Herfried K. Wagner [MVP]]

Hello,

"Tim Nelson" <ti************ ***@softhome.ne t> schrieb:

I am coming from a ESQL/C environment and I have the
need to create an application that builds an insert and an
update statement dynamically by querying a the schema
for a database table.

Notice that you will have a better chance to get an answer if you post this
question to the ADO.NET newsgroup:

news://msnews.microsoft.com/microsof...amework.adonet

Web interface:

http://msdn.microsoft.com/newsgroups...amework.adonet

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
http://www.mvps.org/dotnet