SqlDataReader Example – C# – SqlDataReader Example

Putting the Pieces of .NET Together - 8 Part Video Series By Wade Harvey
Introduction
Videos 1-4	1. Servers (3 minutes)	2. .NET Framework (10 minutes)	3. Security (8 minutes)	4. Monitoring Tools (10 minutes)
Videos 5-8	5. Web Servers (6 minutes)	6. SQL Server (6 minutes)	7. Software Develop Tools (10 minutes)	8. Languages (2 minutes)
Download PDF	Putting the Pieces of .NET Together - 48-page PDF

SqlDataReader Example – C# – SqlDataReader Example

Purpose: – Illustrates using C# SqlDataReader to read sql table.
Prerequistes:

1. Install C# (Express or Standard Edition)
2. Install SQL Server Express
3. Download Northwind Database
4. 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:

1. Use C# 2008 (Express or Standard) Edition
2. Create new project; select Console Application; name of Project could be CSharp_Syntax.
3. Right-click project name in solution explorer; add new folder; name of folder could be DatabaseADONET
4. Right-click folder; add class; class name could be clsSqlDataReader.cs
5. Copy code into clsSqlDataReader.cs
6. Copy code into Program.cs
7. Click green arrow to start with debugging

Step 1: Use View Plain to Cut-n-paste code into clsSqlDataReader.cs

 C# | 
 copy code |
?
 
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

 C# | 
 copy code |
?
 
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:

1. SqlDataReader Example – VB.NET – SqlDataReader Example Source code example in VB.NET of SqlDataReader ...
2. C# DataTable SqlDataReader Example – SqlDataReader Datatable Example C# C# DataTable SqlDataReader Example - SqlDataReader Datatable Example C#...
3. VB.NET DataTable SqlDataReader Example – SqlDataReader DataTable Example VB.NET VB.NET DataTable SqlDataReader Example - SqlDataReader DataTable Example VB.NET...
4. C#: Sql Stored Procedure Source Code Example C# Sql Stored Procedure source code example with SqlDataReader...
5. 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.