Top "Datareader" questions

Extract from DataRow or DataReader with one function

I'm looking for a solution for how to be able to extract data from a database when using either a …

c# .net sql datareader datarow

Can a binary search be done in a database in SQL?

OK. I am using the C# programming language to access a simple database (on Microsoft SQL Server) Currently, I am …

c# database search datareader

How to handle multiple ResultSets, each with multiple Rows? IDataReader.NextResult() ending Read()

How to handle multiple ResultSets, each with multiple Rows? The call to NextResult() breaks the while loop. Some of my …

c# stored-procedures datareader

.NET DataTable skips rows on Load(DataReader)

I'm trying to populate a DataTable, to build a LocalReport, using the following: MySqlCommand cmd = new MySqlCommand(); cmd.Connection = new …

.net datatable datareader localreport

DataReader.GetString() via columnname

Dictionary Fields = new Dictionary(); for (int i = 0; i < reader.FieldCount; i++) { Fields.Add(reader.GetName(i), i); } this._MyField1 = …

sql datareader

VB.NET - Multiple Result Sets in one query?

I have a stored procedure: CREATE PROCEDURE [TestProc] AS BEGIN select '1a', '1b' select '2a', '2b', …

sql vb.net datareader

WinRT No mapping for the Unicode character exists in the target multi-byte code page

I am trying to read a file in my Windows 8 Store App. Here is a fragment of code I use …

file-io windows-8 windows-runtime datareader

Using ASP.NET MVC without an ORM

In my ASP MVC application I'm using standard SQL (rather that Linq to SQL or other ORM) to query my …

asp.net-mvc data-binding datatable datareader

IDataReader - Any way to get the total rows?

Is there any way to get the total number of rows returned from a SQL query (from the IDataReader) before …

c# count rows datareader

C# How can I get each column type and length and then use the lenght to padright to get the spaces at the end of each field

I have a console application that extracts data from a SQL table to a flat file. How can I get …

c# ado.net metadata datareader