System.Data.DataRow

A DataRow represents an individual row (or record) in a DataTable.
Each DataRow contains one or more fields which can be accessed through the Item property.

if (objDataRow Is System.DBNull.Value) 
{ 
} 

Creating a DataRow Object

Dim objDataRow As System.Data.DataRow 
objDataRow = objDataTable.NewRow() 

or

Dim objDataRow As New System.Data.DataRow 

Adding a DataRow

objDataTable.Rows.Add(objDataRow) 

Inserting a DataRow

It is also possible to insert rows into any position in a DataTable.

objDataTable.Rows.InsertAt(objDataRow) 

Editing a DataRow

objDataRow.BeginEdit 
objDataRow("Column1") = "NewValue" 
objDataRow.EndEdit 

Adding DataRows

objDataTable.BeginLoadData() 
For iRowNo = 1 To 100 
   objDataRow.Item("Column1") = "Value1" 
   objDataRow.Item("Column2") = "Value2" 
   objDataTable.LoadDataRow(objDataRow) 
Next iRowNo 
objDataTable.EndLoadData() 

Dim objDataRow As System.Data.DataRow 
objDataRow = clsDataSet.mobjDataSet.Tables(sTableName).NewRow 

objDataRow.Item(0) = "some text" 
objDataRow.Item(1) = "some more text" 
objDataRow.Item(2) = "even more text" 

objDataSet.Tables(sTableName).Rows.Add(objDataRow) 

Updating DataRows

Dim objDataRow As New System.Data.DataRow 
For iRowNo = 1 To 100 
   objDataRow = objDataTable.Rows(iRowNo) 
   objDataRow.Item("Column1") = "Value1" 
Next iRowNo 

Alternatively you can refer to the DataRow objects directly.

For iRowNo = 1 To 100 
   objDataTable.Rows(iRowNo)("Column1") = "Value1" 
Next iRowNo 

Deleting a DataRow

Using the Delete method does not actually delere the row from the DataTable but just changes its RowState to Deleted.

objDataTable.Rows(2).Delete 

If you want to permanently remove a DataRow without the chance of getting it back later you can use the Remove method of the Rows collection

objDataTable.Rows.Remove(2) 

RowState Properties

Properties

Methods