Execute two sql commands : SqlCommand « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. SqlCommand

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";

            using (SqlCommand com = con.CreateCommand())
            {
                com.CommandType = CommandType.Text;
                com.CommandText = "SELECT BirthDate,FirstName,LastName FROM "+
                    "Employees ORDER BY BirthDate;SELECT * FROM Employees";

                con.Open();

                using (SqlDataReader reader = com.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        Console.WriteLine("  {0,18:D} - {1} {2}",
                            reader.GetDateTime(0),  // Retrieve typed data
                            reader["FirstName"],    // Use string index
                            reader[2]);             // Use ordinal index
                    }
                    Console.WriteLine(Environment.NewLine);
                    reader.NextResult();
                    Console.WriteLine("Employee Table Metadata.");
                    for (int field = 0; field < reader.FieldCount; field++)
                    {
                        Console.WriteLine("  Column Name:{0}  Type:{1}",
                            reader.GetName(field),
                            reader.GetDataTypeName(field));
                    }
                }
            }
        }
    }
}