Thread: asp.net help
View Single Post
Old 05-07-2010   #2
jak
Registered Member
 
jak's Avatar
 
Last Online: 12-11-2011
Join Date: Dec 2006
Posts: 946
Thanks: 388
Thanked 601 Times in 294 Posts
Groans: 4
Groaned at 3 Times in 3 Posts
Default

Dim cmd As New OleDbCommand()
Dim con As New OleDbConnection()
con.ConnectionString ="Provider = Microsoft.Jet.Oledb.4.0;Data Source=C:\Users\NONINO\Documents\Visual Studio 2008\WebSites\homwork 5\App_Data\Company.mdb"
con.open()
dim strQuery as string=
"DELETE FROM PRODUCTS where ProductCode = @productcode values ('{0}') ", tbxProductcode"
cmd.Connection=con
cmd.CommandText = strQuery
cmd.ExecuteNonQuery()

jak is offline   Reply With Quote
The Following User Says Thank You to jak For This Useful Post:
nonino_86 (05-10-2010)