473,320 Members | 1,988 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Vb.net 2005 database application with online mysql

rizwan6feb
108 100+
I have to develop a database application in vb.net 2005 with the following rules

1. The application connects with an online mysql database (i.e database resides on a remote machine)
2. The application has no local database but it should have a local cache to stores new records and the
changes made to the existing records should also be stored in the local cache if the connection with
online mysql database fails
3. The changes in the local cache should be updated in the online mysql database when the connection
with online database server becomes available
4. A search feature is also required

I am not sure, how to achieve all this. Please help me out.
Aug 19 '08 #1
6 1827
r035198x
13,262 8TB
What ideas do you have for it so far?
Aug 19 '08 #2
rizwan6feb
108 100+
What ideas do you have for it so far?
I have an idea to do this with the help of disconnected recordset model of ado.net but not sure will it work or not
Aug 19 '08 #3
rizwan6feb
108 100+
I have decided to use ADO.NET in disconnected mode. I am having a problem. When i try to fill the DataSet (Usning DataAdapter) with records it works fine on the local machine but the application freezes when i connect with remote mysql server. Plz help
Aug 20 '08 #4
kenobewan
4,871 Expert 4TB
Please post the relevant code and any error meesages, as well as more info. Thanks.
Aug 20 '08 #5
rizwan6feb
108 100+
Thanks for your response. I have manged to fix this myself. Now i am having another problem, when i update the DataSet back to the database (Using DataAdapter.update ), i receive the error message "Object reference not set to an instance of an object" even if the dataset contains rows, see the code below

Expand|Select|Wrap|Line Numbers
  1. Dim da As New MySql.Data.MySqlClient.MySqlDataAdapter
  2. Dim cmdBuilder As New MySql.Data.MySqlClient.MySqlCommandBuilder(da)
  3. da.Update(ds, "Table1")
  4. da.Update(ds, "Table2")
  5.  
Aug 20 '08 #6
Curtis Rutland
3,256 Expert 2GB
You need to use the DataAdapter that you filled the dataset with in the first place. The command builder can't build an update command if there is no select command for it to look at. Also, if you are adding/deleting rows, you will need INSERT and DELETE statements as well.
Aug 20 '08 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: democratix | last post by:
Hi, I've only got a couple years experience developing for Access but have recently been experimenting with HTML/javascript for gui and client-side scripting, mysql for database and php for...
2
by: Christian Decker | last post by:
I wanted to know if is a good idea to create classes that mirror exactly the structure of a database. This might sound a bit fuzzy but I'l explain myself with an example: CREATE TABLE...
8
by: nunodonato | last post by:
hi there. i'm thinking of developing an app using Java to manage a library (books, clients, orders..etc). I am not sure of how to store the data, maybe using files or a DBMS. The ammount of data...
2
by: Daven Thrice | last post by:
Hi, I've converted the tables from an old Access application to MySql format. I then linked the tables into access using MyODBC and everything works great (on my computer). For now, I want to...
0
by: Marcel - IDUG Europe 2005 | last post by:
Dear DB2 user, My name is Marcel Lévy and I'm a member of the IDUG 2005 Europe Conference Planning Committee. ********************************************************************* Mark your...
9
by: Daven Thrice | last post by:
If I have a fairly big Access MDB, that is relational, and has, say, 100 objects (forms, reports, modules, etc.), what is the path to get this database "online". Is there a way to put the tables...
2
by: shahram.shirazi | last post by:
Hi I am looking to develop an application that provides decision support through various graphs and charts using a mysql backend. My problem is between the data collection and data...
0
Coldfire
by: Coldfire | last post by:
Since i cannot show the differences in a two-column like table. I am first putting MS SQL Server 2005 and then MySQL 5.x. MS SQL Server 2005 Brief Overview - SQL Server is a full-fledged...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.