string cnStr = @"server=.;database=northwind;integrated security=true;";
using (SqlConnection cn = new SqlConnection(cnStr))
{
    string sql = "SELECT o.OrderID, o.CustomerID, o.OrderDate, " +
                 "od.ProductID, p.ProductName, od.UnitPrice, " +
                 "od.Quantity FROM Orders o " +
                 "INNER JOIN [Order Details] od " +
                 "ON o.OrderID = od.OrderID INNER JOIN Products p ON " +
                 " p.ProductID = od.ProductID ";
    SqlCommand cmd = new SqlCommand(sql, cn);
    SqlDataAdapter adpt = new SqlDataAdapter(cmd);
    DataTable dtCustomers = new DataTable("Customers");
    adpt.Fill(dtCustomers);

    BinaryFormatter bin = new BinaryFormatter();
    using (StreamWriter sw = new StreamWriter(@"c:\customers.bin"))
    {
        dtCustomers.RemotingFormat = SerializationFormat.Binary;
        bin.Serialize(sw.BaseStream, dtCustomers);
    }
}

string cnStr = @"server=.;database=northwind;integrated security=true;";
for (int power = 0; power <= 5; power++)
{
    using (SqlConnection cn = new SqlConnection(cnStr))
    {
        double top = (Math.Pow(10, power));
        string sql = "SELECT TOP " + top +
                     " OrderID, CustomerID, OrderDate, " +
                     "ProductID, ProductName, UnitPrice, Quantity" +
                     "FROM MyOrders ";
        SqlCommand cmd = new SqlCommand(sql, cn);
        SqlDataAdapter adpt = new SqlDataAdapter(cmd);
        DataTable dtMyOrders = new DataTable("MyOrders");
        adpt.Fill(dtMyOrders);

        BinaryFormatter bin = new BinaryFormatter();
        using (StreamWriter sw = new StreamWriter(
            @"c:\myorders" + top + ".bin"))
        {
            dtMyOrders.RemotingFormat = SerializationFormat.Binary;
            bin.Serialize(sw.BaseStream, dtMyOrders);
        }
        using (StreamWriter sw = new StreamWriter(
            @"c:\myorders" + top + ".xml"))
        {
            dtMyOrders.RemotingFormat = SerializationFormat.Xml;
            bin.Serialize(sw.BaseStream, dtMyOrders);
        }
    }
}

string cnStr = @"server=.;database=northwind;integrated security=true;";
string sql = "SELECT CustomerID, CompanyName, City, Region, Country " +
             "FROM Customers ORDER BY CustomerID";

DataTable dtCust = new DataTable();
using(SqlConnection cn = new SqlConnection(cnStr))
{
    SqlCommand cmd = new SqlCommand(sql, cn);
    SqlDataAdapter adpt = new SqlDataAdapter(cmd);
    adpt.Fill(dtCust);
}

DataView view = new DataView(dtCust);
view.RowFilter = "Country='USA'";
view.Sort = "City";
DataTable dtCities = view.ToTable("CustomerCities", 
        true, "City", "Country");

string cnStr = @"server=.;database=northwind;integrated security=true;";
string sql = "SELECT CustomerID, CompanyName, City, Region, Country " +
             "FROM Customers ORDER BY CustomerID";
using (SqlConnection cn = new SqlConnection(cnStr))
{
    SqlCommand selCmd = new SqlCommand(sql, cn);
    SqlDataAdapter adpt = new SqlDataAdapter(selCmd);
    DataTable dtCustomers = new DataTable("Customers");
    adpt.Fill(dtCustomers);
    dtCustomers.PrimaryKey = 
        new DataColumn[] { dtCustomers.Columns["CustomerID"] };

    // Add a customer row
    DataRow newRow = dtCustomers.NewRow();
    newRow["CustomerID"] = "FOO";
    newRow["CompanyName"] = "The Foo Company";
    newRow["City"] = "Fooville";
    dtCustomers.Rows.Add(newRow);

    // Change a customer row
    DataRow row = dtCustomers.Rows.Find("ALFKI");
    row["City"] = "Here"; /// was Berlin

    // Set up the Insert Command
    string insSql = "INSERT Customers (CustomerID, CompanyName, City) " +
                    "VALUES (@CustomerID, @CompanyName, @City)";
    SqlCommand insCmd = new SqlCommand(insSql, cn);
    insCmd.UpdatedRowSource = UpdateRowSource.None;
    insCmd.Parameters.Add("@CustomerID", SqlDbType.NChar, 
        10, "CustomerID");
    insCmd.Parameters.Add("@CompanyName", SqlDbType.NChar, 
        80, "CompanyName");
    insCmd.Parameters.Add("@City", SqlDbType.NChar, 30, "City");
    adpt.InsertCommand = insCmd;

    // Set up the Update Command
    string updSql = "UPDATE Customers SET CompanyName = @CompanyName, " +
                    "City = @City WHERE CustomerID = @CustomerID";
    SqlCommand updCmd = new SqlCommand(updSql, cn);
    updCmd.UpdatedRowSource = UpdateRowSource.None;
    updCmd.Parameters.Add("@CompanyName", SqlDbType.NChar, 
        80, "CompanyName");
    updCmd.Parameters.Add("@City", SqlDbType.NChar, 30, "City");
    updCmd.Parameters.Add("@CustomerID", SqlDbType.NChar, 
        10, "CustomerID");
    adpt.UpdateCommand = updCmd;

    // Set the Batch Size. 0 means all; default is 1.
    adpt.UpdateBatchSize = 10;

    // Send the new rows and the changed rows to the database
    adpt.Update(dtCustomers.GetChanges());
}