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