
{filelink=19655}
using System;
using System;
using System.Data;
using System.Data.SqlClient;
namespace Client.MesExemples.com
{
class UsingADataReader
{
static void Main(string[] args)
{
// Création de la chaîne de connexion
SqlConnection connection =
new SqlConnection(@"Data Source=(local);"
+ "Initial Catalog = Contacts;"
+ "Integrated Security=true");
// Ouvrir la connexion
connection.Open();
// Executer une commande SQL
SqlCommand MyCommand =
new SqlCommand("SELECT * FROM Clients", connection);
SqlDataReader MyDataReader =
MyCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (MyDataReader.Read())
{
Console.WriteLine(MyDataReader[0] + " "
+ MyDataReader[1]);
}
connection.Close();
}
}
}