Top "Sqldatareader" questions

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

How do I fill a DataTable using DataReader

I want to fill DataTable using DataReader. I have created object like this SqlDataReader dr = cmd.ExecuteReader(); if(dr.HasRows) { }

asp.net ado.net sqldatareader
Is there anything faster than SqlDataReader in .NET?

I need to load one column of strings from table on SqlServer into Array in memory using C#. Is there …

c# sql sql-server ado.net sqldatareader
How to get a bit value with SqlDataReader and convert it to bool?

I am retrieving user information from a database using a simple query. select * from dbo.[User] u where u.Email = @…

c# boolean bit sqldatareader
Read boolean values from DB?

In C#, using SqlDataReader, is there a way to read a boolean value from the DB? while (reader.Read()) { destPath = …

c# .net sqldatareader
Cannot convert method group 'Read' to non-delegate type 'bool'

I am trying to use SqlDataReader to check if a entry exists. If it exists, it will return the ID, …

c# sql sqldatareader
Filling a DataGridView from SQLReader

Im a little stuck on some code that im writing An outline is that i am reading some data in …

datagridview vb.net-2010 sqldatareader
SqlDataReader Best way to check for null values -sqlDataReader.IsDBNull vs DBNull.Value

I want to retrieve decimal values from the database and I would like to know which is the recommended way …

c# ado.net sqldatareader dbnull
Access a specific row in DataReader

I have a datareader to display a list of gameweeks in a js carousel. I need to be able to …

c# asp.net sqldatareader datareader
Enforce only single row returned from DataReader

I seem to write this quite a lot in my code: using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { result = …

c# .net ado.net sqldatareader datareader
Best method for Populating DataSet from a SQLDataReader

I am working on a DAL that is getting a DataReader Asynchronously. I would like to write a single method …

sql dataset sqldatareader