Creating new rows in DB, using OdbcCommandBuilder

[simtin]

Hi guys.

I'm using a DataSet, a OdbcDataAdapter, beeing constructed by
pubDA_URL = new OdbcDataAdapter()(
new OdbcCommand("select * from urls where project="
+ id, pubDB)
);
, a OdbcCommandBuilder(default properties) and a DataGrid.

This works marvellous so far - as long as i don't try to add a new row
in the DataGrid. It might be interesting that the id always changes,
depending on the user's selection in my TreeView. Therefore, having
the possibility to tell the DataAdapter that the 'project' value
always should be set to 'id' instead of null before writing data to
the database would be great.
I can't use auto increment here, because 'project' is not url's
primary key, but a foreign key to the projects-table.
Any ideas?

Best regards and hoping for help,
simtin

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---