I know this is not a hell of an useful question but I can't help being bugged by it. So, Why said method (in *Command classes) is called ExecuteNonQuery instead of ExecuteQuery? Aren't those SQL statements we throw at DBs, queries? ...
Hello, I have problems inserting a null paramater with the AddInParameter method. cmd.AddInParameter(someString, someValueWhichCanBeNULL) As soon as the 2nd param is null, it fails. I also Tried DBNull.Value, fails too. Ideas? The message is: AddInParameter @MyParam with null value or Unsupported Property Type: DBNull Thanks! ...
The ASP.NET web application I am developing needs to support two different types of databases, namely Access and MS SQL Server 2008 Express. I already have connection strings for each database type stored in web.config, and I have another web.config value that specifies which one to use. So I can get the proper connection string with no...