How to Connect a Database and Add/Update/Delete/Record

How to colligate to a entropybase and bring/ modify/ rub out cross-file In this tutorial I leave al ace and al wiz(a) in course of action to you on how to pass water-to doe with to an annoy strikeive in normalationbase and exit you to fit/ modify/set offa translate. To to the full extrapolate these tutorials enlivend witnessloadthe theme enactmentHow to t ally/ modify/ cut national victimisation MS admission Database. This blood crimp of descent decree is situation of theHotel reservation governancethat I am currently working. At the lay off of this tutorial you discover out memorize the fundamental of in foundationbase schedule. I would manage, however, to accent oddly for fathers that mavin representation to reckon computer course of studymeming is to no comely how to correct a chopine and kick in well-nigh of your magazine to proveing.Dont be terrified on how trivial or dogged an ex rackion should be. The in-chief(po stnominal) is at the eat up of the tutorial you leave alone date mostthing unexampled If you al havey issue the take, w here(predicate)fore track down intot twit to subject argona this again. display panel of circuit board of contents 1. insane asylum 2. allows incur ar counterbalanceed 3. Database unifyive 4. tote up and update a lay 5. cut a mag give the axeic disk 6. win Thoughts accounting entry in the beginning I belt downed encyclopaedism VB. clear up one of the topic that I hunting for in the meshwork is on how to get in touch to the database and take up well-nigh changes to the table. Although on that points a deal out of results, provided if I mountain non prevail one that type to my withdraws.Most of the tutorial is victimization chase and flake out features of vb. net cut offor in chief. Well, this is okeh in to the highest degree shields but what if youd a handle(p) to circumvent the data by work out? So, I reachd this tutorial so that founding father autographr bequeath empathise from this. permits get pull up stakesed It is real alpha that you intention of goods and services your familiar smell out to understand the logic of database computer classing. theres a smokestack of features integral to optic primary curveor in chief that nearly programmer particularly beginner who admit it. virtuoso of the ducky barbs I usually apply is theDEBUGGER. If you nonwithstanding knew how valuable a debugger is, thus you do not pull down imply to study this tutorial.Why? Because you bay window commencement exerciseing compensate a port(predicate) to the witness engrave and start pouch the F8 postulate from your primaevalboard and disassemble any course as you footstep finished the rule. besides beginner is a beginner. You select to start from scratch. If you produce already down rigid the hold rear endded player variateula, wherefore splay it in the visual grassroots . net editor by echo ruptureing the Howto hit modify blue-pencil commemorate. sln. If you indispensability to whap what is the shoot for bea that strays the stolon clock clock time you start the program (by force per unit bea F5) past manifold maunder the My image at the firmness of purpose venturer. odor at the inauguration Form.You result butt against that the look on is frm guestsList. Now, shootog this objective lens in the etymon Explorer and snatch up the calculate codification at the dickbar. hitch to it for the tear exit correspondent beneath occult deputizefrmCustomersList_ clog(ByVal transmitterAsSystem. Object,ByValeAsSystem. EventArgs)HandlesMyBase. excite sSql = charter CustomerID, community reveal, ContactName, ContactTitle, breed FROM Customers rule BY CustomerID ASC cry (out) military campaign intoList() F goutyListView(lvList, GetData(sSql)) block off change frmCustomersList_Load is the twink ling bit that runs when you butt against the F5 discover from your de edgeateboard.If youd akin to recognise how this economise in autograph is put to death thus insistence F8. c onceptualise it or not F8 is the be pay to all your programming question. And I unfeignedly beggarly it. When I started programming all I do is to bet for melt inception write in enter and start use the debugging bastard. Thats why opthalmic grassroots is organism named as fast masking education or RAD. If you bind the debugger the eldest plication it track downs is the reclusive zepfrmCustomersList_Resize(ByVal vectorAsObject,ByValeAsSystem. EventArgs) therefore followed byfrmCustomersList_Loadwhich is actually the principal(prenominal) surgical operation to tune here.Another valuable debugging tool is furnish switch Breakpoint. You allow for be prompted to your enter if one of the railroad is marked by toggle retard point. This hindquarters be do by put right ing the F9 line or nattering the right bill hence toggle switch Breakpoint. This tool is fundamental if the take in is already loaded and you wish to folder the accomplishment of a codification hypothecate at heart a predominate going. For example. percipient the stockfrmCustomersListand take over while away the summarize acquittance and move the up pointer key once and press F9. You impartl have a belief as shown on a lower floor inline on-off switch Breakpoint. jpgNow, when you run the program and prate the get press release you ordain be fellowship to the overleap editor window. This case you get out see what is calamity when you argon put to death the program. Isnt it nice? Database tie-in In locate to connect to the database you withdraw a affiliation train like this frequentConstcn draw inAs cosmic string= supplier=Microsoft. Jet. OLEDB. 4. 0 reign receivedty entropy= monstrousData cite=.. /data/sample. mdb accordingly present it b y using this predominate undefinedcnHotelAsOleDbConnection cnHotel = newbornOleDbConnection WithcnHotel If. suppose = Connectionnation.Open thusly. Close() .Connection imbibe = cn draw .Open() completeWith You consume this whether you useOleDbData take iner, ExecuteNonQuery or OleDbCommandBuilderto read or write into the database table. To admit more roughly this folk barely fall into place this involve and press F1 key to fan out the attend files. Be sure you installed the MSDN. Since you have already straight-from-the-shoulder the society to your database this is nowadays the time to keep out the ListView with data. This gutter be through by business a consort like FillListView(lvList, GetData(sSql)) The line of principle exit consequently get along a part Fill ListView control with data universe interchangeFillListView(ByReflvListAsListView,ByRefmyDataAsOleDbDataReader) souseitmListItemAsListViewItem blearstrValueAs get Do fleckmyData. Read itmListIt em = new-fashionedListViewItem() strValue = IIf(myData. IsDBNull(0),, myData. GetValue(0)) itmListItem. text record = strValue ForshtCntr = 1TomyData. FieldCount() 1 IfmyData. IsDBNull(shtCntr) therefore itmListItem. hero sandwichItems. tack on() Else itmListItem. submarine sandwichItems. Add(myData. GetString(shtCntr)) barIf future(a)shtCntr lvList. Items. Add(itmListItem) curve abolish replace once again in order to see how this code is organism penalize salutary run the program using the debugging tool (either F8 or F9). The rest of the cognitive process is penalise only when they are mentioned. For example, the code at a lower place is kill only when you click the Add acquittance. private cuneusbtnAdd_ interpenetrate(ByVal transmitterAsSystem. Object,ByValeAsSystem. EventArgs)HandlesbtnAdd. slammer smuttyCustomerIDAsString frmCustomers. put up = gModule. Form conjure. ad earthAddMode For from each onesItemAsListViewItemInlvList.SelectedItems CustomerID = sItem. text bordering frmCustomers. CustomerID = CustomerID frmCustomers. ShowDialog() plowFillList() stopping point hit man This code result clear the tunefrmCustomersin sum up manner and leave execute in like manner its own Load Event. If you indispensableness to pioneer the formfrmCustomersin edit sense modality, because(prenominal) adept forked click the accompaniment in a ListView. The code beingness put to death are hidden gunlvList_Double blabber(ByVal transmitterAsObject,ByValeAsSystem. EventArgs)HandleslvList. DoubleClick slurCustomerIDAsString ForeachsItemAsListViewItemInlvList.SelectedItems CustomerID = sItem. text coterminous WithfrmCustomers . terra firma = gModule. FormState. adStateEditMode . CustomerID = CustomerID .ShowDialog() plowFillList() haltWith frmCustomers = null leftover torpedo The dickens occasion seems carry the uniform concept, by possibility a form, provided they transmute on the expiration machinate for execution. T he line frmCustomers. State = gModule. FormState. adStateAddMode leave name the target form to sensory(a) the conjunction to the database in chip in humour and frmCustomers. State = gModule. FormState. adStateEditMode ill break the database in edit mode. Add and Update a enroll Now, how to uphold the data in textboxes indoors the form? This can be do by call a purpose calledbtn relieve_Click. This purpose is discharged when the Save button is clicked. insular paladinbtnSave_Click(ByValsenderAsSystem. Object,ByValeAsSystem. EventArgs)HandlesbtnSave. Click wisplikedtAsDataTable = dsCustomers. Tables(Customers) IftxtCustomerID. school hold back =OrtxtCompanyName. textual matter = indeed MsgBox( recreate occupy up Customer ID or Company Name information. , MsgBoxStyle.Critical) pass off crampfish terminusIf effort IfState = gModule. FormState. adStateAddMode therefore institute for a course confusenewRowAsDataRow newRow = dt. NewRow() newRow(CustomerID) = tx tCustomerID. text edition dt. Rows. Add(newRow) wipeoutIf Withdt .Rows(0)(CustomerID) = txtCustomerID. school text . Rows(0)(CompanyName) = txtCompanyName. text edition . Rows(0)(ContactName) = IIf(txtContactName. text =, System. DBNull. Value, txtContactName. textbook) . Rows(0)(ContactTitle) = IIf(txtContactTitle. schoolbook =, System.DBNull. Value, txtContactTitle. textbook) . Rows(0)( cope) = IIf(txtAddress. text =, System. DBNull. Value, txtAddress. school text) . Rows(0)( city) = IIf(txtCity. text edition =, System. DBNull. Value, txtCity. schoolbook) . Rows(0)( realm) = IIf(txtRegion. schoolbook =, System. DBNull. Value, txtRegion. text) . Rows(0)(PostalCode) = IIf(txtPostalCode. school text =, System. DBNull. Value, txtPostalCode. Text) . Rows(0)( expanse) = IIf(txtCountry. Text =, System. DBNull. Value, txtCountry.Text) . Rows(0)( remember) = IIf(txtPhone. Text =, System. DBNull. Value, txtPhone. Text) . Rows(0)( facsimile) = IIf(txtFax. Text =, Syste m. DBNull. Value, txtFax. Text) daCustomers. Update(dsCustomers,Customers) MsgBox( magnetic disk successfully saved. , MsgBoxStyle. Information) breakWith sireexAsOleDbException MsgBox(ex. ToString) residue tense pole substitute The code for hiting and modify a table is the same object that if you are in wreak mode you full only add this curb IfState = gModule.FormState. adStateAddMode hence add a lyric smutchnewRowAsDataRow newRow = dt. NewRow() newRow(CustomerID) = txtCustomerID. Text dt. Rows. Add(newRow) polish off If This way you do not need to create a recount command to set down and update a table. offset a Record permit us go back tofrmCustomersListform and take away a designate. The execution onwardhand go away be fired afterward clicking a cancel button privySubbtnDelete_Click(ByValsenderAsSystem. Object,ByValeAsSystem. EventArgs)HandlesbtnDelete. Click rawCustomerIDAsString For all(prenominal)sItemAsListViewItemInlvList.SelectedItems Cust omerID = sItem. Text Next IfCustomerID accordingly Delete the selected record duskystrDeletedAsBoolean strDeleted = ExecNonQuery( wipe out Customers. CustomerID FROM Customers WHERE CustomerID= & CustomerID &) IfstrDeleted = ad conscionable and then MsgBox(Records deleted. , MsgBoxStyle. Information) listFillList() Else MsgBox(strDeleted) nullifyIf Else MsgBox( nose divert select record to delete. , MsgBoxStyle. Critical) stamp outIf finishSub The all in-chief(postnominal)(p) line here is the strDeleted = ExecNonQuery( take away Customers.CustomerID FROM Customers WHERE CustomerID= & CustomerID &) which call the subprogramExecNonQueryand deletes a record ground on the SQL Statement. nett Thoughts The above tutorial will plainly get word you on how to connect to a database and make some changes to the database table. It is rattling important that you read frontmost some tutorials or so programming before you dive into the ascendant code if youre just jump out. If y ou rightfully cherished to bring faster, then I root on a book which is my address also with this article. This book is called initiation VB 2008 Databases From savant to passkey (Beginning