SqlDataReader Example – C# – SqlDataReader Example
| .NET | .NET Programming (C# or VB) (Web or Desktop) | |||
| Key Supporting Languages | HTML | CSS | JavaScript | SQL Server |
| AJAX | ASP | Blogging | ColdFusion | mySQL |
| Perl | PHP | Ruby | Web Design | Web Dev |
SqlDataReader Example – C# – SqlDataReader Example
Purpose: – Illustrates using C# SqlDataReader to read sql table.
Prerequistes:
- Install C# (Express or Standard Edition)
- Install SQL Server Express
- Download Northwind Database
- Attach Northwind Database to Databases in Sql Express
Notes:
- Console Application is used to simplify things, but Windows Forms or Web Forms could also be used
- You can build a library of syntax examples by using same project over and over and just commenting out what you do not want to execute in Program.cs
Instructions:
- Use C# 2008 (Express or Standard) Edition
- Create new project; select Console Application; name of Project could be CSharp_Syntax.
- Right-click project name in solution explorer; add new folder; name of folder could be DatabaseADONET
- Right-click folder; add class; class name could be clsSqlDataReader.cs
- Copy code into clsSqlDataReader.cs
- Copy code into Program.cs
- Click green arrow to start with debugging
Step 1: Use View Plain to Cut-n-paste code into clsSqlDataReader.cs
using System;
using System.Data;
using System.Data.SqlClient;
public class clsSqlDataReader
{
static SqlConnection con;
public void Main()
{
con = new SqlConnection("Server=(local)\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT FirstName, LastName FROM Employees";
cmd.Connection = con;
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
//(CommandBehavior.SingleRow)
while (reader.Read())
{
Console.WriteLine("{0} - {1}", reader.GetString(0), reader.GetString(1));
}
reader.Close();
}
finally
{
con.Close();
}
Console.ReadLine();
}
}
Step 2: Use View Plain to Cut-n-paste code into Program.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace CSharp_Syntax
{
class Program
{
static void Main(string[] args)
{
//DatabaseADONET
clsSqlDataReader mySqlDataReader = new clsSqlDataReader();
mySqlDataReader.Main();
}
}
}
Related posts:
- SqlDataReader Example – VB.NET – SqlDataReader Example Source code example in VB.NET of SqlDataReader ...
- C# DataTable SqlDataReader Example – SqlDataReader Datatable Example C# C# DataTable SqlDataReader Example - SqlDataReader Datatable Example C#...
- VB.NET DataTable SqlDataReader Example – SqlDataReader DataTable Example VB.NET VB.NET DataTable SqlDataReader Example - SqlDataReader DataTable Example VB.NET...
- C#: Sql Stored Procedure Source Code Example C# Sql Stored Procedure source code example with SqlDataReader...
- C# ASP.NET Table SqlDataReader Example – SqlDataReader Table Example C# ASP.NET C# ASP.NET Table SqlDataReader Example - SqlDataReader Table Example C#...
Related posts brought to you by Yet Another Related Posts Plugin.

First of all. Thanks very much for your useful post.
I just came across your blog and wanted to drop you a note telling you how impressed I was with the
information you have posted here.
Please let me introduce you some info related to this post and I hope that it is useful for community.
There is a good C# resource site, Have alook
http://CSharpTalk.com
Thanks again
Rahul