using System;
using System.Data;
using System.Data.SqlClient;
class MainClass
{
public static void Main()
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = @"Data Source = .\sqlexpress;" +
"Database = Northwind; Integrated Security=SSPI";
con.Open();
// Create and configure a new command.
IDbCommand com = con.CreateCommand();
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "MyStoredProcedure";
// Execute the command and process the results
using (IDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine(" {0} ", reader["FirstName"]);
}
}
}
}
}
|