2 Replies - 491 Views - Last Post: 25 January 2013 - 10:07 AM Rate Topic: -----

#1 xhanemila4  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 14
  • Joined: 29-September 12

Delete query

Posted 23 January 2013 - 11:19 AM

Hi,

Im trying to delete a selected row from my table name 2,and add a data from my table name 1. I can add data but my delete query is not doing it's job

Here's my code

connectToDatabase()
openConnection()
ds.clear()
ds.Tables.clear()
addmonitorIn()
adapter.Fill(ds)
closeConnection

connectToDatabase()
openConnection()
ds.clear()
ds.Tables.clear()
delete()
adapter.Fill(ds)
'I am certain that this is where im mistaken, never use delete query before so i dont know what adapter command to use,
'but if you have better idea,kindly state it to me thanks

closeConnection






sorry it was deleteme() and forgot to qoute the other comment

Is This A Good Question/Topic? 0
  • +

Replies To: Delete query

#2 Atli  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 3712
  • View blog
  • Posts: 5,964
  • Joined: 08-June 10

Re: Delete query

Posted 24 January 2013 - 03:40 AM

I've moved this to the VB.NET forum. There is no actual MySQL specific code in there; it's all pretty much .NET specific.
Was This Post Helpful? 0
  • +
  • -

#3 jgferguson  Icon User is offline

  • New D.I.C Head

Reputation: 3
  • View blog
  • Posts: 31
  • Joined: 11-July 12

Re: Delete query

Posted 25 January 2013 - 10:07 AM

Hi,

We will need to see what the SQL command is in the DeleteMe() routine.

For MySQL databases the Delete syntax can be found at:- http://dev.mysql.com.../en/delete.html

Sorry can't be more help.

Cheers,
Jerry.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1