Progress Monitor for IdealProgrammer.com

Take Swift, Intelligent, Massive, Planned, Loving, Effective (S.I.M.P.L.E.) Action to Transform Self into Ideal

Skip Repetitive Navigational Links

Home

News

Presenters

Contact

Please login

SqlDataReader Example

Description: Illustrates using C# SqlDataReader to read sql table.

Example Class Main:

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();
    }
}

Example Class Program:

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();
        }
    }
}