Save, Update, Delete, Search in MySQL using C#

Submitted by: 
Language: 
Visitors have accessed this post 19524 times.

This is a small project that is going to show you how to save, update, delete, search in MySQL using C#.

1. Create Database name it as (phonebook).

2. Import file called (phonebook.sql) from your downloaded folder.

3. Now you can open your C# project.

4. Open forms folder and go to loginfrm code and edit the following line with your system details.
edit server, userid, password, database=phonebook;
#############################################################################
# e.g.("SERVER=localhost; USERID=root; PASSWORD=; DATABASE=phonebook;"); #
#############################################################################

5. Open forms folder and go to phonebookfrm code and edit the following line with your system details.
edit server, userid, password, database=phonebook;
#############################################################################
# e.g.("SERVER=localhost; USERID=root; PASSWORD=; DATABASE=phonebook;"); #
#############################################################################

6. Now you can debug system. NB:LOGI DETAILS(username==mzwe, password==1234).

7. If you have any problem contact me on my email address:[email protected] /[email protected]
or Facebook: http://www.facebook.com/mzwenhlanhla.dlamini


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.

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • 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.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.