By tag: DataReader
0
kicks
.NET code to convert a SQL query to CSV format for output to file, etc
Free VB.NET code to convert a SQL query to CSV format for easy output to a file, the console, or via a HttpResponse (for you ASP.NETers out there looking for an easy way to dynamically output a CSV for real-time data download)
0
kicks
Nullable Data Readers
FTA: .NET 2.0 introduced nullable types into the CLR which, for the first time, provided the ability for value types to be assigned a null value. However, ADO.NET 2.0 did not introduce any new features specifically for dealing with nullable types. Therefore, one of the primary goals for the classes ...
0
kicks
Common Pattern For Working With DataReader
A description of a common pattern for working with DataReader object which as described here:
http://vaultofthoughts.net/WhatYouShouldDisposeWhenUsingADONET.aspx
Is IDisposable and should be disposed!
0
kicks
DataGrid Paging and Sorting Using A DataReader
This article will demonstrate two ways one could implement the DataReader to bind a DataGrid, that includes caching, paging and persistent bi-directional sorting, all without the use of a DataAdapter/DataSet at all!
0
kicks
Accessing and Updating Data in ASP.NET 2.0: Data Source Control Basics
This is a nice article on the declarative use of the data source controls to access your data in .NET. I prefer getting my hands dirty with a SqlConnection and SqlDataReader but find these control useful for rapid prototyping.