I'm using the following so I can format all my dates relvant to the current culture of the OS. The app is for global use private DateTimeFormatInfo dtFormatInfo; this.dtFormatInfo = Thread.CurrentThread.CurrentUICulture.DateTimeFormat; I have then created a property to format any dates in ShortDatePattern public string ShortDateFmt { get { return this.dtFormatInfo.ShortDatePattern; } } Every time I run my application and process a date it returns in the format mm\dd\yyyy when running on an OS with United Kingdom setup (en-GB). en-GB date format should be dd/mm/yyyy I have even created the follwing property so as to debug and check the CurrentUICulture public string CurrentUICultureName { get { return Thread.CurrentThread.CurrentUICulture.Name; } } and this is returning en-GB. Any suggestions as to why the date is not formatting for en-GB

Just Greeky Creek wrote: u can do ,if the table schemes r the same. How is this done?

Is it possible to compare two datarows taken from two separate datasets as a whole, or do you have to compare the value of each column in the row. Please advise

Thanks, Seem to have the additions working, but problems with comparing rows. What is the correct syntax for comparing datarows. Do I have to compare the value of each column in the row, or can I compare the row as a whole.

Anybody know of a work around?

OK, Rem'd this line out. To enable some debugging I load the page with 4 data grids. the first data grid with 1st dataset, second with 2nd dataset, third with the merge results and a fourth with any changes to 1st dataset if any. Here's my code: 'Merge data dstMBR.Merge(dstMBR1) 'Get any changes encountered in original dataset dstMBR2 = dstMBR1.GetChanges 'dstMBR.acceptchanges 'Bind merged dataset to datagrid dgrd2.DataSource = dstMBR1 dgrd2.DataBind() 'Bind changes(if any)to datagrid dgrd3.DataSource = dstMBR2 dgrd3.DataBind() 'Update data source dadMBR.Update(dstMBR, "users") 'More checks for modified data If not dstMBR.GetChanges(DataRowState.Modified) Is Nothing Then lblStatus.Text = "Modified" End If If not dstMBR.GetChanges(DataRowState.Added) Is Nothing Then lblStatus.Text = "Add" End If If not dstMBR.GetChanges(DataRowState.Deleted) Is Nothing Then lblStatus.Text = "Del" End If End Sub You'll notice that acceptchanges is remarked out

I have a VB.net standalone application. I want a method of merging a table from the database application with a master database. Replication is not an option. I have tried dumping the table from db1 into a dataset (dataset1), and then the same table from db2 into a dataset (dataset2). Will using the dataset merge method combine the data to enable me to update the master. IE. dataset1.Merge(dataset2) dataset1.acceptchanges dataAdapter1.Update(dataset1, "Table1") It seems that dataset1 gets dataset2's data appended, but the datasource does not update. Please advise a method to do this.

I have a standalone application written in VB.NET that uses an access DB. The application is portable and used by several users on differnet machines. I want to be able to sync the portable DB's with a master DB. Is Replication the only way? The DB's are password protected at present. I can think of a way using replication with JRO, but that seems a bit old hat now. Please help:confused:

I have a standalone application written in VB.NET that uses an access DB. The application is portable and used by several users on differnet machines. I want to be able to sync the portable DB's with a master DB. Is Replication the only way? The DB's are password protected at present. I can think of a way using replication with JRO, but that seems a bit old hat now. Please help:confused: