Using Datagrid in unbound mode with SQL Server

[Platypus1]

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

[Platypus1]

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

See previous post.

Thanks.