//Specify SQL Server-specific connection string
            SqlConnection thisConnection = new SqlConnection(@"server=.;Integrated Security=True;database=northwind");

            //Create DataAdapter object for update and other operations
            SqlDataAdapter thisAdapter = new SqlDataAdapter("select CustomerID,CompanyName from AMyCustomers", thisConnection);

            //Create CommandBuilder object to build SQL commands
            SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
            //Create DataSet to contain related data tables,rows,and columns
            DataSet thisDataSet = new DataSet();

            //Fill DataSet using query defined previously for DataAdapter
            thisAdapter.Fill(thisDataSet, "Customers");

            //Show data before change
            Console.WriteLine("name before change:{0}", thisDataSet.Tables["Customers"].Rows[9]["CompanyName"]);

            //Change data in Customers table,row 9,CompanyName column
            thisDataSet.Tables["Customers"].Rows[9]["CompanyName"] = "Acme,Inc.";

            //Call update command to mark change in table
            thisAdapter.Update(thisDataSet, "Customers");
            Console.WriteLine("name after change:{0}", thisDataSet.Tables["Customers"].Rows[9]["CompanyName"]);

            thisConnection.Close();