Last post Aug 04, 2011 09:29 AM by todo1979
Aug 03, 2011 05:06 AM|todo1979|LINK
Hi to all,
on my localhost I have a Mysql instance running and a database.
In my project I have:
MySql.Data.MySqlClient.MySqlConnection = New
MySql.Data.MySqlClient.MySqlCommand = New
* FROM a_result")
it seems to work.
I also have the variables: name as string, surname as string, age as integer and code as string
Now, what I need, is to insert into the table the values where "code" does not exist or to update the table if "code" exists.
Aug 03, 2011 05:17 AM|CruzerB|LINK
You can go through the MySql .NET Connector tutorial.
1st, you have to select the record from database. If record exist then you need to use the update statement. Otherwise, use the insert statement.
Aug 04, 2011 09:29 AM|todo1979|LINK