using System;
using System.Data;
using System.Data.SqlClient;
class Program
{
static void Main(string[] args)
{
string sqlConnectString = "Data Source=(local);" +
"Integrated security=SSPI;Initial Catalog=AdventureWorks;";
string sqlSelect = @"SELECT ContactID, NameStyle, Title,
FirstName, MiddleName, LastName, Suffix, EmailAddress,
EmailPromotion, Phone, PasswordHash, PasswordSalt
FROM Person.Contact";
SqlConnection connection = new SqlConnection(sqlConnectString);
SqlCommand command = new SqlCommand(sqlSelect, connection);
connection.Open( );
SqlDataReader dr = command.ExecuteReader( );
dr.Read( );
int coPhone = dr.GetOrdinal("Phone");
Console.WriteLine("Phone = {0}", dr[coPhone]);
}
}
|