Updating SqlCe Database from a DataSet

[Johnny]

I have a PocketPC mobile application that gets its data from the Sql Server
database via a web service. The web service returns a dataset that I need to
load into the SqlCe database on the mobile device. I have a method to
perform this task but it doesn't load the data into the SqlCe database. The
data is downloaded into the dataset from the web service just fine but I
can't get the data into the SqlCe database. Any suggestions would be
appreciated!!!

Here's the method (I've reformatted it to fit better in the small window):

private void Syncronization( )
{
SqlCeConnection conn = null;
conn = new SqlCeConnection ("Data Source = VMI.sdf");
SqlCeDataAdapte r daCustomers = new SqlCeDataAdapte r();
SqlCeDataAdapte r daShipTos = new SqlCeDataAdapte r();
SqlCeDataAdapte r daItems = new SqlCeDataAdapte r();

//instantiate SqlCe SELECT command
SqlCeCommand SqlCeCmdCustome rs = new SqlCeCommand("S ELECT * FROM vmi_cust
WHERE 1 = 2", conn);
SqlCeCommand SqlCeCmdShipTo = new SqlCeCommand("S ELECT * FROM vmi_ship
WHERE 1 = 2", conn);
SqlCeCommand SqlCeCmdItems = new SqlCeCommand("S ELECT * FROM
vmi_item_master WHERE 1 = 2", conn);
try
{
//Create an array and load all the ShipToID's into the array
string [][] arrayShipToID = new
string[dsVMI_Cust.Tabl es[0].Rows.Count][];

for(int x = 0; x < dsVMI_Cust.Tabl es[0].Rows.Count; x++)
{
arrayShipToID[x] = new string[] {
dsVMI_Cust.Tabl es[0].Rows[x]["ship2_id"].ToString(),
dsVMI_Cust.Tabl es[0].Rows[x]["is_existing_cu stomer"].ToString()
};
}

//Create Dataset to get the results of the GetShipTosAndIt emsSyncData
web service method
DataSet dsRetCustItems = new DataSet();

//Open the connection to the SqlCe database
conn.Open();

//Create SqlCe command object to store
//this is a way to get the schema from the database table, without
filling any data.
daCustomers.Sel ectCommand = SqlCeCmdCustome rs;
daShipTos.Selec tCommand = SqlCeCmdShipTo;
daItems.SelectC ommand = SqlCeCmdItems;

//fill the data adapter's schema with that of the table in the dataset
daCustomers.Fil lSchema(dsRetCu stItems,SchemaT ype.Mapped, "vmi_cust") ;
daShipTos.FillS chema(dsRetCust Items,SchemaTyp e.Mapped, "vmi_ship") ;
daItems.FillSch ema(dsRetCustIt ems,SchemaType. Mapped, "vmi_item_maste r");

//force the DataAdapter to generate the insert command, can also be manually
set.
SqlCeCommandBui lder cbCustomers = new SqlCeCommandBui lder(daCustomer s);
SqlCeCommandBui lder cbShipTos = new SqlCeCommandBui lder(daShipTos) ;
SqlCeCommandBui lder cbItems = new SqlCeCommandBui lder(daItems);

daCustomers.Mis singMappingActi on = MissingMappingA ction.Passthrou gh;
daShipTos.Missi ngMappingAction = MissingMappingA ction.Passthrou gh;
daItems.Missing MappingAction = MissingMappingA ction.Passthrou gh;

//seems this is needed to force the insert command to be assigned.
daCustomers.Ins ertCommand = cbCustomers.Get InsertCommand() ;
daShipTos.Inser tCommand = cbShipTos.GetIn sertCommand();
daItems.InsertC ommand = cbItems.GetInse rtCommand();

//call update to move all the data from sampletable DataTable into the
database table
daCustomers.Upd ate(dsRetCustIt ems, "VMI_CUST") ;
daShipTos.Updat e(dsRetCustItem s, "VMI_SHIP") ;
daItems.Update( dsRetCustItems, "VMI_ITEM_MASTE R");

cbCustomers.Dis pose();
cbShipTos.Dispo se();
cbItems.Dispose ();
}
catch(SqlCeExce ption SqlCeex)
{
MessageBox.Show ("Error insert/updating SqlCe database: " +
SqlCeex.Message );
}
catch(Exception ex)
{
MessageBox.Show ("Error in syncronization process: " + ex.Message);
}
finally
{
daCustomers.Dis pose();
daShipTos.Dispo se();
daItems.Dispose ();
SqlCeCmdCustome rs.Dispose();
SqlCeCmdShipTo. Dispose();
SqlCeCmdItems.D ispose();
conn.Close();
conn.Dispose();
}
}