ADO.NET Command Classes - ExecuteNonQuery Method

Posted by Ahmet Altun on Stack Overflow See other posts from Stack Overflow or by Ahmet Altun
Published on 2010-03-26T13:28:20Z Indexed on 2010/03/26 13:33 UTC
Read the original article Hit count: 378

Filed under:

sqlcommand

|

oledbcommand

I've heard that Microsoft accepts that the name of ExecuteNonQuery method of command classes was given inappropriate. Is there any official information about it, or it is just a rumour?

© Stack Overflow or respective owner

Related posts about sqlcommand

SqlCommand() ExecuteNonQuery() truncates command text.

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm building a custom db deployment utility, I need to read text files containing sql scripts and execute them against the database. Pretty easy stuff, so far so good. However I've encountered a snag, the contents of the file are read successfully and entirely, but once passed into the SqlCommand… >>> More
Comparing LINQ to SQL vs the classic SqlCommand

as seen on Dot net Slackers - Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision… >>> More
Comparing LINQ to SQL vs the classic SqlCommand

as seen on Dot net Slackers - Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision… >>> More
Data caching in ASP.Net applications

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
In this post I will continue my series of posts on caching. You can read my other post in Output caching here .You can read on how to cache a page depending on the user's browser language. Output caching has its place as a caching mechanism. But right now I will focus on data caching .The advantages… >>> More
SqlCommand - preventing stored proc call in other databases

as seen on Stack Overflow - Search for 'Stack Overflow'
When using SqlCommand to call a stored proc via RPC, it looks like it is possible to call a stored proc in a database other than the current database. e.g. : string storedProcName = "SomeOtherDatabase.dbo.SomeStoredProc"; SqlCommand cmd = new SqlCommand(storedProcName); cmd.CommandType = CommandType… >>> More

Related posts about oledbcommand

VB.Net: exception on ExecuteReader() using OleDbCommand and Access

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi again all, im getting the error below for this SQL statement in VB.Net 'Fill in the datagrid with the info needed from the accdb file 'to make it simple to access the db connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data " connstring += "Source=" & Application.StartupPath &… >>> More
Exception on ExecuteReader() using OleDbCommand and Access

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi again all, I'm getting the error below for this SQL statement in VB.Net 'Fill in the datagrid with the info needed from the accdb file 'to make it simple to access the db connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data " connstring += "Source=" & Application.StartupPath… >>> More
Reading from excel using oledbcommand

as seen on Stack Overflow - Search for 'Stack Overflow'
In the below code instead of specifying the tab name.. Is there anyway we can just say "select * from [tab1]"? what ever the tab name might be.. OleDbCommand excelOledbCommand = new OleDbCommand("Select * From [Sheet1$]", excelOledbCon); >>> More
Does the Microsoft SQL Server native client support IDBAsynchNotify?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working on some OLE DB code that runs queries on MS SQL Server via ICommand::Execute. I'm converting this code to operate asynchronously by setting the DBPROPVAL_ASYNCH_INITIALIZE property on the command before executing. I'd prefer to register a IDBAsynchNotify sink so that my code can be notified… >>> More
ADO.NET Command Classes - ExecuteNonQuery Method

as seen on Stack Overflow - Search for 'Stack Overflow'
I've heard that Microsoft accepts that the name of ExecuteNonQuery method of command classes was given inappropriate. Is there any official information about it, or it is just a rumour? >>> More