Error In My Delete Code

[yaser95]

I Have Error When I used This Code ..
My Error Inside

[COLOR=#800000]"DELETE FROM thebank [/COLOR][SIZE=2][COLOR=#800000]WHERE id = ?;"[/COLOR][/SIZE][SIZE=2] & _
[/SIZE][SIZE=2][COLOR=#800000]"DELETE FROM Data WHERE id = ?;"[/COLOR][/SIZE]

See My Full Code Abou Delete

[SIZE=2][COLOR=#0000ff]Dim[/COLOR][/SIZE][SIZE=2] objCommand [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] OleDbCommand = [/SIZE][SIZE=2][COLOR=#0000ff]New[/COLOR][/SIZE][SIZE=2] OleDbCommand()
[/SIZE][SIZE=2][COLOR=#008000]' Set the Command object properties...
[/COLOR][/SIZE][SIZE=2]objCommand.Connection = cn
objCommand.CommandText = [/SIZE][SIZE=2][COLOR=#800000]"DELETE FROM thebank "[/COLOR][/SIZE][SIZE=2] & _
[/SIZE][SIZE=2][COLOR=#800000]"WHERE id = ?;"[/COLOR][/SIZE][SIZE=2] & _
[/SIZE][SIZE=2][COLOR=#800000]"DELETE FROM Data WHERE id = ?;"
[/COLOR][/SIZE][SIZE=2][COLOR=#008000]' Parameter for the title_id field...
[/COLOR][/SIZE][SIZE=2]objCommand.Parameters.AddWithValue _
([/SIZE][SIZE=2][COLOR=#800000]"?"[/COLOR][/SIZE][SIZE=2], BindingContext(MyDataView).Current([/SIZE][SIZE=2][COLOR=#800000]"id"[/COLOR][/SIZE][SIZE=2]))
[/SIZE][SIZE=2][COLOR=#008000]' Open the database connection...
[/COLOR][/SIZE][SIZE=2]cn.Open()
[/SIZE][SIZE=2][COLOR=#008000]' Execute the SqlCommand object to update the data...
[/COLOR][/SIZE][SIZE=2]objCommand.ExecuteNonQuery()
[/SIZE][SIZE=2][COLOR=#008000]' Close the connection...
[/COLOR][/SIZE][SIZE=2]cn.Close()
[/SIZE]

 

[fpineda101]

Try something like this...

sqlINS.Parameters.Add("@CopyPointsFile", SqlDbType.VarChar, 50).Value = textbox1.text

 

[yaser95]

i do not have any problem with Parameters ..
My Problem is ..
i can't delete from two Table by one Query like My book .
Thanks in Advance

 

[fpineda101]

So what is your error? No one can help you if you don't mention what it is. Saying that you can't do it like your book is NOT an error description.

 

[yaser95]

i got something like this error "there are characters after Sql Query"

 

[TechGnome]

You have to make two calls.... once the ; is encountered, that terminates the SQL Query..... so you will need to make two calls, one for one table and another for the other table.

-tg

 

[yaser95]

Ok ..
Thanks For Advance