C# Tutorial

C# Tutorial C# First Application C# Variables C# Data Types C# Operators C# Keywords

C# Control Statement

C# If Statements C# Switch Statements C# for Loop C# While Loop C# do While loop C# Jump Statements C# Function C# functions with out variable

C# Arrays

C# Arrays

C# Function

C# Function call by value C# Call by reference C# Passing array to function C# Multidimensional Arrays C# Jagged Arrays C# Params C# Array Class C# Command Line Arguments

C# Object Class

C# Object and Classes C# Constructors C# Destructor C# this Keyword C# static field C# static class C# Static Constructor C# Structs C# enum C# Properties

C# Inheritance

C# Inheritance C# Multilevel Inheritance C# Aggregation C# Member overloading C# Method Overriding C# Base

C# Polymorphism

C# Polymorphism C# Sealed

C# Abstraction

C# Abstraction C# Interface

C# Namespace

C# Namespace C# Access Modifiers C# Encapsulation

C# Strings

C# String

C# Misc

C# Design Patterns Dictionary in C# Boxing and Unboxing in C# Ref and Out in C# Serialization in C# Dispose and Finalize in C# CONSOLE LOG IN C# Get File extension in C# Insert query in c# Difference Between List and Dictionary in C# Getters and Setters in C# Extension Methods in C# Insert query in c# CONSOLE LOG IN C# Get File extension in C# Random.NextDouble() Method in C# Binary Search in C# Difference between Delegates and Interfaces in C# Double.IsFinite() Method in C# Index Constructor in C# Abstraction in C# Basic OOPS Concepts In C# Queue.CopyTo() Method in C# single.compareto() method in C# C# Throw Exception in Constructor DECODE IN C# file.setlastwritetimeutc() method in C# Convert Object to List in C# convert.ToSByte(string, IFormatProvider) Method in C# C# Declare Delegate in Interface console.TreatControl C As Input property in C# Copying the queue elements to 1-D Array in C# Array.Constrainedcopy() Method in C# C# in and out Char.IsLetterOrDigit() method in C# Debugging in C# decimal.compare() method in C# Difference between Console.Read and Console.Readline in C# Metadata in C# C# Event Handler Example Default Interface Methods in C# Difference between hashtable and dictionary in C# C# program to implement IDisposable Interface Encapsulation in C# SortedList.IndexOfVaalue(Object) Method in C# Hash Maps in C# How to clear text files in C# How to Convert xls to xlsx in C# Foreach loop in C# FIFO in C# How to handle null exception in C# Type.Is Instance Of Type() Method in C# How to add data into MySQL database using C# How to use angular js in ASP net Csharp decimal.compare() method in Csharp Difference between Console.Read and Console.Readline in Csharp How to Implement Interface in Csharp char.IsUpper() Method in C# Index Of Any() Method in C# Quantifiers in C# C# program to Get Extension of a Given File C# Error Logging C# ENCRIPTION Can we create an object for Abstract Class in C# Console.CursorVisible in C# SortedDictionary Implementation in C# C# Hash Table with Examples Setting the Location of the Label in c# Collections in c# Virtual Keyword in C# Reverse of string in C# String and StringBuilder in C# Encapsulation in C# SortedList.IndexOfVaalue(Object) Method in C# Hash Maps in C# How to clear text files in C# How to Convert xls to xlsx in C# Foreach loop in C# FIFO in C# How to handle null exception in C# Type.Is Instance Of Type() Method in C# How to add data into MySQL database using C# How to use angular js in ASP net Csharp decimal.compare() method in Csharp Difference between Console.Read and Console.Readline in Csharp How to Implement Interface in Csharp char.IsUpper() Method in C# Index Of Any() Method in C# Quantifiers in C# C# program to Get Extension of a Given File Difference between ref and out in C# Singleton Class in C# Const And Readonly In Csharp BinaryReader and BinaryWriter in C# C# Attributes C# Delegates DirectoryInfo Class in C# Export and Import Excel Data in C# File Class in C# FileInfo Class in C# How to Cancel Parallel Operations in C#? Maximum Degree of Parallelism in C# Parallel Foreach Loop in C# Parallel Invoke in C# StreamReader and StreamWriter in C# TextReader and TextWriter in C# AsQueryable() in C# Basic Database Operations Using C# C# Anonymous Methods C# Events C# Generics C# Indexers C# Multidimensional Indexers C# Multithreading C# New Features C# Overloading of Indexers Difference between delegates and events in C# Operator overloading in C# Filter table in C# C# Queue with Examples C# Sortedlist With Examples C# Stack with Examples C# Unsafe Code File Handling in C# HashSet in C# with Examples List Implementation in C# SortedSet in C# with Examples C# in Depth Delegates and Events in C# Finally Block in C# How to Split String in C# Loggers in C# Nullable Types in C# REVERSE A STRING IN C# TYPE CASTING IN C# What is Generics in C# ABSTRACT CLASS IN C# Application of pointer in C# Await in c# READONLY AND CONSTANT IN C# Type safe in C# Types of Variables in c# Use of delegates in c# ABSTRACT CLASS IN C# Application of pointer in C# Await in c# READONLY AND CONSTANT IN C# Type safe in C# Types of Variables in c# Use of delegates in c# ABSTRACT CLASS IN C# Application of pointer in C# Await in c# READONLY AND CONSTANT IN C# Type safe in C# Types of Variables in c# Use of delegates in c# Atomic Methods Thread Safety and Race Conditions in C# Parallel LINQ in C# Design Principles in C# Difference Between Struct And Class In C# Difference between Abstraction and Encapsulation in C# Escape Sequence Characters in C# What is IOC in C# Multiple Catch blocks in C# Appdomain in C# Call back methods in C# Change Datetime format in C# Declare String array in C# Default Access Specifier in c# Foreach in LINQ C# How to compare two lists in C# How to Convert String to Datetime in c# How to get only Date from DateTime in C# Ispostback in asp net C# JSON OBJECT IN C# JSON STRINGIFY IN C# LAMBDA FUNCTION IN C# LINQ Lambda Expression in C# Microservices in C# MSIL IN C# Reference parameter in C# Shadowing(Method hiding) in C# Solid principles in C# Static Members in C# Task run in C# Transaction scope in C# Type Conversion in c# Unit of Work in C# Unit Test Cases in c# User Defined Exception in c# Using Keyword in C# Var Keyword in C# What is gac in C#

How to add data into MySQL database using C#
2024-06-03 06:25:05

How to add data into MySQL database using C#

Many small and large enterprises utilize MySQL, a quick and simple RDBMS created, promoted, and maintained by the Swedish business MySQL AB. MySQL is growing in popularity for many solid reasons.

  • An open-source license is included with MySQL's release. So using it doesn't cost you anything.
  • MySQL is a highly strong software on its own. It manages a significant portion of the features included in the priciest and most potent database products.
  • MySQL makes use of the popular SQL data language in its standard version.
  • MySQL is compatible with a wide range of operating systems and programming languages, such as PHP, PERL, C, C++, Java, etc.
  • MySQL operates efficiently and rapidly, even with enormous data sets.
  • PHP is the most popular programming language for web creation, and MySQL gets along well with it.
  • Large databases—tables with at least 50 million rows—can be supported by MySQL. A table's 4GB default file size limit can be increased to a theoretical 8 million terabytes (TB) if your operating system supports it.
  • MySQL is adaptable. Programmers can alter MySQL programming to suit their unique surroundings thanks to the open-source GPL license.

Linking C# to a Database:

To work with a database, you must first establish a connection. The parameters listed below are typically included in the connection to a database.

  1. Database name or Data Source: The name of the database to which a connection must be established before working with more than one database concurrently.  Credentials are required to connect to the database; these are the login and password.
  2. Optional Parameters: You can offer more information about how .NET should connect to the database to handle the data by specifying optional parameters for each type of database.

Note: In this instance, we are using the command prompt to run these instructions. You can view the outcome using Microsoft SQL Server Management Studio.

Process of adding data into a MySQL database using C#

  1. Install MySQL Connector/NET: Use NuGet Package Manager to install the MySQL Connector/NET.
  2. Create a Connection: With the connection parameters—server name, port, database name, username, and password—create a MySqlConnection object.
  3. Open Connection: Use the MySqlConnection object's Open() method to create a connection to the MySQL database.
  4. Create an INSERT statement in SQL: To insert data, create an SQL INSERT statement using the table name and column names specified.
  5. Make an instance of MySqlCommand: Use the SQL INSERT statement and the MySqlConnection object to instantiate a MySqlCommand object.
  6. Include Parameters: To stop SQL injection, add parameters to the MySqlCommand object.
  7. Run a SQL Command: To run the SQL INSERT statement, use the MySqlCommand object's ExecuteNonQuery() method. The number of rows impacted is returned.
  8. Handle Exceptions: Try-catch blocks are used to handle any exceptions that may arise during the procedure.
  9. Close Connection: To terminate the database connection, use the MySqlConnection object's Close() function.

Code:

using MySql.Data.MySqlClient;

using System;

using System.Windows.Forms;

namespace YourNamespace

{

    public partial class MainForm : Form

    {

        public MainForm()

        {

            InitializeComponent(); // Assuming this method initializes your form and its controls

        }

        private void SaveButton_Click(object sender, EventArgs e)

        {

            try

            {

                string connectionString = "Server=localhost;Port=3307;Database=YourDatabase;Uid=root;Pwd=root;";

                string query = "INSERT INTO Students (StudentId, FullName, FatherName, Age, Semester) VALUES (@StudentId, @FullName, @FatherName, @Age, @Semester)";

                using (MySqlConnection connection = new MySqlConnection(connectionString))

                {

                    using (MySqlCommand command = new MySqlCommand(query, connection))

                    {

                        // Add parameters to prevent SQL injection

                        command.Parameters.AddWithValue("@StudentId", studentIdTextBox.Text);

                        command.Parameters.AddWithValue("@FullName", fullNameTextBox.Text);

                        command.Parameters.AddWithValue("@FatherName", fatherNameTextBox.Text);

                        command.Parameters.AddWithValue("@Age", ageTextBox.Text);

                        command.Parameters.AddWithValue("@Semester", semesterTextBox.Text);

                        connection.Open();

                        int rowsAffected = command.ExecuteNonQuery();

                        if (rowsAffected > 0)

                        {

                            MessageBox.Show("Data saved successfully");

                        }

                        else

                        {

                            MessageBox.Show("Failed to save data");

                        }

                    }

                }

            }

            catch (MySqlException ex)

            {

                MessageBox.Show("MySQL Error: " + ex.Message);

            }

            catch (Exception ex)

            {

                MessageBox.Show("Error: " + ex.Message);

            }

        }

    }

}

Applications:

There are many uses for adding data to a MySQL database in different domains that can be achieved with C#. The following are some typical situations in which this feature is used:

  • User Registration in Web Applications: User registration forms frequently call for the safe storage of user information in a MySQL database, including username, email address, and password.
  • Content Management: Web content management systems (CMS) regularly add articles, blog entries, photos, and other content to MySQL databases using administrative interfaces.
  • E-commerce: To manage inventory, sales, and customer accounts, online retailers upload product details, customer orders, and transaction details to MySQL databases.