Re: ExecuteNonQuery() - Bach SQL Statement execution?
From: Sahil Malik (contactmethrumyblog_at_nospam.com)
Date: 11/09/04
- Next message: Alex: "How to hide a column in DataGrid ( or DataView)???"
- Previous message: Sahil Malik: "Re: Executing a select statement multiple times?"
- In reply to: Nathan: "ExecuteNonQuery() - Bach SQL Statement execution?"
- Next in thread: Nathan: "Re: ExecuteNonQuery() - Bach SQL Statement execution?"
- Reply: Nathan: "Re: ExecuteNonQuery() - Bach SQL Statement execution?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 9 Nov 2004 17:14:03 -0500
> How do I know if my underlying driver supports this?
Depends on the ODBC driver. I say write up a quick test app and execute a
batched query.
> Is there something I can do to change any setting on the ODBC driver?
Again depends on the ODBC driver, but I haven't ever come across such a
setting, and logically it doesn't make any sense to not enable this by
default -- in other words, my hunch is, no such setting exists because it
doesn't seem to make sense.
- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
Please reply to the newsgroups instead of email so everyone can benefit from
your reply.
"Nathan" <Nathan@discussions.microsoft.com> wrote in message
news:8476A9BD-5D3E-49AA-A0F8-0F34FB78B4B2@microsoft.com...
> Hi,
> I am trying to use the ExecuteNonQuery() to execute multiple SQL update
> statements. Though the SQL is correct, it only executes the first update
> statement. When I looked through the documentation I found out this,
> "You can also use ExecuteNonQuery to execute multiple SQL statements if
the
> underlying ODBC driver supports this functionality."
> How do I know if my underlying driver supports this?
> Is there something I can do to change any setting on the ODBC driver?
> Thanks for any help.
>
- Next message: Alex: "How to hide a column in DataGrid ( or DataView)???"
- Previous message: Sahil Malik: "Re: Executing a select statement multiple times?"
- In reply to: Nathan: "ExecuteNonQuery() - Bach SQL Statement execution?"
- Next in thread: Nathan: "Re: ExecuteNonQuery() - Bach SQL Statement execution?"
- Reply: Nathan: "Re: ExecuteNonQuery() - Bach SQL Statement execution?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
