|
|
You're in the
dotnet compact framework
group:Updating the SqlCe database from a DataSet
dotnet compact framework:
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 contains three different tables that need to be loaded 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. In fact, everything in the method works just like I want it but the but I can't get the DataAdapter.Update method to insert 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"); SqlCeDataAdapter daCustomers = new SqlCeDataAdapter(); SqlCeDataAdapter daShipTos = new SqlCeDataAdapter(); SqlCeDataAdapter daItems = new SqlCeDataAdapter(); //instantiate SqlCe SELECT command SqlCeCommand SqlCeCmdCustomers = new SqlCeCommand("SELECT * FROM vmi_cust WHERE 1 = 2", conn); SqlCeCommand SqlCeCmdShipTo = new SqlCeCommand("SELECT * FROM vmi_ship WHERE 1 = 2", conn); SqlCeCommand SqlCeCmdItems = new SqlCeCommand("SELECT * 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.Tables[0].Rows.Count][]; for(int x = 0; x < dsVMI_Cust.Tables[0].Rows.Count; x++) { arrayShipToID[x] = new string[] { dsVMI_Cust.Tables[0].Rows[x]["ship2_id"].ToString(), dsVMI_Cust.Tables[0].Rows[x]["is_existing_customer"].ToString() }; } //Create Dataset to get the results of the GetShipTosAndItemsSyncData 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.SelectCommand = SqlCeCmdCustomers; daShipTos.SelectCommand = SqlCeCmdShipTo; daItems.SelectCommand = SqlCeCmdItems; //fill the data adapter's schema with that of the table in the dataset daCustomers.FillSchema(dsRetCustItems,SchemaType.Mapped, "vmi_cust"); daShipTos.FillSchema(dsRetCustItems,SchemaType.Mapped, "vmi_ship"); daItems.FillSchema(dsRetCustItems,SchemaType.Mapped, "vmi_item_master"); //force the DataAdapter to generate the insert command, can also be manually set. SqlCeCommandBuilder cbCustomers = new SqlCeCommandBuilder(daCustomers); SqlCeCommandBuilder cbShipTos = new SqlCeCommandBuilder(daShipTos); SqlCeCommandBuilder cbItems = new SqlCeCommandBuilder(daItems); daCustomers.MissingMappingAction = MissingMappingAction.Passthrough; daShipTos.MissingMappingAction = MissingMappingAction.Passthrough; daItems.MissingMappingAction = MissingMappingAction.Passthrough; //seems this is needed to force the insert command to be assigned. daCustomers.InsertCommand = cbCustomers.GetInsertCommand(); daShipTos.InsertCommand = cbShipTos.GetInsertCommand(); daItems.InsertCommand = cbItems.GetInsertCommand(); //call update to move all the data from sampletable DataTable into the database table daCustomers.Update(dsRetCustItems, "VMI_CUST"); daShipTos.Update(dsRetCustItems, "VMI_SHIP"); daItems.Update(dsRetCustItems, "VMI_ITEM_MASTER"); cbCustomers.Dispose(); cbShipTos.Dispose(); cbItems.Dispose(); } catch(SqlCeException SqlCeex) { MessageBox.Show("Error insert/updating SqlCe database: " + SqlCeex.Message); } catch(Exception ex) { MessageBox.Show("Error in syncronization process: " + ex.Message); } finally { daCustomers.Dispose(); daShipTos.Dispose(); daItems.Dispose(); SqlCeCmdCustomers.Dispose(); SqlCeCmdShipTo.Dispose(); SqlCeCmdItems.Dispose(); conn.Close(); conn.Dispose(); } }
Hi
I dont have much idea about but i use the Fill() method of DataAdapter to fill data into the table and i did not find it here. You may be using some alternative method...filling scema then updating..i suppose. Try using the Fill() method once ensuring proper connection. Thanks & Regards Vikash [quoted text, click to view] CenGenTech wrote:
> 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 > contains three different tables that need to be loaded 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. In > fact, everything in the method works just like I want it but the but I > can't get the DataAdapter.Update method to insert 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"); > SqlCeDataAdapter daCustomers = new SqlCeDataAdapter(); > SqlCeDataAdapter daShipTos = new SqlCeDataAdapter(); > SqlCeDataAdapter daItems = new SqlCeDataAdapter(); > > //instantiate SqlCe SELECT command > SqlCeCommand SqlCeCmdCustomers = new SqlCeCommand("SELECT * FROM > vmi_cust > WHERE 1 = 2", conn); > SqlCeCommand SqlCeCmdShipTo = new SqlCeCommand("SELECT * FROM > vmi_ship > WHERE 1 = 2", conn); > SqlCeCommand SqlCeCmdItems = new SqlCeCommand("SELECT * 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.Tables[0].Rows.Count][]; > > for(int x = 0; x < dsVMI_Cust.Tables[0].Rows.Count; x++) > { > arrayShipToID[x] = new string[] { > dsVMI_Cust.Tables[0].Rows[x]["ship2_id"].ToString(), > dsVMI_Cust.Tables[0].Rows[x]["is_existing_customer"].ToString() > }; > } > > //Create Dataset to get the results of the > GetShipTosAndItemsSyncData 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.SelectCommand = SqlCeCmdCustomers; > daShipTos.SelectCommand = SqlCeCmdShipTo; > daItems.SelectCommand = SqlCeCmdItems; > > //fill the data adapter's schema with that of the table in the > dataset > daCustomers.FillSchema(dsRetCustItems,SchemaType.Mapped, > "vmi_cust"); > daShipTos.FillSchema(dsRetCustItems,SchemaType.Mapped, > "vmi_ship"); > daItems.FillSchema(dsRetCustItems,SchemaType.Mapped, > "vmi_item_master"); > > //force the DataAdapter to generate the insert command, can also be > manually set. > SqlCeCommandBuilder cbCustomers = new > SqlCeCommandBuilder(daCustomers); > SqlCeCommandBuilder cbShipTos = new > SqlCeCommandBuilder(daShipTos); > SqlCeCommandBuilder cbItems = new SqlCeCommandBuilder(daItems); > > daCustomers.MissingMappingAction = > MissingMappingAction.Passthrough; > daShipTos.MissingMappingAction = > MissingMappingAction.Passthrough; > daItems.MissingMappingAction = MissingMappingAction.Passthrough; > > //seems this is needed to force the insert command to be > assigned. > daCustomers.InsertCommand = cbCustomers.GetInsertCommand(); > daShipTos.InsertCommand = cbShipTos.GetInsertCommand(); > daItems.InsertCommand = cbItems.GetInsertCommand(); > > //call update to move all the data from sampletable DataTable > into the database table > daCustomers.Update(dsRetCustItems, "VMI_CUST"); > daShipTos.Update(dsRetCustItems, "VMI_SHIP"); > daItems.Update(dsRetCustItems, "VMI_ITEM_MASTER"); > > cbCustomers.Dispose(); > cbShipTos.Dispose(); > cbItems.Dispose(); > } > catch(SqlCeException SqlCeex) > { > MessageBox.Show("Error insert/updating SqlCe database: " + > SqlCeex.Message); > } > catch(Exception ex) > { > MessageBox.Show("Error in syncronization process: " + > ex.Message); > } > finally > { > daCustomers.Dispose(); > daShipTos.Dispose(); > daItems.Dispose(); > SqlCeCmdCustomers.Dispose(); > SqlCeCmdShipTo.Dispose(); > SqlCeCmdItems.Dispose(); > conn.Close(); > conn.Dispose(); > } > }
Thanks for the suggestion but I don't think the Fill() will discern
between new and existing records. The dataset may have new records that require a simple insert or existing records that need to be updated. The DataAdapter.Update method is supposed to auto generate the sql statement for each scenario. Unfortunately, I believe its the RowState that's causing the problem, which is Unchanged because I pull the data from the server based on the last sync date on the mobile device. Using one date allows me to pull thousands of records very quickly as opposed to comparing the dates of each record. Long story short - I believe I'm trying to accomplish something the method is not intended to handle. Let me know if you think I'm wrong but I've tried everything I know to do to get it to insert the records and it won't. I'm resolved to creating the insert and update statements manually and running them through a loop to get the data in the SqlCe database. [quoted text, click to view] vikash wrote:
> Hi > I dont have much idea about but i use the Fill() method of DataAdapter > to fill data into the table and i did not find it here. You may be > using some alternative method...filling scema then updating..i suppose. > Try using the Fill() method once ensuring proper connection. > > Thanks & Regards > Vikash > > CenGenTech wrote: > > > 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 > > contains three different tables that need to be loaded 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. In > > fact, everything in the method works just like I want it but the but I > > can't get the DataAdapter.Update method to insert 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"); > > SqlCeDataAdapter daCustomers = new SqlCeDataAdapter(); > > SqlCeDataAdapter daShipTos = new SqlCeDataAdapter(); > > SqlCeDataAdapter daItems = new SqlCeDataAdapter(); > > > > //instantiate SqlCe SELECT command > > SqlCeCommand SqlCeCmdCustomers = new SqlCeCommand("SELECT * FROM > > vmi_cust > > WHERE 1 = 2", conn); > > SqlCeCommand SqlCeCmdShipTo = new SqlCeCommand("SELECT * FROM > > vmi_ship > > WHERE 1 = 2", conn); > > SqlCeCommand SqlCeCmdItems = new SqlCeCommand("SELECT * 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.Tables[0].Rows.Count][]; > > > > for(int x = 0; x < dsVMI_Cust.Tables[0].Rows.Count; x++) > > { > > arrayShipToID[x] = new string[] { > > dsVMI_Cust.Tables[0].Rows[x]["ship2_id"].ToString(), > > dsVMI_Cust.Tables[0].Rows[x]["is_existing_customer"].ToString() > > }; > > } > > > > //Create Dataset to get the results of the > > GetShipTosAndItemsSyncData 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.SelectCommand = SqlCeCmdCustomers; > > daShipTos.SelectCommand = SqlCeCmdShipTo; > > daItems.SelectCommand = SqlCeCmdItems; > > > > //fill the data adapter's schema with that of the table in the > > dataset > > daCustomers.FillSchema(dsRetCustItems,SchemaType.Mapped, > > "vmi_cust"); > > daShipTos.FillSchema(dsRetCustItems,SchemaType.Mapped, > > "vmi_ship"); > > daItems.FillSchema(dsRetCustItems,SchemaType.Mapped, > > "vmi_item_master"); > > > > //force the DataAdapter to generate the insert command, can also be > > manually set. > > SqlCeCommandBuilder cbCustomers = new > > SqlCeCommandBuilder(daCustomers); > > SqlCeCommandBuilder cbShipTos = new > > SqlCeCommandBuilder(daShipTos); > > SqlCeCommandBuilder cbItems = new SqlCeCommandBuilder(daItems); > > > > daCustomers.MissingMappingAction = > > MissingMappingAction.Passthrough; > > daShipTos.MissingMappingAction = > > MissingMappingAction.Passthrough; > > daItems.MissingMappingAction = MissingMappingAction.Passthrough; > > > > //seems this is needed to force the insert command to be > > assigned. > > daCustomers.InsertCommand = cbCustomers.GetInsertCommand(); > > daShipTos.InsertCommand = cbShipTos.GetInsertCommand(); > > daItems.InsertCommand = cbItems.GetInsertCommand(); > > > > //call update to move all the data from sampletable DataTable > > into the database table > > daCustomers.Update(dsRetCustItems, "VMI_CUST"); > > daShipTos.Update(dsRetCustItems, "VMI_SHIP"); > > daItems.Update(dsRetCustItems, "VMI_ITEM_MASTER"); > > > > cbCustomers.Dispose(); > > cbShipTos.Dispose(); > > cbItems.Dispose(); > > } > > catch(SqlCeException SqlCeex) > > { > > MessageBox.Show("Error insert/updating SqlCe database: " + > > SqlCeex.Message); > > } > > catch(Exception ex) > > { > > MessageBox.Show("Error in syncronization process: " + > > ex.Message); > > } > > finally > > { > > daCustomers.Dispose(); > > daShipTos.Dispose(); > > daItems.Dispose(); > > SqlCeCmdCustomers.Dispose(); > > SqlCeCmdShipTo.Dispose(); > > SqlCeCmdItems.Dispose(); > > conn.Close(); > > conn.Dispose(); > > } > > }
Consider using RDA or replication instead. Most common reasons to come up
with self made solutions instead of using RDA or replication are: 1. Need to install IIS - you already have it for WS. 2. Attempt to reduce number of required CALs to 1 (as in for WS only). But SQL Server license agreement does not work that way and require CAL for each device regardless if you connect directly or through a proxy like WS. -- Best regards, Ilya This posting is provided "AS IS" with no warranties, and confers no rights. *** Want to find answers instantly? Here's how... *** 1. Go to http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en 2. Type your question in the text box near "Search this group" button. 3. Hit "Search this group" button. 4. Read answer(s). [quoted text, click to view] "CenGenTech" <jsmith@cengentech.com> wrote in message news:1155526555.878583.62470@b28g2000cwb.googlegroups.com... >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 > contains three different tables that need to be loaded 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. In > fact, everything in the method works just like I want it but the but I > can't get the DataAdapter.Update method to insert 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"); > SqlCeDataAdapter daCustomers = new SqlCeDataAdapter(); > SqlCeDataAdapter daShipTos = new SqlCeDataAdapter(); > SqlCeDataAdapter daItems = new SqlCeDataAdapter(); > > //instantiate SqlCe SELECT command > SqlCeCommand SqlCeCmdCustomers = new SqlCeCommand("SELECT * FROM > vmi_cust > WHERE 1 = 2", conn); > SqlCeCommand SqlCeCmdShipTo = new SqlCeCommand("SELECT * FROM > vmi_ship > WHERE 1 = 2", conn); > SqlCeCommand SqlCeCmdItems = new SqlCeCommand("SELECT * 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.Tables[0].Rows.Count][]; > > for(int x = 0; x < dsVMI_Cust.Tables[0].Rows.Count; x++) > { > arrayShipToID[x] = new string[] { > dsVMI_Cust.Tables[0].Rows[x]["ship2_id"].ToString(), > dsVMI_Cust.Tables[0].Rows[x]["is_existing_customer"].ToString() > }; > } > > //Create Dataset to get the results of the > GetShipTosAndItemsSyncData 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.SelectCommand = SqlCeCmdCustomers; > daShipTos.SelectCommand = SqlCeCmdShipTo; > daItems.SelectCommand = SqlCeCmdItems; > > //fill the data adapter's schema with that of the table in the > dataset > daCustomers.FillSchema(dsRetCustItems,SchemaType.Mapped, > "vmi_cust"); > daShipTos.FillSchema(dsRetCustItems,SchemaType.Mapped, > "vmi_ship"); > daItems.FillSchema(dsRetCustItems,SchemaType.Mapped, > "vmi_item_master"); > > //force the DataAdapter to generate the insert command, can also be > manually set. > SqlCeCommandBuilder cbCustomers = new > SqlCeCommandBuilder(daCustomers); > SqlCeCommandBuilder cbShipTos = new > SqlCeCommandBuilder(daShipTos); > SqlCeCommandBuilder cbItems = new SqlCeCommandBuilder(daItems); > > daCustomers.MissingMappingAction = > MissingMappingAction.Passthrough; > daShipTos.MissingMappingAction = > MissingMappingAction.Passthrough; > daItems.MissingMappingAction = MissingMappingAction.Passthrough; > > //seems this is needed to force the insert command to be > assigned. > daCustomers.InsertCommand = cbCustomers.GetInsertCommand(); > daShipTos.InsertCommand = cbShipTos.GetInsertCommand(); > daItems.InsertCommand = cbItems.GetInsertCommand(); > > //call update to move all the data from sampletable DataTable > into the database table > daCustomers.Update(dsRetCustItems, "VMI_CUST"); > daShipTos.Update(dsRetCustItems, "VMI_SHIP"); > daItems.Update(dsRetCustItems, "VMI_ITEM_MASTER"); > > cbCustomers.Dispose(); > cbShipTos.Dispose(); > cbItems.Dispose(); > } > catch(SqlCeException SqlCeex) > { > MessageBox.Show("Error insert/updating SqlCe database: " + > SqlCeex.Message); > } > catch(Exception ex) > { > MessageBox.Show("Error in syncronization process: " + > ex.Message); > } > finally > { > daCustomers.Dispose(); > daShipTos.Dispose(); > daItems.Dispose(); > SqlCeCmdCustomers.Dispose(); > SqlCeCmdShipTo.Dispose(); > SqlCeCmdItems.Dispose(); > conn.Close(); > conn.Dispose(); > } > } >
IIya,
I've never tried replication. How would it work with a business process that allows the user to determine when and what data to replicate? In addition, the tables are not even close to the same structure! Regards, Johnny [quoted text, click to view] Ilya Tumanov [MS] wrote:
> Consider using RDA or replication instead. Most common reasons to come up > with self made solutions instead of using RDA or replication are: > > > > 1. Need to install IIS - you already have it for WS. > > 2. Attempt to reduce number of required CALs to 1 (as in for WS only). But > SQL Server license agreement does not work that way and require CAL for each > device regardless if you connect directly or through a proxy like WS. > > > > > -- > Best regards, > > Ilya > > This posting is provided "AS IS" with no warranties, and confers no rights. > > *** Want to find answers instantly? Here's how... *** > > 1. Go to > http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en > 2. Type your question in the text box near "Search this group" button. > 3. Hit "Search this group" button. > 4. Read answer(s). > > "CenGenTech" <jsmith@cengentech.com> wrote in message > news:1155526555.878583.62470@b28g2000cwb.googlegroups.com... > >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 > > contains three different tables that need to be loaded 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. In > > fact, everything in the method works just like I want it but the but I > > can't get the DataAdapter.Update method to insert 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"); > > SqlCeDataAdapter daCustomers = new SqlCeDataAdapter(); > > SqlCeDataAdapter daShipTos = new SqlCeDataAdapter(); > > SqlCeDataAdapter daItems = new SqlCeDataAdapter(); > > > > //instantiate SqlCe SELECT command > > SqlCeCommand SqlCeCmdCustomers = new SqlCeCommand("SELECT * FROM > > vmi_cust > > WHERE 1 = 2", conn); > > SqlCeCommand SqlCeCmdShipTo = new SqlCeCommand("SELECT * FROM > > vmi_ship > > WHERE 1 = 2", conn); > > SqlCeCommand SqlCeCmdItems = new SqlCeCommand("SELECT * 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.Tables[0].Rows.Count][]; > > > > for(int x = 0; x < dsVMI_Cust.Tables[0].Rows.Count; x++) > > { > > arrayShipToID[x] = new string[] { > > dsVMI_Cust.Tables[0].Rows[x]["ship2_id"].ToString(), > > dsVMI_Cust.Tables[0].Rows[x]["is_existing_customer"].ToString() > > }; > > } > > > > //Create Dataset to get the results of the > > GetShipTosAndItemsSyncData 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.SelectCommand = SqlCeCmdCustomers; > > daShipTos.SelectCommand = SqlCeCmdShipTo; > > daItems.SelectCommand = SqlCeCmdItems; > > > > //fill the data adapter's schema with that of the table in the > > dataset > > daCustomers.FillSchema(dsRetCustItems,SchemaType.Mapped, > > "vmi_cust"); > > daShipTos.FillSchema(dsRetCustItems,SchemaType.Mapped, > > "vmi_ship"); > > daItems.FillSchema(dsRetCustItems,SchemaType.Mapped, > > "vmi_item_master"); > > > > //force the DataAdapter to generate the insert command, can also be > > manually set. > > SqlCeCommandBuilder cbCustomers = new > > SqlCeCommandBuilder(daCustomers); > > SqlCeCommandBuilder cbShipTos = new > > SqlCeCommandBuilder(daShipTos); > > SqlCeCommandBuilder cbItems = new SqlCeCommandBuilder(daItems); > > > > daCustomers.MissingMappingAction = > > MissingMappingAction.Passthrough; > > daShipTos.MissingMappingAction = > > MissingMappingAction.Passthrough; > > daItems.MissingMappingAction = MissingMappingAction.Passthrough; > > > > //seems this is needed to force the insert command to be > > assigned. > > daCustomers.InsertCommand = cbCustomers.GetInsertCommand(); > > daShipTos.InsertCommand = cbShipTos.GetInsertCommand(); > > daItems.InsertCommand = cbItems.GetInsertCommand(); > > > > //call update to move all the data from sampletable DataTable > > into the database table > > daCustomers.Update(dsRetCustItems, "VMI_CUST"); > > daShipTos.Update(dsRetCustItems, "VMI_SHIP"); > > daItems.Update(dsRetCustItems, "VMI_ITEM_MASTER"); > > > > cbCustomers.Dispose(); > > cbShipTos.Dispose(); > > cbItems.Dispose(); > > } > > catch(SqlCeException SqlCeex) > > { > > MessageBox.Show("Error insert/updating SqlCe database: " + > > SqlCeex.Message); > > } > > catch(Exception ex) > > { > > MessageBox.Show("Error in syncronization process: " + > > ex.Message); > > } > > finally > > { > > daCustomers.Dispose(); > > daShipTos.Dispose(); > > daItems.Dispose(); > > SqlCeCmdCustomers.Dispose(); > > SqlCeCmdShipTo.Dispose(); > > SqlCeCmdItems.Dispose(); > > conn.Close(); > > conn.Dispose(); > > } > > } > >
If you interested in RDA or replication, please read all about it here and
see if it suits your needs: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_connectivity.asp http://msdn2.microsoft.com/en-us/library/ms172931.aspx If you need more info, just search... -- Best regards, Ilya This posting is provided "AS IS" with no warranties, and confers no rights. *** Want to find answers instantly? Here's how... *** 1. Go to http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en 2. Type your question in the text box near "Search this group" button. 3. Hit "Search this group" button. 4. Read answer(s). [quoted text, click to view] "CenGenTech" <jsmith@cengentech.com> wrote in message news:1155633940.855203.246890@h48g2000cwc.googlegroups.com... > IIya, > > I've never tried replication. How would it work with a business > process that allows the user to determine when and what data to > replicate? In addition, the tables are not even close to the same > structure! > > Regards, > Johnny > > Ilya Tumanov [MS] wrote: >> Consider using RDA or replication instead. Most common reasons to come up >> with self made solutions instead of using RDA or replication are: >> >> >> >> 1. Need to install IIS - you already have it for WS. >> >> 2. Attempt to reduce number of required CALs to 1 (as in for WS only). >> But >> SQL Server license agreement does not work that way and require CAL for >> each >> device regardless if you connect directly or through a proxy like WS. >> >> >> >> >> -- >> Best regards, >> >> Ilya >> >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> *** Want to find answers instantly? Here's how... *** >> >> 1. Go to >> http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en >> 2. Type your question in the text box near "Search this group" button. >> 3. Hit "Search this group" button. >> 4. Read answer(s). >> >> "CenGenTech" <jsmith@cengentech.com> wrote in message >> news:1155526555.878583.62470@b28g2000cwb.googlegroups.com... >> >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 >> > contains three different tables that need to be loaded 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. In >> > fact, everything in the method works just like I want it but the but I >> > can't get the DataAdapter.Update method to insert 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"); >> > SqlCeDataAdapter daCustomers = new SqlCeDataAdapter(); >> > SqlCeDataAdapter daShipTos = new SqlCeDataAdapter(); >> > SqlCeDataAdapter daItems = new SqlCeDataAdapter(); >> > >> > //instantiate SqlCe SELECT command >> > SqlCeCommand SqlCeCmdCustomers = new SqlCeCommand("SELECT * FROM >> > vmi_cust >> > WHERE 1 = 2", conn); >> > SqlCeCommand SqlCeCmdShipTo = new SqlCeCommand("SELECT * FROM >> > vmi_ship >> > WHERE 1 = 2", conn); >> > SqlCeCommand SqlCeCmdItems = new SqlCeCommand("SELECT * 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.Tables[0].Rows.Count][]; >> > >> > for(int x = 0; x < dsVMI_Cust.Tables[0].Rows.Count; x++) >> > { >> > arrayShipToID[x] = new string[] { >> > dsVMI_Cust.Tables[0].Rows[x]["ship2_id"].ToString(), >> > dsVMI_Cust.Tables[0].Rows[x]["is_existing_customer"].ToString() >> > }; >> > } >> > >> > //Create Dataset to get the results of the >> > GetShipTosAndItemsSyncData 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.SelectCommand = SqlCeCmdCustomers; >> > daShipTos.SelectCommand = SqlCeCmdShipTo; >> > daItems.SelectCommand = SqlCeCmdItems; >> > >> > //fill the data adapter's schema with that of the table in the >> > dataset >> > daCustomers.FillSchema(dsRetCustItems,SchemaType.Mapped, >> > "vmi_cust"); >> > daShipTos.FillSchema(dsRetCustItems,SchemaType.Mapped, >> > "vmi_ship"); >> > daItems.FillSchema(dsRetCustItems,SchemaType.Mapped, >> > "vmi_item_master"); >> > >> > //force the DataAdapter to generate the insert command, can also be >> > manually set. >> > SqlCeCommandBuilder cbCustomers = new >> > SqlCeCommandBuilder(daCustomers); >> > SqlCeCommandBuilder cbShipTos = new >> > SqlCeCommandBuilder(daShipTos); >> > SqlCeCommandBuilder cbItems = new SqlCeCommandBuilder(daItems); >> > >> > daCustomers.MissingMappingAction = >> > MissingMappingAction.Passthrough; >> > daShipTos.MissingMappingAction = >> > MissingMappingAction.Passthrough; >> > daItems.MissingMappingAction = MissingMappingAction.Passthrough; >> > >> > //seems this is needed to force the insert command to be >> > assigned. >> > daCustomers.InsertCommand = cbCustomers.GetInsertCommand(); >> > daShipTos.InsertCommand = cbShipTos.GetInsertCommand(); >> > daItems.InsertCommand = cbItems.GetInsertCommand(); >> > >> > //call update to move all the data from sampletable DataTable >> > into the database table >> > daCustomers.Update(dsRetCustItems, "VMI_CUST"); >> > daShipTos.Update(dsRetCustItems, "VMI_SHIP"); >> > daItems.Update(dsRetCustItems, "VMI_ITEM_MASTER"); >> > >> > cbCustomers.Dispose(); >> > cbShipTos.Dispose(); >> > cbItems.Dispose(); >> > } >> > catch(SqlCeException SqlCeex) >> > { >> > MessageBox.Show("Error insert/updating SqlCe database: " + >> > SqlCeex.Message); >> > } >> > catch(Exception ex) >> > { >> > MessageBox.Show("Error in syncronization process: " + >> > ex.Message); >> > } >> > finally >> > { >> > daCustomers.Dispose(); >> > daShipTos.Dispose(); >> > daItems.Dispose(); >> > SqlCeCmdCustomers.Dispose(); >> > SqlCeCmdShipTo.Dispose(); >> > SqlCeCmdItems.Dispose(); >> > conn.Close(); >> > conn.Dispose(); >> > } >> > } >> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |