simpledatasetsql.cs

Professional C# 2nd Edition

using System;
using System.Data;
using System.Data.SqlClient;

public class SimpleDataSetSQL
{
	public static void Main(string[] args)
	{
		string         source = Login.Connection ;
		string         select = "SELECT ContactName,CompanyName FROM Customers" ;

		using ( SqlConnection  conn = new SqlConnection ( source ) )
		{
			SqlDataAdapter da = new SqlDataAdapter ( select , conn ) ;

			DataSet        ds = new DataSet ( ) ;
		    
			da.Fill ( ds , "Customers" ) ;

			foreach ( DataRow row in ds.Tables["Customers"].Rows )
				Console.WriteLine ( "'{0}' from {1}" , 
					row[0] ,
					row[1] ) ;

			conn.Close ( ) ;
		}
	}
}