在C#中读取MySql中的特定行

using MySql.Data.MySqlClient;

public class Program
{
    static void Main(string[] args)
    {
        string connectionString = "server=localhost;database=mydatabase;uid=username;pwd=password;";
        
        using (MySqlConnection connection = new MySqlConnection(connectionString))
        {
            connection.Open();
            
            string query = "SELECT * FROM mytable WHERE id = @id";
            
            MySqlCommand command = new MySqlCommand(query, connection);
            command.Parameters.AddWithValue("@id", 1); // 替换为要查询的特定行的ID
            
            using (MySqlDataReader reader = command.ExecuteReader())
            {
                while (reader.Read())
                {
                    // 读取特定行的数据
                    int id = reader.GetInt32("id");
                    string name = reader.GetString("name");
                    // 其他列的数据读取
                    
                    // 处理读取到的数据
                    Console.WriteLine($"ID: {id}, Name: {name}");
                }
            }
        }
    }
}