In the project I still making I’m using MySQL database to storing items. We can remove items from database. How to remove item from MySQL via Visual Basic?
Attention! This post has been published on my old website that has been down. I’m archiving old not verified posts for possible future use. Please be careful when using this post content.
In order to remove item from MySQL table following query has to be used:
DELETE FROM TableName WHERE DB_ColumnName='YourRecord';
Following code is consisted of:
- MySqlConnection – connection to MySQL database,
- MySqlDataAdapter – query to MySQL,
- Try – trying open connection,
- Exception – error handling.
Whole code to connect MySQL database and remove some item:
Imports MySql.Data.MySqlClient
Public Sub UsunLokacje()
' Item removing from MySQL database
Dim dTableCount As Long
Dim dTable1 As New DataTable
'1. Connection data
'-------------------------------------
Dim conn As MySqlConnection = New MySqlConnection() ' forgot source
conn.ConnectionString = "Data Source=" & fmMain.txtMYSQLpath.Text & "; Database=" & fmMain.txtOPCJEnazwaMYSQL.Text & _
"; Uid=root; Pwd=" & fmMain.txtOPCJEhasloMYSQL.Text & ";"
Try
conn.Open() ' open connection
Try
' Checking if item is in table
' -----------------------------------------
Dim adapter As MySqlDataAdapter = New MySqlDataAdapter("SELECT * FROM nazwylokacji WHERE Lokacja='" & _
fmMain.txtOPCJETornadoLokacja.Text & "';", conn)
adapter.Fill (dTable1)
dTableCount = dTable1.Rows.Count
If dTableCount > 0 Then
' Item removing
' ---------------------------------
Dim cmd1 As MySqlCommand = New MySqlCommand("DELETE FROM nazwylokacji WHERE Lokacja='" & _
fmMain.txtOPCJETornadoLokacja.Text & "';", conn)
cmd1.ExecuteNonQuery() 'usuwanie wartości z MySQL
cmd1 = Nothing
conn.Close()
' Confiramtion for user
' -------------------------------------------------
MsgBox("Location '" & fmMain.txtOPCJETornadoLokacja.Text & "' has been removed.", vbInformation, "Confirmation...")
Else
MsgBox("Location can't be removed: '" & fmMain.txtOPCJETornadoLokacja.Text & "'.", vbCritical, "Error...")
End If
Catch ex1 As Exception
MsgBox("Error when location removing. Table: 'nazwylokacji'." + Chr(10) + Chr(10) + "Err no.:" + Chr(10) + ex1.Message, _
MsgBoxStyle.Critical, "Error...")
End Try
Catch ex As Exception
MsgBox("Database connection problem. Table: 'nazwylokacji'." + Chr(10) + Chr(10) + "Kod błedu:" + Chr(10) + ex.Message, _
MsgBoxStyle.Critical, "Conenction error...")
conn.Close()
Finally
conn.Dispose()
fmMain.txtOPCJETornadoLokacja.Clear()
Call modDBgrid.IloscTornado ' DataGridView refresh
End Try
End Sub
Pingback: soi lo de
Pingback: cach choi number game
Pingback: buy lortab pills online pharmacy no presption next day shipping discreet
Pingback: mo thay nguoi chet danh con gi
Pingback: order ativan online in usa canada uk australia without prescription nextday shipping
Pingback: danh de online uy tin
Pingback: gomovies-online
Pingback: con cho so may
Pingback: bitcoin evolution review
Pingback: UNIQCC
Pingback: is blazing trader a scam?
Pingback: Making Money Online
Pingback: Hotels in San Diego
Pingback: buy/order Tangie OG Cannabis Oil online use for pain, anxiety, sleep for sale near me bulk in usa uk nz canada australia overnight delivery
Pingback: eatverts
Pingback: More Help
Pingback: thenaturalpenguin
Pingback: buy roxicodone 5 mg for sale overnight delivery cheap
Pingback: pinewswire
Pingback: English bulldog puppies for sale near me in MN MD CT NJ AZ AK LA WV ND IW NC NB WA NV MI
Pingback: bitcoin loophole
Pingback: Immediate Edge Review 2020
Pingback: ریور پوکر
Pingback: mơ thấy anh em gặp nhau
Pingback: mơ thấy con mèo đánh con gì
Pingback: mơ thấy xe tải
Pingback: mơ mình chết đánh con gì
Pingback: Pinball Machines for Sale
Pingback: labradoodle puppies for sale near me
Pingback: nằm mơ thấy mình bay lơ lửng
Pingback: interqq
Pingback: mo ran can
Pingback: nằm mơ thấy sập nhà
Pingback: Earn Fast Cash Now
Pingback: mơ thấy bị bắn
Pingback: mơ thấy cóc đánh con gì
Pingback: XFINITY Store by Comcast
Pingback: DevOps Consulting Services
Pingback: nằm mơ thấy chó đẻ con
Pingback: nằm mơ thấy mẹ bị bệnh
Pingback: mơ thấy người nổi tiếng
Pingback: dơi bay vào nhà tốt hay xấu
Pingback: mơ thấy xe máy đánh con gì
Pingback: nhân mã nam và nhân mã nữ
Pingback: con số may mắn của ma kết
Pingback: cung song tử hợp với cung nào nhất
Pingback: quả mít là số mấy
Pingback: mơ thấy xương người
Pingback: mơ thấy ác mộng
Pingback: nằm mơ thấy chạy xe đạp
Pingback: mơ thấy người yêu cũ chết
Pingback: buy cialis overnight
Pingback: buy levitra 20mg
Pingback: cialis lethargy
Pingback: viagra women
Pingback: order cialis 20 mg
Pingback: online pharmacy no prescription
Pingback: pharmacy
Pingback: canadian online pharmacies legitimate by aarp
Pingback: erection pills
Pingback: viagra
Pingback: cialis canadian pharmacy
Pingback: viagra cialis combo
Pingback: monthly cost of cialis without insurance
Pingback: cialis buy online
Pingback: buy cialis united kingdom
Pingback: cialis payment with paypal
Pingback: buy cialis shipping canada
Pingback: cialis 5mg tablet
Pingback: cialis brand no prescription 365
Pingback: viagra pills cheap
Pingback: canada cialis online
Pingback: buy cialis tadalafil0 with pay pal
Pingback: cheap generic cialis
Pingback: cialis online without prescription
Pingback: ngecjhph
Pingback: where can i buy kamagra
Pingback: wanneer werkt viagra niet
Pingback: what can zithromax treat
Pingback: buy cialis online in canada
Pingback: cialis e ipertrofia prostatica
Pingback: cialis
Pingback: monthly cost of cialis without insurance
Pingback: canadian viagra
Pingback: cialis 5mg tablet
Pingback: comprar viagra online espaГ±a
Pingback: ordering cialis online australia
Pingback: custom essay writing service uk
Pingback: cialis tadalafil portugal
Pingback: custom research paper writing services
Pingback: what should i write about in my college essay
Pingback: i need help with my college essay
Pingback: business ethics essay thesis statement
Pingback: monthly cost of cialis without insurance
Pingback: antibiotics augmentin
Pingback: lasix 500 mg tab
Pingback: canadian pharmacy azithromycin buy online
Pingback: stromectol pill price
Pingback: 2.5 albuterol
Pingback: prednisolone 5mg uses
Pingback: hcg and clomid
Pingback: buying dapoxetine
Pingback: diflucan thrush
Pingback: synthroid com
Pingback: writing your thesis
Pingback: propecia package insert
Pingback: neurontin 400 mg
Pingback: metformin function
Pingback: paxil 40 mg
Pingback: plaquenil covid 19
Pingback: buy metformin without prescription cheap
Pingback: buy generic propecia
Pingback: buy cialis philippines
Pingback: mens erection pills
Pingback: find cheap cialis online
Pingback: online pharmacy pain
Pingback: Zakhar Berkut hd
Pingback: sure save pharmacy
Pingback: 4569987
Pingback: buy cialis tadalafil0 with pay pal
Pingback: buy cialis online generic
Pingback: 20 mg cost
Pingback: buy cialis online overnight
Pingback: news news news
Pingback: online cash advance downey
Pingback: psy
Pingback: psy2022
Pingback: projectio-freid
Pingback: cialis denavir yasmin retin a
Pingback: http://tinderentrar.com
Pingback: payday cash advance hendersonville
Pingback: kinoteatrzarya.ru
Pingback: topvideos
Pingback: video
Pingback: walgreen viagra
Pingback: buy toronto
Pingback: zestril 5 mg prices
Pingback: afisha-kinoteatrov.ru
Pingback: Ukrainskie-serialy
Pingback: site
Pingback: where can i get cialis over the counter
Pingback: plenty of fish free dating sign in
Pingback: too much cialis
Pingback: viagra and cialis discount
Pingback: buy real ativan online
Pingback: top
Pingback: viagra vs cialis vs levitra cost
Pingback: good canadian pharmacies
Pingback: cialis or levitra
Pingback: buy cialis 36 hour
Pingback: Aspirin
Pingback: buy cialis philippines
Pingback: buy cheap cialis overnight
Pingback: best canadian pet pharmacy
Pingback: generic cialis daily pricing
Pingback: where can i buy cialis without a prescription
Pingback: can i buy cialis in uk
Pingback: cialis 5mg tablet
Pingback: what are ed drugs
Pingback: tadalafil herbal substitute
Pingback: buy valtrex singapore
Pingback: viagra and alcohol
Pingback: ed remedies
Pingback: black cialis c800
Pingback: 100 mg viagra
Pingback: tadalafil generic usa
Pingback: viagra instructions
Pingback: cialis efectos secundarios
Pingback: sildenafil 50 coupon
Pingback: where can i buy viagra over the counter
Pingback: generic cialis 20mg
Pingback: sildenafil price australia
Pingback: soderzhanki-3-sezon-2021.online
Pingback: chelovek-iz-90-h
Pingback: podolsk-region.ru
Pingback: diclofenac natrium
Pingback: natural pills for ed
Pingback: bender na4alo 2021
Pingback: blogery_i_dorogi
Pingback: blogery_i_dorogi 2 blogery_i_dorogi
Pingback: ed for men
Pingback: stromectol buy
Pingback: generic plaquenil coupon
Pingback: stromectol prices
Pingback: ivermectin for humans
Pingback: ed treatment review
Pingback: chernaya vodova
Pingback: 66181
Pingback: sildenafil cost comparison
Pingback: buy ed drugs online
Pingback: Porno
Pingback: vechernyy urgant
Pingback: ukraine
Pingback: viagra without a doctor prescription
Pingback: A3ixW7AS
Pingback: buy cialis online in canada
Pingback: gidonline-ok-google
Pingback: link
Pingback: KremlinTeam
Pingback: medunitsa.ru
Pingback: kremlin-team.ru
Pingback: psychophysics.ru
Pingback: hydroxychloroquine 90 mg
Pingback: tadalafil cialis bestprice
Pingback: Suicide Squad 2
Pingback: psiholog
Pingback: regcialist.com
Pingback: canadianpharmacymeds
Pingback: eli lilly cialis
Pingback: hizhnyak-07-08-2021
Pingback: viagra alternatives over the counter
Pingback: how to tell if a man is taking viagra
Pingback: zithromax
Pingback: female viagra effects
Pingback: walmart pharmacy bentonville ar store 100
Pingback: zithromax 500mg price in india
Pingback: cheap drugs canada
Pingback: ingrediants in viagra
Pingback: ivermectin uk coronavirus
Pingback: ed pills for sale
Pingback: drugs prices
Pingback: hydroxychloroquine generic
Pingback: cialis 20 mg from united kingdom
Pingback: cialis with dapoxetine or viagra with dapoxetine better
Pingback: prednisone buying
Pingback: atorvastatin pronounce
Pingback: prilosec directions
Pingback: fluoxetine heartburn
Pingback: quetiapine urinary retention
Pingback: zoloft contraindications
Pingback: what effects can happen from drinking alcohol with escitalopram oxalate
Pingback: pills from canada
Pingback: what is the difference between gabapentin and lyrica
Pingback: viagra canada
Pingback: managing cymbalta withdrawal
Pingback: hydrochlorothiazide and diabetes
Pingback: cheapest viagra
Pingback: ivermectin 4 tablets price
Pingback: cheapest generic viagra
Pingback: medicines atorvastatin
Pingback: viagra for sale
Pingback: viagra pills
Pingback: cialis orange pill
Pingback: taking lexapro at night
Pingback: medications online
Pingback: cialis official site
Pingback: cialis pills online
Pingback: official cialis website
Pingback: how to buy cialis
Pingback: cialis 20 mg daily use
Pingback: Duna 2021
Pingback: sildenafil 20mg
Pingback: female viagra
Pingback: how long does cymbalta take to work
Pingback: cost of viagra
Pingback: 1
Pingback: where can i buy cialis pills
Pingback: viagra without a doctor prescription
Pingback: female viagra 2018
Pingback: where can you purchase viagra
Pingback: buy amoxicillin online cheap
Pingback: cialis generic over the counter
Pingback: buy cheap clomid
Pingback: viagra buy online
Pingback: propecia union pharmacy
Pingback: cheap viagra online canadian pharmacy
Pingback: ivermectin iv
Pingback: where to buy cialis pills
Pingback: stromectol ivermectin tablets
Pingback: canada buy prednisone online
Pingback: doxycycline mono
Pingback: vibramycin 100 mg
Pingback: doxycycline without a prescription
Pingback: cialis online
Pingback: sildenafil medication
Pingback: ivermectin corona covid
Pingback: buying viagra from canada
Pingback: cialis australia online shopping
Pingback: discount generic cialis canada
Pingback: buy generic 100mg viagra online
Pingback: stromectol for covid 19
Pingback: stromectol for yeast infection
Pingback: where can i buy viagra or cialis
Pingback: can ivermectin paste be used topically
Pingback: ivermectin pills amazon
Pingback: hydroxychloroquine with zithramax
Pingback: ivermectin cattle pour on
Pingback: get viagra without prescription
Pingback: viagra professional scam
Pingback: viagra toronto headquarters
Pingback: soolantra ivermectin cream 1
Pingback: can i buy ventolin at boots
Pingback: es el mejor viagra natural?
Pingback: buy ivermectin near me
Pingback: ivermectin covid treatment
Pingback: viagra pills what is it
Pingback: natural viagra india
Pingback: ivermectin where to purchase
Pingback: legal to buy prescription drugs from canada
Pingback: tadalafil cost walmart
Pingback: ed meds online canada
Pingback: 20mg cialis
Pingback: ebay cialis
Pingback: how to get prescription drugs without doctor
Pingback: do you need a prescription for zithromax
Pingback: where can i buy a viagra
Pingback: where to buy viagra from in uk
Pingback: buying sildenafil citrate online
Pingback: ed pills online
Pingback: buy sildenafil
Pingback: order lisinopril hctz
Pingback: using dapoxetine
Pingback: cheapest way to get cialis
Pingback: canadian pharmacy generic viagra
Pingback: buy cheap cialis super active
Pingback: tamoxifen brand name
Pingback: does tamoxifen make you tired
Pingback: buying prednisone on line
Pingback: where to buy prednisone 20mg
Pingback: prednisone 20mg tab price
Pingback: ivermectin buy australia
Pingback: ivermectin uk coronavirus
Pingback: ivermectin 10 mg
Pingback: azithromycin otc cvs
Pingback: prescription drugs without doctor approval
Pingback: cat antibiotics without pet prescription
Pingback: viagra alternative
Pingback: clamelle otc
Pingback: viagra buy tesco
Pingback: best ed pills non prescription
Pingback: cleantalkorg2.ru
Pingback: herbal viagra
Pingback: viagra without a doctor
Pingback: 200 mg prednisone daily
Pingback: prednisone canada pharmacy
Pingback: prednisone tablets 2.5 mg
Pingback: purchase viagra online without prescription
Pingback: viagra history
Pingback: natural alternatives to viagra
Pingback: viagra boys
Pingback: ivermectin lotion
Pingback: amoxil USA
Pingback: viagra jokes
Pingback: buying lasix online
Pingback: how does viagra work
Pingback: neurontin 50mg cost
Pingback: play slots online with real money
Pingback: plaquenil sulfate
Pingback: prednisone otc uk
Pingback: viagra alternatives
Pingback: priligy pills
Pingback: buy enunie provigil
Pingback: stromectol medicine
Pingback: ventolin prices
Pingback: zithromax online
Pingback: furosemide cost price
Pingback: roman viagra
Pingback: gabapentin 1500 mg
Pingback: natural viagra recipe
Pingback: plaquenil brand name
Pingback: viagra from canada
Pingback: how to take modafinil
Pingback: stromectol in canada
Pingback: natural viagra for men
Pingback: valtrex generic cheap
Pingback: alternatives to viagra
Pingback: brand viagra
Pingback: cheapest on line valtrex without a prescription
Pingback: roman sildenafil
Pingback: valtrex rx where to buy
Pingback: valtrex where to buy canada
Pingback: generic sildenafil
Pingback: cheap generic drugs from india
Pingback: generic ed pills from canada
Pingback: generic drugs online
Pingback: how to take 20 mg cialis
Pingback: cialis strength levels