Loading

How to Add-Update-Delete Record Using MySQL

Submitted by: 
Visitors have accessed this post 77517 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.




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

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

What's your problem?

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

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

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

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.

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

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

maybe i can help u, please email me

[email protected]
09212279363

emond sabiniano
Project Contractor-Developer/Software Consultant

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

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: [email protected]
my facebook acount: joao lopez, using the same mail.

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

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

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

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.

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

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

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

::[email protected]::

+09059769698

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

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.

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 [email protected]

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 : [email protected]

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

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

sir please can you send me the SQL Server Exampel of the Same.
BackEnd :SQL DataBase
FrontEnd :VB6
my mail id is [email protected]

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

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.

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.

[email protected]

regards

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

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

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!

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!

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

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..:)

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

type this CATCH
msgbox(ex.tostring)

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

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'

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

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

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 .

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

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

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.. "

i have many client data store to server in access pls give me code and form

Pls help me

Unable to cast object of type 'MySql.Data.MySqlClient.MySqlException' to type 'MySql.Data.MySqlClient.MySqlDataReader'. pls help me

"Unable to cast object of type 'MySql.Data.MySqlClient.MySqlException' to type 'MySql.Data.MySqlClient.MySqlDataReader'." Either provide some guidance or take down the program.

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

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.
  • Lines and paragraphs break automatically.