Using datagrid [Resolved]

[haihems]

Hi,

I get some data from Excel as a data array using the automation. I like to show those data in vb forms by using the datagrid.Shall I do that? If so , how? I need the coding..urgent!!!

Thanks

[Asgorath]

Hi

The DataGrid like its name suggests is designed to display bound data only. But you use it to display unbound manually.

the following code assume you have a datagrid on a form called DataGrid1.

On the form class declaration put this code

Private m_DataTable As New DataTable("MyTableName")
    Private Sub InitData()
        'Set up the DataTable
        m_DataTable = New DataTable("TableName")
        m_DataTable.Columns.Add(New System.Data.DataColumn("Column0"))
        m_DataTable.Columns.Add(New System.Data.DataColumn("Column1"))
        m_DataTable.Columns.Add(New System.Data.DataColumn("Column2"))
 
        'Set up the datagrid control
        DataGrid1.DataSource = m_DataTable
    End Sub
 
    Private Sub AddRow(ByVal sCol0 As String, ByVal sCol1 As String, ByVal sCol2 As String)
 
        Dim NewRow As System.Data.DataRow = m_DataTable.NewRow()
 
        NewRow(0) = sCol0
        NewRow(1) = sCol1
        NewRow(2) = sCol2
 
        m_DataTable.Rows.Add(NewRow)
    End Sub

on the form_load event put this :

InitData()
        AddRow("1", "2", "3")
        AddRow("a", "b", "c")
        AddRow("cat", "dog", "mouse")

You can modify InitData and AddRow to include as many columns as you wish...

Regards
Jorge

[haihems]

Hi Jorge,

Thanks for your reply. Its very useful for me. One more thing, can I validate the user's input in datagrid???

regrads,
haihems.