I\'m trying to get a DataTable or DataSet from an IDataReader, but I\'m failing. Here\'s the code: string sql = @\"SELECT ID, DOCNUMBER FROM TBDOCUMENT\";
I want to update a dataset in a DB2/AS400 table. The problem is if I there is string parameter in the parameters list the command does not find a row to update.
I\'m just curious if the IDbCommand.CommandType\'s value makes a difference in terms of performance? Ba开发者_如何转开发sically, I could do either set it as CommandType.Text and pass in a SQL query \
I am running Server Application on Windows Server 2008 with SQL Server 2008, Now My scenario is as Given.