C# (CSharp) mySqlConnection Examples

Programming Language: C# (CSharp)

Class/Type: mySqlConnection

Examples at hotexamples.com: 4

MySqlConnection is a class provided by the MySql.Data.MySqlClient package in C#. It is used to create a connection to a MySQL database and execute queries against it.

Here's an example of establishing a connection to a MySQL database using the MySqlConnection class:

string connectionString = "Server=localhost;Database=mydatabase;Uid=myusername;Pwd=mypassword;";
MySqlConnection connection = new MySqlConnection(connectionString);
connection.Open();

In this example, we create a connection string that specifies the server, database, username, and password. We then create a MySqlConnection object using the connection string and call the Open method to establish a connection to the database.

Once a connection has been established, we can execute SQL queries against it. Here's an example of executing a simple SELECT statement and iterating over the results:

MySqlCommand command = new MySqlCommand("SELECT id, name FROM customers", connection);
MySqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
    int id = reader.GetInt32(0);
    string name = reader.GetString(1);
    Console.WriteLine("{0}\t{1}", id, name);
}

reader.Close();

In this example, we create a MySqlCommand object that represents our SELECT statement and execute it using the ExecuteReader method. We then loop over the results using the Read method on the MySqlDataReader object and extract the values from each row using the GetInt32 and GetString methods. Overall, the MySqlConnection class is a convenient way to connect to and query MySQL databases in C#.

C# (CSharp) mySqlConnection - 4 examples found. These are the top rated real world C# (CSharp) examples of mySqlConnection extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

Connect(2)

ExecuteQuery(1)

SelectQuery(1)

ValidateConnection(1)

Example #1

Show file

File: appuser_repo.cs Project: vishnudas9/AppoDoc

        // get all users
        public dynamic Get_All_Mob_Users()
        {
            mySqlConnection db = new mySqlConnection();
            var             dt = db.SelectQuery("SELECT * FROM tbl_app_users");

            return(dt);
        }

Example #2

Show file

File: appuser_repo.cs Project: vishnudas9/AppoDoc

        public bool  New_registration(MobUser mob)
        {
            mySqlConnection db = new mySqlConnection();

            bool result = db.ExecuteQuery("INSERT INTO tbl_app_users(au_firstname) VALUES ('" + mob.au_firstname + "')");

            return(result);
        }

Example #3

Show file

        private void btnLoginAgain_Click(object sender, RoutedEventArgs e)
        {
            mySqlConnection mm = new mySqlConnection(txtUserfromSideBar.Text, txtPassfromSideBar.Password);

            mm.Connect();
            ct = mySqlConnection.globalCon;
            if (ct.Ping())
            {
                txtPassfromSideBar.Clear();
                txtUserfromSideBar.Clear();
            }
            RefreshCounters();
        }

Example #4

Show file

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            string u = txtU.Text;
            string p = txtP.Password;

            mySqlConnection msC2 = new mySqlConnection(u, p);

            if (msC2.ValidateConnection())
            {
                msC2.Connect();
                dt = new DashBoard();
                /* dt.Owner = this;*/
                dt.Show();
                Close();
            }
        }