Winform GridView动态显示图片

我的图片在数据库里面存的是路径。“Images/1.jpg”,数据库里面有3个字段：名字Name，图片Url，数值Num。

 

 private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
        {
            if (dataGridView1.Columns[e.ColumnIndex].Name.Equals("Url"))
            {
                if (e.Value != null)
                {
                    string path = e.Value.ToString();
                   
                        e.Value = GetImage(path);
                        ((DataGridViewImageCell)this.dataGridView1.Rows[e.RowIndex].Cells["Column2"]).Value = e.Value;
                   
                }
            }
           
        }

        public System.Drawing.Image GetImage(string path)
        {
            return System.Drawing.Image.FromFile(@Application.StartupPath + "//" + path);

        }

 

在初始化里面添加图片列

private void Form1_Load(object sender, EventArgs e)
        {
            dataGridView1.DataSource = fmcontext.DC_Res;//数据库数值绑定

            //dataGridView1.Columns[3].Visible = false;//隐藏URL路径那列，会出现问题
            DataGridViewImageColumn column = new DataGridViewImageColumn();
            dataGridView1.Columns.Add(column);
            column.HeaderText = "图片";
            column.Name = "Column2";
            column.ImageLayout = DataGridViewImageCellLayout.Zoom;//使图片自动适应单元格大小
        }

这里有个问题，就是显示出来的是4列，因为我前面是数据库绑定的，如果隐藏掉只读的URL路径，那么在dataGridView1.Columns[e.ColumnIndex].Name.Equals("Url")里面就取不到值了。