VB.NET- SQL (XAMPP) | insert, update, delete, search [CRUD] in Visual Basic Net | with Source Code

hello guys so welcome back what's up channel 10 so this time guys [Music] operation in vive.net gametang mysql database okay so first nothing kagawin database so it was my sql sub hp my admin database so db and then so apat long young number of columns nothing so little gotten again chloe and go then mid first name last name and h then type bar card then again 20 okay then they toss to 30 young length values nothing and data so 11 lang and then an mid kailanga nothing a primary key then go to increment okay and then save okay so natalya database so my apartment column so m id first name last name and h so next nothing form and then little solution explorer nothing so those are references database so [Music] [Music] okay okay so success young bug install nothing and then it was a form okay then next textbox okay so young amit kuna plug ins is gonna so free langito guys okay then duplicate and then data so placeholder again employee id then first name last name then peach okay so palette color [Music] okay so next time grid view okay then button create then [Music] the next btn update then update then ito is delayed and btn delete retina okay so click nothing on okay then let us a little bit view nothing so click then edit column then click on add okay so little employee id then first name last name h okay so then click nothing employee so detos data property name parameters please [Music] first name then last name then h okay okay data grid view okay so data on [Music] and then first name last name then h okay so next nothing says meru natalya form so information foreign size 15. okay so next little solution explorer now then [Music] then module then crowd db connection okay so dito in import nothing yo mysql okay so import mysql.data that sql client okay the next smart timer database connection so public function stay our connection as mysql connection then return new mysql connection database connection nothing so first server equals localhost and user id equals root so rootland guys as default then password so empty long and password and then next database so young database name nothing okay so again guys the next public str con as my sql connection requires str connection okay then public [Music] okay so public same d as new mysql command then public be as new mysql data adapter and public dt as new data table or insert function okay so public sub 38 then by ball sqlr string then try so stay arc on that open and we cmd that connection equals str code then resolve because cmd to be executed [Music] executed in indeed okay so if result equals zero then message box that show field to save the data then error message box that okay then message box i called that information then else message box so successfully or data has been saved in the database then success then nato's uh catch nothing so lucky not in a message box that show ex that message then finally it's the archon so that particles nothing and nothing database connection create function so next function is from database so public sub reload [Music] connection then with cmd and that connection equals str then that command x because sql then they a that then select command dt then message box that show ax dot message and then finally str on that close okay so natalya close connection and then so after a reload it did dispose nothing so that disposed okay so next nothing function so parasa update so public sub updates bible skill as three then try so it don't try catch guys uh a function that is [Music] open [Music] x equals sql then resolve cmd dot execute none query then it check nothing because update and then data has been updated successfully updated successfully okay so data nothing message box show x that message and then so every time number of time open database connections close connection okay so finally is the arc on close so next function is parasa delete function okay so public sub delete by ball skill as string successfully uh retrieving data in the database then data this method is for update record from database but also identifier nothing now it don't function at all update okay then little so this method is for delete record so complete my own functional thing so by the littlest form then little [Music] create so try then create then insert into then employee now so first name that text then last name that text [Music] so so try nothing guys [Music] and then click on create okay so my error tiles so the command takes property has not been properly initialized [Music] x was sql so you're new missing nothing sending a tower okay so try nothing know it okay so enter it area then click on create okay so data has been saved in the database so success nothing okay so then try nothing okay so reload nothing okay so your record that display nasa data grid view nothing then create then reload okay so succession reload nothing so next we update nothing on record so this is a form click nothing on update so try then updates then update employee set first name because first name last then age then the gametime where so very close where mpid it was [Music] [Music] okay so properties then click on events and then ditto delay nothing [Music] click then click chance that cell and zero that value then first name that text was then two then h that x equals then three okay so try nothing guys then click on reload then click nothing data okay so automatic display detosa xbox is nothing okay so try nothing you update you have an error in your syntax okay so miranda your error okay so trying to fix so updates update first name first name last name age where then click on reload okay so update now then [Applause] then 43 then click on update okay so data has been updated successfully okay so data okay so young first name and last name update that's nothing okay so next let us delete um again nothing and function [Music] okay so little where id plus mid dot x then to play nothing and message that show plugin and then try nothing guys okay so click on reload and then click nothing on record then try nothing to delete okay so it has been deleted in database mid that x equals empty and last name that player first name that clear and age that clear okay so try nothing then reload click then but click nothing new so ma clear your record nothing okay so new then well text boxes then create then click new okay so now we're gonna shut it usa text boxes then click on reload so nothing okay so yeah guys and i hope my not to turn okay guys uh tutorial nothing so then young source code you guys are video description nothing so pretty download and don't forget to subscribe my channel subscribe page and thank you guys and get this

Channel: Source Code PH

Views: 28,041

Keywords: learn to code, software engineer, nonprofits, full stack, front end, developer, programmer, javascript, python, web development, technology, math, coding, css, html, web design, machine learning, linux, source code ph, sql, c++, source code

Id: uyaT3ph4-po

Length: 37min 30sec (2250 seconds)

Published: Sun Feb 14 2021