MySqlclient C#（开发人员如何使用）

using MySql.Data.MySqlClient;
using System;

class Program
{
    static async Task Main(string[] args)
    {
        try
        {
            // Define the connection string with MySQL server details
            string connString = "server=myServerAddress;user=myUsername;password=myPassword;database=myDatabase";

            // Create connection object
            using var conn = new MySqlConnection(connString);

            // Open the connection
            await conn.OpenAsync();

            // SQL query to retrieve data
            string sql = "SELECT * FROM myTable";

            // Create MySqlCommand to execute the query
            using var cmd = new MySqlCommand(sql, conn);

            // Execute the command and retrieve data using MySqlDataReader
            using MySqlDataReader reader = await cmd.ExecuteReaderAsync();

            // Loop through the retrieved data and print to console
            while (await reader.ReadAsync())
            {
                string name = reader["Name"].ToString();
                int age = Convert.ToInt32(reader["Age"]);
                Console.WriteLine($"Name: {name}, Age: {age}");
            }
        }
        catch (Exception ex)
        {
            // Print exception message if any error occurs
            Console.WriteLine($"An error occurred: {ex.Message}");
        }
    }
}

Imports MySql.Data.MySqlClient
Imports System

Friend Class Program
	Shared Async Function Main(ByVal args() As String) As Task
		Try
			' Define the connection string with MySQL server details
			Dim connString As String = "server=myServerAddress;user=myUsername;password=myPassword;database=myDatabase"

			' Create connection object
			Dim conn = New MySqlConnection(connString)

			' Open the connection
			Await conn.OpenAsync()

			' SQL query to retrieve data
			Dim sql As String = "SELECT * FROM myTable"

			' Create MySqlCommand to execute the query
			Dim cmd = New MySqlCommand(sql, conn)

			' Execute the command and retrieve data using MySqlDataReader
			Using reader As MySqlDataReader = Await cmd.ExecuteReaderAsync()
	
				' Loop through the retrieved data and print to console
				Do While Await reader.ReadAsync()
					Dim name As String = reader("Name").ToString()
					Dim age As Integer = Convert.ToInt32(reader("Age"))
					Console.WriteLine($"Name: {name}, Age: {age}")
				Loop
			End Using
		Catch ex As Exception
			' Print exception message if any error occurs
			Console.WriteLine($"An error occurred: {ex.Message}")
		End Try
	End Function
End Class

MySqlConnection conn = new MySqlConnection(connString);

Dim conn As New MySqlConnection(connString)

using MySql.Data.MySqlClient;
using IronPdf;
using System;
using System.Text;
using System.Threading.Tasks;

class Program
{
    static async Task Main(string[] args)
    {
        StringBuilder sb = new StringBuilder();
        var renderer = new ChromePdfRenderer(); // Instantiate Chrome Renderer

        sb.Append("<h1>Dynamic PDF Generated from MySqlClient Data</h1>");

        // MySQL client connection and command setup
        string connString = "server=myServerAddress;user=myUsername;password=myPassword;database=myDatabase";

        using var conn = new MySqlConnection(connString);
        await conn.OpenAsync();

        string sql = "SELECT Name, Age FROM myTable";
        using var cmd = new MySqlCommand(sql, conn);
        using MySqlDataReader reader = await cmd.ExecuteReaderAsync();

        while (await reader.ReadAsync())
        {
            // Retrieve data from the data reader
            string name = reader["Name"].ToString();
            int age = Convert.ToInt32(reader["Age"]);
            // Add data to the PDF
            sb.Append($"<p>Name: {name}, Age: {age}</p>");
        }

        var pdf = renderer.RenderHtmlAsPdf(sb.ToString());
        // Save the PDF document
        pdf.SaveAs("output.pdf");

        // Close the connection when done
        await conn.CloseAsync();
    }
}

Imports MySql.Data.MySqlClient
Imports IronPdf
Imports System
Imports System.Text
Imports System.Threading.Tasks

Friend Class Program
	Shared Async Function Main(ByVal args() As String) As Task
		Dim sb As New StringBuilder()
		Dim renderer = New ChromePdfRenderer() ' Instantiate Chrome Renderer

		sb.Append("<h1>Dynamic PDF Generated from MySqlClient Data</h1>")

		' MySQL client connection and command setup
		Dim connString As String = "server=myServerAddress;user=myUsername;password=myPassword;database=myDatabase"

		Dim conn = New MySqlConnection(connString)
		Await conn.OpenAsync()

		Dim sql As String = "SELECT Name, Age FROM myTable"
		Dim cmd = New MySqlCommand(sql, conn)
		Using reader As MySqlDataReader = Await cmd.ExecuteReaderAsync()
	
			Do While Await reader.ReadAsync()
				' Retrieve data from the data reader
				Dim name As String = reader("Name").ToString()
				Dim age As Integer = Convert.ToInt32(reader("Age"))
				' Add data to the PDF
				sb.Append($"<p>Name: {name}, Age: {age}</p>")
			Loop
	
			Dim pdf = renderer.RenderHtmlAsPdf(sb.ToString())
			' Save the PDF document
			pdf.SaveAs("output.pdf")
	
			' Close the connection when done
			Await conn.CloseAsync()
		End Using
	End Function
End Class