c# - DataGridView 图像列引发参数异常：参数无效

Question

我正在尝试从 MySQL 数据库中加载数据，其中图像也放置在我的表中，但是当表单加载时它给出了异常：

任何帮助，将不胜感激

private void DealSuggestion_Load(object sender, EventArgs e)
{
    try
    {
        status.Items.Add("active");
        status.Items.Add("inactive");
        id.Visible = false;
        label7.Text = "";
        conn.Open();
        MySqlCommand cm = new MySqlCommand();
        string query = "SELECT * from dealSuggestion where Status='inactive' LIMIT 8";
        cm.CommandText = query;
        cm.Connection = conn;
        MySqlDataAdapter da = new MySqlDataAdapter(cm);
        DataTable dt = new DataTable();
        da.Fill(dt);
        dataGridView1.DataSource = dt;
        conn.Close();
    }
    catch (Exception ex)
    {
        MessageBox.Show("Error" + ex);
    }
}

标签： c#mysqlwinforms

Answer 1

DataGridViewImageColumn dgvimgcol = new DataGridViewImageColumn();
看看这个 https://www.c-sharpcorner.com/UploadFile/009464/insert-images-into-datagridview-in-windows-application-using/

datagridview 中的列被视为字符串，因此您需要创建一个 imagecolumn 而不是绑定它