Hi,
I have been using Datasource to populate my Datagridview.
Can any one give me an idea how can i change the header of my Datadagridview base on my code below.
Thanks in advance
I have been using Datasource to populate my Datagridview.
Can any one give me an idea how can i change the header of my Datadagridview base on my code below.
Thanks in advance
VB.NET:
With DataGridView
.ColumnCount = 10
.Columns(0).Name = "Custom Office Code"
.Columns(1).Name = "Registry Number"
.Columns(2).Name = "BL Number"
.Columns(3).Name = "Container ID"
.Columns(4).Name = "Container Type"
.Columns(5).Name = "Empty Full Indicator"
.Columns(6).Name = "Marks Seal No 1"
.Columns(7).Name = "Marks Seal No 2"
.Columns(8).Name = "Marks Seal No 3"
.Columns(9).Name = "Sealing Party Code"
End With
Dim con As New SqlConnection(SQLConn)
Try
con.Open()
Dim cmd As SqlCommand = con.CreateCommand
cmd.CommandText = "Select * from CTN"
cmd.CommandType = CommandType.Text
Dim dr As SqlDataReader = cmd.ExecuteReader
Dim dt As New DataTable
dt.Load(dr)
DataGridView.DataSource = dt
Catch ex As Exception
Finally
If con IsNot Nothing Then
con.Close()
con.Dispose()
End If
End Try