Dynamically populating a datatable in .NET 2.0

[VBRookie]

Hello gurus,

I'm having a little trouble here doing something that should be relatively simple. I'm trying to add rows to a datatable programmatically. Here are my declarations:

Dim dTbl As New DataTable
Dim dRow As New DataRow

'... population code follows ...

If I try to run this I get this error:

BC30390: 'System.Data.DataRow.Protected Sub New(builder As System.Data.DataRowBuilder)' is not accessible in this context because it is 'Protected'.

If I change my decs to this:

Dim dTbl As New DataTable
Dim dRow As DataRow

'... population code follows ...

I get this error:

System.NullReferenceException: Object reference not set to an instance of an object.

So my question is how do I populate a datatable if I can't declare a datarow?

Many Thanks,
- VB Rookie

 

[VBRookie]

Never mind I figured out my own problem ...

I had it declared right the second time but I was not setting the datarow to a value before trying to use it. Here is my corrected code for anyone that might've had this question too:

Protected Function Populate_Commitment() As DataTable
  Dim dTbl As New DataTable
  Dim dRow As DataRow

  dTbl.Columns.Add("CommitText")
  dTbl.Columns.Add("CommitValue")
  dTbl.AcceptChanges()

  dRow = dTbl.NewRow()
  dRow.Item("CommitText") = "a"
  dRow.Item("CommitValue") = "b"
  dTbl.Rows.Add(dRow)
  dTbl.AcceptChanges()
  Return dTbl
 End Function

- VB Rookie