Roland,

This statement gets a new row with the same structure as you're already using:

  DataRow row = ds.Tables[0].NewRow()

This statement adds that row to your DataSet:

  ds.Tables[0].Rows.Add(row)

This statement sets your BindingContext position to the new row you just added (note that Cathi corrected my original post, which I knew but had had a brain fart <g> ... it should have been .Count - 1):

  BindingContext(ds, "Listing").Position = ds.Tables[0].Rows.Count - 1

~~Bonnie




>Hi Bonnie,
>
>How does the new row get added to the end of the real dataset; table?
>
>I do not understand the following line. Where does it get the position?
>
>

>BindingContext(ds, "Listing").Position = ds.Tables[0].Rows.Count
>

>
>Thanks
>Roland
>==========================================================================
>>Roland,
>>
>>I think it's been mentioned here before that it's better to add a row with the Table's NewRow() method than with the BindingContext's AddNew() method. So, you'd do something like this (remember, I use C#, so my VB syntax may be slightly off):
>>
>>

>>  DataRow row = ds.Tables[0].NewRow()
>>  ds.Tables[0].Rows.Add(row)
>>  BindingContext(ds, "Listing").Position = ds.Tables[0].Rows.Count
>>

>>
>>~~Bonnie
>>
>>
>>>Hi,
>>>
>>>When the following code is executed I get an error message:
>>>
>>>There is no row at position.
>>>
>>> 'Add a New Record
>>> Me.Pending01_DS1.Listing.Clear()
>>> Me.BindingContext(Pending01_DS1, "Listing").AddNew()
>>>
>>> ' Defaults for New Listing in Table
>>> Dim iAddCurrRow As Integer
>>> iAddCurrRow = Me.BindingContext.Pending01_DS1, "Listing").Position
>>> Me.Pending01_DS1.Tables("Listing").Rows(iAddCurrRow).Item("DateInsert") = Now
>>>
>>>Where is the row I just added with AddNew command?
>>>
>>>What do I need to do to correct this error?
>>>
>>>Thanks
>>>Roland