I'm currently developing a program for my company and I need to be able to write directly to the clients table in my simply accounting database, I'm not sure who could help me in achieving this but I need to speak to someone who can guide me through the process.
I'm using visual studio 2010 to connect to the database. The database is a ".SAI" file.
I've tried adding a new datasource using Microsoft ODBC Data Source (ODBC) wizard and selected my database name from the drop-down list. The problem I'm having is I cannot add or update records in the database using this method, I can only read records but not write to them. An error is always given anytime I try to update the records stating that there's an error in the query.
I've also tried using the MySQL connection wizard to add the database but it simply cannot find it no matter what I enter. I know that simply accounting uses MySQL for their database but I can't find any instruction on how to connect to it.
I need to be able to : ADD - DELETE - UPDATE the information in the "tcustomr" table of the simply accounting database. The only fields I specifically need in the table are:
I've tried downloading the SDK but I can't find any tutorials on how exactly I can query and save records to the database. It is extremely difficult to understand the process through the SDK.
I would really appreciate it if someone can help me figure out how to connect to my database, read data from the "tcustomr" table and update or delete records from the table using visual studio 2010 (vb.net)
Essentially I need the exact code to use in visual studio in order to be able to do this
Thank you for any help you can offer me,