Hi,

My VB6 application is using datagrid control to display some data, but
once I modified the datagrid either manually or programmtically, the data
never display anything, I check Microsoft website and confirm it is by design, refer to this http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q193094&


So, I do so by coding, but still giving the same problem,
so how do I solve this issue. I want to programmtically
control and display my data in the datagrid. Please kindly
help

Below is my code to setup the datagrid

cnConfirm.Open "File Name=" & App.Path & "\udl\inv_journal_tmp.UDL"
cnConfirm.CursorLocation = adUseClient
rsConfirm.Open "inv_journal.tmp", cnConfirm, adOpenDynamic, dLockOptimistic, adCmdTable

Set DBGrid.DataSource = rsConfirm

With DBGrid
.Columns.Add 0
.Columns.Add 1
.Columns.Add 2
.Columns(0).Width = 2294.929
.Columns(0).caption = "Stock #"
.Columns(1).Width = 4364.788
.Columns(1).caption = "Description"
.Columns(2).Width = 1514.835
.Columns(2).caption = "Quantity"
End With



'To append new record, I do the following recordset, rsConfirm

With rsConfirm
.Field("Plu").Value = "TEST"
end With

'To display, I do the following but it still don't display anything

With DBGrid
.Column(0).FieldName = "Plu"
end With