在Windows应用程序中显示正确的数据gridview视图中的图像 [英] show image in proper column of data gridview in windows application

问题描述

我正在使用vb.net windows应用程序。我正在使用数据源填充我的数据网格视图。我在我的加载事件中写了这样的代码：

  Dim cd As SqlCommandBuilder = New SqlCommandBuilder（adapter）
 adapter = New SqlDataAdapter（select c.cid，c.CompanyName，d.dtId，d.dtName as 
部门，d.dt电话作为电话，d.dtEmail作为电子邮件，d.empimage从CompanyMaster_tbl c 
连接DepartmentMaster_tbl d在c.Cid = d.cId顺序由cid，con.connect）
 dt1 = New DataTable 
 bSource = New BindingSource 
 adapter.Fill（dt1）'填充dt与DB中的信息
 bSource.DataSource = dt1 
 gv.DataSource = bSource 
 gv.Columns（cid）。Visible = False 
 gv.Columns（dtId）。Visible = False 
 Dim img As New DataGridViewImageColumn 
 img.HeaderText =image 
 gv.Columns.Insert（6，img）
  

现在我的gridview显示如下：

i想要在我的 **图像**中显示我的图像** 列它自我...我可以这样做？

解决方案

分配数据源后，您添加列gv.Columns.Insert（6，img）。对于此列数据不在那里。您需要手动将图像添加到此列。

  for（int i = 0; i< gv.Rows.Count ; i ++）
 {
 gv.Rows [i] [image] = gv.Rows [i] [empimage]; 
} 
  

I am working on vb.net windows application..i am populating my data grid view using data source..I wrote code in my load event like this:

Dim cd As SqlCommandBuilder = New SqlCommandBuilder(adapter)
        adapter = New SqlDataAdapter("select c.cid,c.CompanyName,d.dtId,d.dtName as 
Department,d.dtPhone as Phone,d.dtEmail as Email,d.empimage from CompanyMaster_tbl c 
join  DepartmentMaster_tbl d on c.Cid=d.cId order by cid", con.connect)
        dt1 = New DataTable
        bSource = New BindingSource
        adapter.Fill(dt1) 'Filling dt with the information from the DB
        bSource.DataSource = dt1
        gv.DataSource = bSource
        gv.Columns("cid").Visible = False
        gv.Columns("dtId").Visible = False
  Dim img As New DataGridViewImageColumn
        img.HeaderText = "image"
        gv.Columns.Insert(6, img)

now my gridview showing like this:

i want to show my image in my **image** column it self..how i can do that?

解决方案

After assigning the datasource your adding the column "gv.Columns.Insert(6, img)". For this column data is not there. You need to add the images manually to this column.

for(int i = 0; i < gv.Rows.Count; i++)
{
    gv.Rows[i]["image"] =  gv.Rows[i]["empimage"];
}

这篇关于在Windows应用程序中显示正确的数据gridview视图中的图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！