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

C# DataTable SqlDataReader Example

Description: Illustrates using DataTable loaded from SqlDataReader in C-Sharp.

Example Class Main:

using System;
using System.Data;
using System.Data.SqlClient;
 
 
public class clsDataTableSqlDataReader
{
    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 EmployeeID, FirstName + ' ' + LastName as FullName FROM Employees";
		cmd.Connection = con;
 
		DataTable Table1;
		Table1 = new DataTable("Employees");
		//creating a table named Employees
		DataRow Row1;
		//declaring row for the table
 
		DataColumn EmployeeID = new DataColumn("EmployeeID");
		//declaring a column named EmployeeID
		EmployeeID.DataType = System.Type.GetType("System.Int32");
		//setting the datatype for the column
		Table1.Columns.Add(EmployeeID);
		//adding the column to table
		DataColumn FullName = new DataColumn("FullName");
		FullName.DataType = System.Type.GetType("System.String");
		Table1.Columns.Add(FullName);
 
 
		try {
			con.Open();
			SqlDataReader reader = cmd.ExecuteReader();
			//(CommandBehavior.SingleRow)
			while (reader.Read()) {
				Row1 = Table1.NewRow();
				//declaring a new row
				Row1["EmployeeID"] = reader.GetInt32(0);
				//filling the row with values. Item property is used to set the field value.
				Row1["FullName"] = reader.GetString(1);
				//filling the row with values. adding FullName
				Table1.Rows.Add(Row1);
 
			}
			reader.Close();
		}
		finally {
			con.Close();
		}
 
		foreach  (DataRow row in  Table1.Rows) 
        {
			Console.WriteLine(row["EmployeeID"].ToString().PadRight(10) + row["FullName"].ToString());
 
		}
		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(DataTableSqlDataReader[] args)
        {
            //ADONET
 
 
            clsDataTableSqlDataReader myDataTableSqlDataReader = new clsDataTableSqlDataReader();
            myDataTableSqlDataReader.Main();
 
        }
    }
}