Provides a way of reading a forward-only stream of rows from a SQL Server database.
Is there an easy way to convert all the columns of the current row of a SqlDataReader to a dictionary? …
c# sql-server linq sqldatareaderSo we have had a heated debate at work as to which DataAccess route to take: DataTable or DataReader. DISCLAIMER …
.net data-access-layer sqldatareaderI have the follwoing code that performs a query and returns a result. However, I looked around and found some …
asp.net vb.net sqldatareader dbnullWhat's the difference between reading a value from an SqlDataReader using this syntax: Dim reader As SqlClient.SqlDataReader reader("value").…
sqldatareaderI know I asked a related question earlier. I just had another thought. using (SqlConnection conn = new SqlConnection('blah blah')) { …
c# dispose sqldatareader using-statementI am using SQL Server 2008 in a asp.net/c# program. I am trying to use SqlDataReader to fetch the …
c# sql-server-2008 stored-procedures sqldatareaderHow can I add values that a SqlDataReader returns to a generic List? I have a method where I use …
c# sql sqldatareaderMy SQL Server database contains nullable DateTime values. How can I convert them to a nullable DateTime object in my …
c# sql-server datetime nullable sqldatareaderI have the following code in some methods of my Data Layer: StringBuilder sb = new StringBuilder(); SqlCommand s = new SqlCommand(…
c# .net-1.1 sqldatareader sqlcommandWhy does SqlDataReader throw an exception when converting 0 to integer? ?dataReader(3) 0 {Short} Short: 0 ?dataReader.GetInt16(3) 0 ?dataReader.GetInt32(3) {"Specified cast is …
.net sqldatareader datareader