>>>Can you please provide some guidance?
>>>
>>>Thanks in advance.
>>
>>
>>Check out my article on this very subject: http://code-magazine.com/Article.aspx?quickid=0807071. It shows you how to get started and what to do.
>
>Hi John,
>
>Of the page 7 (in printed version) you're saying "With the database structure in place you can create ..." I'm not exactly sure - do we need to have 3 separate datasets for each of my tables (in my database right now I only have Inventory, Orders, OrderDetails) or one DataSet with all 3 of them? Also I'm not sure about dragging. I went to Data Menu in VS, Add new DS and then followed the path by selecting my database and then selecting all three tables.
>
>Am I on the right path here? I'm following your article through.
>
>Thanks again.


I use separate datatables/tableadapters for each object, I don't like datasets with multiple tables. The other thing I will say at this point is to look at SQLCeResultSets...they are a powerful light-weight solution to datatables.