Top "Sqldatareader" questions

Timeout exception causes SqlDataReader to close?

I'm trying to pull some binary data from a database and write them to pdf files. For the most part, …

c# sql sqldatareader

Check if it's the last record in sqldatareader

Is there a way to check if I'm on the last record ? thanks

c# sql sqldatareader

Make DbDataReader start reading again from the beginning of the result set

How to make dr.Read(); start reading again from the beginning if a condition is satisfied? Something like: SqlDataReader dr = …

c# sql database winforms sqldatareader

Parsing a decimal from a DataReader

I found a workaround for this error, but am now really curious as to why this would be happening, was …

c# parsing decimal sqldatareader

Reuse of SqlConnection and SqlDataReader

If I want to run multiple SELECT queries on different tables, can I use the same SqlDataReader and SqlConnection for …

c# .net sqldatareader

SqlDataReader inside SqlDataReader

How can I implement a SqlDataReader inside another SqlDataReader? My problem is I have a SqlDataReader. I am issuing while (…

c# sql-server sqldatareader

How to safely cast nullable result from sqlreader to int?

I have a table which contains null values and I need to get data from the table using SqlDataReader. I …

c# asp.net null sqldatareader dbnull

asp.net sql datareader loop by columns

I have sql query in my asp.net webapp and the result is stored in datareader. Every row in datareader …

c# asp.net sqldatareader

What 'length' parameter should I pass to SqlDataReader.GetBytes()

I have a SqlDataReader and need to read a varbinary(max) column from it using the SqlDataReader.GetBytes() method. This …

c# .net vb.net ado.net sqldatareader

Slow performance of SqlDataReader

I've query executing ~2 secs in MSSMS (returning 25K of rows) Same query used in .NET (sqlReader) exetuting few minutes! I've …

.net sql-server sql-server-2005 sqldatareader