Top "Sqldatareader" questions

Provides a way of reading a forward-only stream of rows from a SQL Server database.

Reading SP with output parameters and result set in C#?

I have created a stored procedure similar to this simplified example: CREATE PROCEDURE dbo.sp_MyStoredProcedure @Var1 INT OUTPUT, @Var2 …

c# sql-server-2005 stored-procedures sqldatareader output-parameter
System.IndexOutOfRangeException on SQLDataReader Value Using C#

I have a SQLDataReader that returns three integers. However, there are occasions when two of the integers will return null …

c# asp.net sqldatareader dbnull
Is closing/disposing an SqlDataReader needed if you are already closing the SqlConnection?

I noticed This question, but my question is a bit more specific. Is there any advantage to using using (SqlConnection …

c# sql dispose sqldatareader sqlconnection
What does the buffered parameter do in Dapper dot net?

Dapper dot net has a buffer parameter (a bool), but as far as I can tell the only thing it …

.net sqldatareader dapper
Generic method to read data from DataReader

I am currently using this method to read data from DataReader - private T GetValue<T>(object obj) { …

c# sqldatareader
Cast error on SQLDataReader

My site is using enterprise library v 5.0. Mainly the DAAB. Some functions such as executescalar, executedataset are working as expected. …

enterprise-library sqldatareader daab .net