using System;
using System.Data.SqlClient;
class pubsdemo
{
static void Main(string[] args)
{
String sConn = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
String sSQL = "select id, firstname, lastname from Employee";
SqlConnection oConn = new SqlConnection(sConn);
oConn.Open();
SqlCommand oCmd = new SqlCommand(sSQL, oConn);
SqlDataReader oReader = oCmd.ExecuteReader();
while(oReader.Read()) {
Console.WriteLine("{0} {1} {2}",
oReader["id"],
oReader["firstname"],
oReader["lastname"]);
}
}
}
|