I've got a datagridview that is bound to a table "orders" of my db.
There are 5 column: 4 textcolumn and 1 imagecolumn:
code (textcolumn) search (imagecolumn) description (textcolumn) UM
(textcolumn) Qty (textcolumn) Price (textcolumn)
I'd like to put an image into the search column (imagecolumn) that is
the same for all columns i go create.
Now I can view an icon with a red cross inside.
A part of my vb code:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
dg1.DataSource = Nothing
agg_righe()
riempi_righe()
ds_righe.Tables(0).Clear()
'etc
End Sub
Dim ds_righe As New DataSet
Private Sub riempi_righe()
Try
Dim cn As New SqlClient.SqlConnection("Data
Source=(local); User ID=sa; Password=sa; Initial Catalog=Ordini;Packet
Size=4096")
cn.Open()
Dim strSQL As String
strSQL = "SELECT * FROM ROrd"
Dim da As New SqlClient.SqlDataAdapter(strSQL, cn)
da.Fill(ds_righe)
dg1.DataSource = ds_righe.Tables(0)
ds_righe.Tables(0).Clear()
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
Sub agg_righe()
Dim col1 As New DataGridViewTextBoxColumn
With col1
.DataPropertyName = "codart"
.Name = "codice_riga"
.HeaderText = "Cod.Art"
.Width = 120
.SortMode = DataGridViewColumnSortMode.NotSortable
End With
dg1.Columns.Add(col1)
Dim col2 As New DataGridViewImageColumn
With col2
.Name = "ricart_riga"
.HeaderText = ""
.Width = 20
.SortMode = DataGridViewColumnSortMode.NotSortable
End With
dg1.Columns.Add(col2)
Dim col3 As New DataGridViewTextBoxColumn
With col3
.DataPropertyName = "descr"
.Name = "descrizione_riga"
.HeaderText = "Descrizione"
.Width = 250
.SortMode = DataGridViewColumnSortMode.NotSortable
End With
dg1.Columns.Add(col3)
Dim col4 As New MaskedEditColumn
With col4
.DataPropertyName = "um"
.Name = "um_riga"
.HeaderText = "UM"
.Width = 30
.Mask = "99"
.SortMode = DataGridViewColumnSortMode.NotSortable
End With
dg1.Columns.Add(col4)
Dim col5 As New DataGridViewTextBoxColumn
Dim DataGridViewCellStyle2 As
System.Windows.Forms.DataGridViewCellStyle = New
System.Windows.Forms.DataGridViewCellStyle
DataGridViewCellStyle2.Format = "N2"
DataGridViewCellStyle2.NullValue = "0"
col5.DefaultCellStyle = DataGridViewCellStyle2
With col5
.DataPropertyName = "qty"
.Name = "qta_riga"
.HeaderText = "Q.tà"
.Width = 70
.SortMode = DataGridViewColumnSortMode.NotSortable
End With
dg1.Columns.Add(col5)
End Sub
Thanks a lot.
George