c# - 如何使用C#在MYSQL中插入和检索图像

Question

有没有办法使用 phpMyAdmin 和 XAMPP 在 MySQL 数据库中插入和检索图像(图片本身)？我正在使用 C#。

private void button1_Click(object sender, EventArgs e)
{
    //this button will save my pic from the picturebox to the database
    String strAddress = " Data Source = 127.0.0.1; Initial Catalog= ex; user id = root; password= ''";
    MySqlConnection sqlConn = new MySqlConnection(strAddress);
    MySqlCommand sqlcomm = new MySqlCommand();

    sqlConn.Open();
    sqlcomm.CommandText = "INSERT INTO ta VALUES(" + pictureBox1.Image  + "')";
    sqlcomm.CommandType = CommandType.Text;
    sqlcomm.Connection = sqlConn;
    sqlcomm.ExecuteNonQuery();
    sqlConn.Close();
    MessageBox.Show("RECORD SAVED!", "SAVING", MessageBoxButtons.OK, MessageBoxIcon.Information);
}

private void button2_Click(object sender, EventArgs e)
{
    //this will put an image in the picturebox 
    OpenFileDialog dlg = new OpenFileDialog();
    dlg.Title = "Open Image";
    //dlg.Filter = "bmp files (*.bmp)|*.bmp";
    if (dlg.ShowDialog() == DialogResult.OK)
    {
        pictureBox1.Image = System.Drawing.Image.FromFile(dlg.FileName);
    }
    dlg.Dispose();
}

Answer 1

我认为将图像存储在数据库中不是一个好主意。但是，如果这是您的要求，那么您可以做类似的事情

using (MySqlConnection conn = new MySqlConnection("Your Connection String"))
{
 string myQuery = "SELECT IMAGE FROM SOMETABLE";

    using(MySqlCommand cmd = new MySqlCommand(myQuery, conn))
    {
       conn.Open();
       using(var reader = new cmd.ExecuteReader())
       {
         someVariable = (byte[])reader["IMAGE"];
       }
    }
}

这是假设您的数据库中有一列数据类型为 BLOB。您还需要安装 Install-Package MySql.Data 包