using System.Data;
using System.Data.SqlClient;
class Program {
   static void Main() {
      string sCnx =
         "server = localhost ; uid=sa ; pwd =; database = ORGANIZATION";
      using( SqlConnection cnx = new SqlConnection(sCnx) ) {
         using( SqlDataAdapter dataAdapter = new SqlDataAdapter() ) {
            DataSet dataSet = new DataSet();

            // Build automatically commands for updates.
            string sCmd ="SELECT * FROM EMPLOYEES WHERE EmployeeID=-1";
            dataAdapter.SelectCommand = new SqlCommand( sCmd, cnx );
            SqlCommandBuilder cmdBuilder = 
               new SqlCommandBuilder( dataAdapter );
            // Build the 'EMPLOYEES' table and insert lines from
            // the 'DataFile.xml' file.
            dataSet.ReadXml(@"C:/DataFile.xml");

            // Update the database.
            dataAdapter.Update(dataSet, "EMPLOYEES");
         } // end using SqlDataAdapter
      } // end using SqlConnection
   }
}