CollectionView, AutoIncrement and Source Changes

Hi all,

I'm creating a C#/WPF application. I use SQL Server 2008 on the
backend. I use a SqlDataAdapter to fill a DataTable. The DataTable is
used as the source for a CollectionView:

// CollectionView CV =
(CollectionView)CollectionViewSource.GetDefaultView(myDataTable)

Problem: if I add a new record to the DataTable/CollectionView, I do
not see the value of the id-column (textbox binded to this column is
empty). The column in the DB is an auto-increment column, so it should
have a value, but it's not shown in my c# app.

Secondly, is there an easy way to receive the changed records from the
DB? I do not want to select 6000+ records every time I hit refresh, I
prefer to only add the changed records if possible?

/BR
/Fre