using System;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

using System.Windows.Forms;

public class Program

{

    public static void Main()

    {

        using (SqlConnection connection = new SqlConnection("Server=serv; Database=data; Uid=user; Pwd=pass"))

        {

            //Important point, you don't have to worry about opening or closing the connection because

            //SqlDataAdapter does this for you automatically

            DataSet dataSetCustomers = new DataSet();

            //Access the data, but you can't modify it

            SqlDataAdapter dataAdapterCustomers = new SqlDataAdapter("SELECT * FROM Customers", connection);

            //2 options available to modify data SqlCommandBuilder & SqlAdapter Properties

            //#1 Insert data into commandBuilder

            //TElls it what SqlDAtaAdapter to ADD commands to

            SqlCommandBuilder cmdBldr = new SqlCommandBuilder(dataAdapterCustomers);

            //Fill DataSet

            dataAdapterCustomers.Fill(dataSetCustomers, "Customers");

            //Update the dataAdapter once you're done working with the DataSet

            dataAdapterCustomers.Update(dataSetCustomers, "Customers");

            //You can actually bind this data to a WINDOWS Forms and ASP.NET DataGrid

            DataGrid myDataGrid = new DataGrid();

            //Set the Datasource and DataMember (table)

            myDataGrid.DataSource = dataAdapterCustomers;

            myDataGrid.DataMember = "Customers";

​

        }           

    }

}