Hi Bonnie,

I have been busy trying to get my app running.
Thanks for your help!!!!

However I do not understand the ds.Tables[0] part of the code line. Does that mean table index 0 and if so what would be the actual table name?

Something like:

   DataRow row = ds.Tables("Listings").NewRow()

Or do you have to use:

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

Thanks
Roalnd

===========================================================================
>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