How to Add-Update-Delete Record with Search Function

Submitted by admin on Tuesday, September 15, 2009 - 19:19.

Language

The source code contain here will teach you on how to search a database with various Fieldname. The sample is based on the previous source code I uploaded here called How to Add/Update/Delete Record using MS Access Database.

I created this because there are still some newbie programmer who wants to learn how searching of database works.

I hope this will help you on some way.

Happy coding!

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

elow

Very nice thanx for teaching us love u gys ur so the best....

how i can delete or add using vb 2008

i can get the exact code using add delete button with ubbound database pls can u teach me some other simple example? tnx in advance

Private Sub

Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click Dim CustomerID As String For Each sItem As ListViewItem In lvList.SelectedItems CustomerID = sItem.Text Next If CustomerID > "" Then 'Delete the selected record Dim strDeleted As Boolean strDeleted = ExecNonQuery("DELETE Customers.CustomerID FROM Customers WHERE CustomerID= '" & CustomerID & "'") If strDeleted = "True" Then MsgBox("Record's deleted.", MsgBoxStyle.Information) Call FillList() Else MsgBox(strDeleted) End If Else MsgBox("Please select record to delete.", MsgBoxStyle.Critical) End If End Sub

database

delete or update the record of ms access(oledb) using dot net platform

hi programmers

i want to learn more about vb 6.0 and also i want to learn the basic of vb.net. my problem is i couldn't find any installer for vn.net.do you have one? can you share it with me?thx madel

You can purchase it or try

You can purchase it or try the Express Editions of Visual studio in the Microsoft website. For Visual Basic ^.0 version you can download it in a torrent site like www.thepiratebay.org. Hope it will help you, Best regards,

re: hi programmers

You can download a trial version of vb.net here: http://www.microsoft.com/downloads/details.aspx?FamilyID=83c3a1ec-ed72-4a79-8961-25635db0192b&displaylang=en

you want to learn vb 6.0

you want to learn vb 6.0 programming language download the ms visual studio 6.0 installer the install it to your PC...meron ako kaso kunin ko pah sa yahoo ko bigay mo lng email add u..send ko lng sau...

Oracle

Dear friend I have good skill in oracle(database).If you need any help about database so,you ask question in my e-mail my e-mail is [email protected] so,i will provide valuable information for you

tnx for the code......!!!

hi all programmers!!!nice to meet you!!! im Bryan..i'm a student...and i am using visual basic in our class........our topic is in the database system using adodc in vb......please help me.!!!!!!!!! jejeje

I just want to help you

if i were you bryan,dont use adodc ..make use of adodb or mysql statement..Adodc kasi mas nkakagulu yan..swear..

I just want to help you

i think you're wrong... madali lng gumamit ng adodc, like this adodc1.connectionstring = yourConnectinstring adodc1.recordsource = SQLstatement adodc1.refresh delcare at runtime

RE:I just want to help you

hihi...adodc makaluma na..ggmit kpa ng adodc control pra mkaconek....khit saan kam form andun ung adodc.hehe..at dka mkapg update delete ung adodc.ggmit k pren tlga nam cmd..tama tama..

RE:I just want to help you

dpende nlng s gumagit yan, gumagamit din ako ng adoddb, pra skin kc mas madali adodc,

haha

hahahaha..^^..pero kasi lhat nam programmer eh d na gumagit nam adodc.d na xa approachble db..^^

your wrong,,,ADODB is much

your wrong,,,ADODB is much better than Adodc..

tnx for the code......!!!

cge mag upload ako ng tutorial ng adodc just w8 lng.

thank

VB.Net

I am Satheesh I am doing a Billing database Software.I have Some Problems In the Database.I am using the Access database.In the form I have 40 textboxes.I wants to Save ,Delete ,Update and Search the Records from the Database.Please send me the code for these Functions.My e-mail ID is "[email protected]"

Add-Update-Delete Record with Search Function and Reports

guys need your help, i want to include crystal report in this program i don't know where to start, thanks in advance.

Good day guys, gusto ko sana

Good day guys, gusto ko sana matuto ng programming. i tried reading from net kaya lang nakaka confuse. panu ko mai run tong update delete add na database? [email protected] thank you

how can i run this database

good day patulong naman po para ma i run tong program. anu kelangan ko para mairun to. thank you

Good Job

thx

thank you for this

VB2010 Coding

I am selva I am doing a dacument control database Software.I have Some Problems In the Database.I am using the Access2007 database.In the vb2010 form I have 40 textboxes.I wants to Save ,Delete ,Update and Search the Records from the Database.Please send me the code for these Functions.My e-mail ID is [email protected]