Loading

How to Add-Update-Delete Record Using MySQL

Submitted by: 
admin
Thursday, October 29, 2009 - 17:52
Language: 
Visual Basic .NET
Visitors have accessed this post 35877 times.




Yet another sample program that will teach you on how to add, update, delete a record but this time using MySQL database. The sample is based on the previous source code I uploaded here called How to Add-Update-Delete Record with Search Function.

In order to run this program you need to import first the text file contain in the zip file called “northwind.sql” to your MySQL Server. To understand more on the pre-requisite on running this program with MySQL please read Visual Basic and MySQL.

The program based on the previous tutorial using MS Access contains a few modification in order to run using MySQL Database.

Download Code: 
How_to_Add-Update-Delete-Record_using_MySQL.zip
Tags: 
vb.net
tutorial
VB Mysql
admin's picture

Article by admin

admin has submitted source code / articles.

If you like This post, you can follow SourceCodester on Twitter.

Subscribe to SourceCodester feed via RSS or EMAIL to receive instant updates.

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

Submitted by Anonymous on Thu, 10/29/2009 - 22:50

please i have a problem in saving into access database, can you help me with the code to save and retrieve data from the database.

admin's picture

Submitted by admin on Fri, 10/30/2009 - 08:59

What's your problem?

Submitted by Anonymous on Wed, 01/20/2010 - 01:45

till now, i failed to link the RFID reader with VB2008..can you help me to solve this prob

Submitted by Gerlie on Thu, 01/26/2012 - 16:25

Pls... Help me... for my thesis...

Submitted by Anonymous on Fri, 10/30/2009 - 19:14

hi mam. how r u. this is vinu.

pls help me i have doubts in visual basic and send me mail dot net projects.

how create a login form in vb to oracle.

i am studying mca. i want projects for next sem. that why send me a wonder projects

admin's picture

Submitted by admin on Sat, 10/31/2009 - 11:17

First of all...Do I look like a girl? hehehe.

I don't know about Oracle 'coz I'm not using it. But whether you are using MS Access, SQL Server, MySQL the concept is still the same. Look at the tutorial that I have here on how I connect vb.net to MS Access, SQL Server and MySQL with just a few modification on the source code.

Submitted by Anonymous on Thu, 11/12/2009 - 11:58

Hi sir..

Thank you for the tutorial.. It is easy to understand..
Here I'm doing your tutorial in update, delete and view form mysql..
But i got this error at FillListView(lvList, GetData(sSql))..

The explanation from this error i got is Unable to cast object of type 'MySql.Data.MySqlClient.MySqlException' to type 'MySql.Data.MySqlClient.MySqlDataReader'.

I really does'nt understand abt this error..
can you tell me how can i fix this error..

Thank you for advanced!

Jamsky's picture

Submitted by Jamsky on Wed, 11/25/2009 - 16:28

Help naman po, how can i send a text message using vb.net? need ko po code for this. I have a project, a stock and inventory system that have a feature that will automatically send a text message to a cellphone if an item is about to be out of stock. Sakit na po ng ulo ko d2! sana matulungan nyo po ako! thanks!

emond's picture

Submitted by emond on Wed, 11/25/2009 - 16:57

maybe i can help u, please email me

dark_raditz0825@yahoo.com
09212279363

emond sabiniano
System Developer-Software Consultant

Submitted by Anonymous on Sat, 07/17/2010 - 12:58

hi sir, can you help me about my project,? it is a video rental system, i just don't know how to add, edit, search and update datas. what are the right codes for it? pls PM me asap sir. thank you

Submitted by Anonymous on Fri, 10/21/2011 - 16:23

i have created a database for a simple program a system clinic and i make connection bt i can not update even add new records in.....Please send me or help me with a code. my E-mail is: serka16@live.com
my facebook acount: joao lopez, using the same mail.

Submitted by Anonymous on Wed, 12/30/2009 - 12:54

i've problem bro

Could
not load file or assembly 'MySql.Data, Version=5.0.9.0,
Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its
dependencies. The system cannot find the file specified.

what thats mean ?? and what should i do?? please..

ps:
mysql 5.1.30
vb 2008 express edition

Submitted by Anonymous on Sun, 01/10/2010 - 12:49

sir,

please help me with my project. its like the usual game, texttwist, but the the difference is that i will be linking about 4 computers (the 3 are the for the users and the other 1 is for the server). my concern is that i still don't have an idea of how to link one pc to another using visual basic.

or can you recommend what language should we use that you think is easier to use.

please sir. i really need it badly.m5

Submitted by Anonymous on Tue, 01/12/2010 - 01:11

please help me. I'm trying to add a checkbox into the form with the sample tutorial you posted. I already had a column into the database, but I don't know the code so that when you check on that check box it will save into the database.

example:

checkbox1: item one
checkbox2: item two
checkbox3: item three. etc.

in the database column (customer and type of call)
type of call colum:
item one, item two => if they were selected

please help. thank a bunch.

umepinkie's picture

Submitted by umepinkie on Tue, 01/12/2010 - 01:23

I have a problem with adding checkboxes and connect those to the database. Can you help me please. I'm new to the VB world. I know nothing about visual basic. :(

I was trying to add checkboxes with the how to update add program you wrote. What I'm trying to do is add check boxes so that once you checked it, the item you check will be save into the database. For example:

checkbox 1: item 1
checkbox 2: item 2
checkbox 3: item 3

and if I checked checkbox 1 and 2, in the database I want it to save those check as item 1, item2. The items will be separate by a comma. I am in clueless. Please help.

Submitted by Anonymous on Sat, 01/16/2010 - 20:55

please help me i need some source code for the file maintenance in VB.Net using datagrid and Access

here are some file maintenance i need, ADD,DELETE,EDIT,SAVE,and SEARCH.. please help me T_T

Submitted by Anonymous on Sat, 01/16/2010 - 20:57

please help me i need some source code for the file maintenance in VB.Net using datagrid and Access

here are some file maintenance i need, ADD,DELETE,EDIT,SAVE,and SEARCH.. please help me T_T

jaysfall's picture

Submitted by jaysfall on Wed, 01/27/2010 - 23:48

Hhmm..I could help you on dis..You can download my sample file management here...
It might be the answer to your problem.heres the link.
http://www.sourcecodester.com/visual-basic-net/introduction-adonetoledbconnection.html

or
http://www.sourcecodester.com/visual-basic-net/adonet-odbcconnection.html

Consultant / .Net Developer

::jayxceleste@ymail.com::

+639161514777

Submitted by Anonymous on Wed, 01/20/2010 - 01:39

how can i link RFID reader (serial port) to VB 2008..

Submitted by Anonymous on Tue, 01/26/2010 - 06:00

I used your code and had a set the column Log ID for autonumber, but when I run the program it won't let me double click on the listview item to view the entry. it said that the data does not match.

Submitted by Anonymous on Sun, 01/31/2010 - 11:00

hi mr jay i am using your hotel management system but one problem i need access your database first "asscess database"so need password for a ms access database so i can make copy to my sql server my e-mail sunny_us79@yahoo.com

Submitted by Praveenrama on Thu, 02/11/2010 - 17:31

SQL Server 2005 DataBase Exampel
Submitted by Praveenrama on Thu, 02/11/2010 - 14:58.

sir please can you send me the SQL Server Exampel of the Same.
BackEnd :SQL DataBase
FrontEnd :VB.NET

My mail ID is : praveenm_rama@yahoo.co.in

Submitted by Anonymous on Fri, 03/05/2010 - 21:06

What is the Solution in this problem the reference component 'MySql.Data' could not be found

Submitted by Anonymous on Fri, 03/19/2010 - 20:36

You should make sure you import it:
Imports MySQL.Data

If this fails: make suer you have added MySQL as a reference to your project

Submitted by Anonymous on Sat, 03/13/2010 - 01:52

sir please can you send me the SQL Server Exampel of the Same.
BackEnd :SQL DataBase
FrontEnd :VB6
my mail id is sanjayraja2@gmail.com

Submitted by Anonymous on Tue, 03/23/2010 - 04:07

How to customer id is by default when i click on the add cmd button . repaly with code. i used the mysql

Submitted by Anonymous on Mon, 05/03/2010 - 09:00

Deleting a record bring this error:

in this line: strDeleted = ExecNonQuery("DELETE Customers.CustomerID FROM Customers WHERE CustomerID= '%" & CustomerID & "%'")

with this error: Conversion from type 'MySqlException' to type 'Boolean' is not valid.

Submitted by Anonymous on Thu, 05/06/2010 - 01:40

I'm struggling for to generate the reports in vb.net by using crystal report tool. please if you have any possibilities please let me help for solve that problem.

myfacefriends@yahoo.com

regards

Submitted by Anonymous on Sat, 05/29/2010 - 23:54

sir im having problem in importing the sql file.. it says 'unknows customers table in information schema.

by the way im using mysqlfront..

could you help me.
to use this. im preparing for our thesis.. next sem.. and im just a newbie in vb.net..

asap

Submitted by Anonymous on Mon, 06/21/2010 - 20:36

how i can find the step by step procedure of that program??

Submitted by Anonymous on Sat, 07/03/2010 - 23:41

when i run the program it points at the "Call FillList" and shows the error "Could not load file or assembly 'MySql.Data, Version=5.0.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified."

and does this program automatically connects to mysql? because i've already imported the northwind txt file to xampp and still doesn't connect. thanks!

Submitted by peter on Sat, 07/03/2010 - 23:52

when i run the program it points at the "Call FillList" then shows this error "Could not load file or assembly 'MySql.Data, Version=5.0.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified."

and is this program applicable to xampp mysql? because I've already imported the northwind text file and still doesn't work? THANKS!

Submitted by Anonymous on Sun, 08/01/2010 - 23:27

i cant connect the application that i download hir it to the mysql database???? can u help me

Submitted by Anonymous on Mon, 08/02/2010 - 20:07

we can't run the program due to this line:

FillListView(lvList, GetData(sSql)

the error says: Unable to cast object of type 'MySql.Data.MySqlClient.MySqlException' to type 'MySql.Data.MySqlClient.MySqlDataReader'.

what should we do? we don't know what the error means..huhu

kalurky..hehe

can you please explain.. thank you very much.. Godbless..:)

Submitted by Anonymous on Fri, 07/01/2011 - 07:24

try to use TRY and CATCH
paste your code inside in the TRY and

type this CATCH
msgbox(ex.tostring)

Submitted by Anonymous on Tue, 08/03/2010 - 20:56

sir i am bharat suryawanshi
and this my contact no. 9893690811

Submitted by Anonymous on Fri, 11/26/2010 - 02:40

Hi..
I need see your code running, but is imposible because when I started, says this error..
you have idea what is that.
sorry about my english..

error
No se puede convertir un objeto de tipo 'MySql.Data.MySqlClient.MySqlException' al tipo 'MySql.Data.MySqlClient.MySqlDataReader'

Submitted by Anonymous on Tue, 01/04/2011 - 20:02

please i can create update delete while working with wamp server. but i upload the site the update faile to work

please help me my name is Area

Submitted by Anonymous on Sat, 01/22/2011 - 17:45

sir i want to help for my RFID project
please tell me what s the way to interact with hardware and software
means when rifd card swap then how transaction is perform

Submitted by Anonymous on Wed, 03/02/2011 - 21:27

my project name is gold shop inventory so i need a database connectivity using sql server 2005 sir .how to add delete update save commands using sql server 2005.pls help me .

Submitted by Anonymous on Wed, 09/07/2011 - 13:14

how to get information fro rfid and store the data into access as well?

Submitted by Anonymous on Mon, 12/12/2011 - 09:49

Sir when my open the download source code in vb 2008..its only a read only?...tnx..

Submitted by anonymous on Sat, 02/11/2012 - 14:31

still nothing happened after clicking the mysql.data.dll file. i still get the same error.. "Namespace or type specified in the Imports 'Mysql.Data.MysqlClient' doesn't contain any public member or cannot be found. make sure the namespace of the type is defined and contains at least one public member. Make sure the imported element name doesn't use aliases.. "

Pages

Add new comment

More information about text formats

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.