Using Datagrid in unbound mode with SQL Server

I have an application that uses a grid for entering parts a customer has ordered. The part number is loaded into a list box which is used in the grid to select the part number.

The description and price fill in automatically. I have set this up in a form for inserting a record in a database. This part works fine.

What I need is a way to capture the order information from the database into a grid and be able to make changes such as additions,updates, deletion.

I can select the data in but need help with updating, and adding new data. I have read Unbound mode article in the MSDN. If anyone can clarify using a database instead of an array for this it would be a great help.

Specifically setting and retrieving the bookmark as the primary key field from a table.

If there is a better way please explain.

Thanks.

Hi, you should have by now found out that DataGrid doesnt support UNBOUND MODE. So, instead try using Dbgrid. As for the solution u asked for could you be specific if u want to use only DataGrid or not. Please mail me further queries if any. All the best...vijay

What is the best way to set the bookmark as the primary key
from a table?

See previous post.

Thanks.