Hi,

I cannot find a complete sample application that demos the proper use of
How to configure the proper # of SQL datadapters and datasets you need with the relationships and the proper setup of ComboBox to retreive and update an Id field using the drop down to select by description with incremental searching using a ComboBox.

Does anyone have a simple Complete WinForm sample application or are there any Complete WinForm Applications that are published that can be downloaded?

Minimium - Complete Sample Application should include at least the following

3 tables ItemId, CatId and SellerId are Primary Keys with AutoIncrement.

ItemsForSale Category Seller(Client)

ItemId CatId SellerId
Catid Descr Name
Descr Address
SellerId Phone -Format (999) 999-9999
Sold

Use SQLDataAdapters and connections

Show Connection, SqlDataAdapters and Dataset(s)

Relation would be: (Or whatever amys it work properly)
ItemsForSale: Catid = Category: CatID
SellerId = Seller(Client); SellerId
Main Menu Form
Command to select ItemsForSale File Maintenance Form

WinForm Screen

MainForm to enter New Items For Sale and maintain the existing itmes

Enter Item ID______ GoSearchButton
AddNewButton EditButton SaveButton DeleteButton
CancelButton (Cancels Add or Edits)

TextBox ItemId
ComboBox ItemsForSale-Catid --> Category-CatId
You could enter CatId or retrieve by CatDescr but
store Catid into database. Incremental search Combobox
TextBox ItemsForSale-Descr
ComboBox ItemsForSale-SellerId --> Seller(Client)-SellerId
You could enter SellerId or retrieve by Name but
store SellerId into database. Incremental search Combobox
TextBox Seller(Client)-Name
TextBox Seller(Client)-Address
TextBox Seller(Client)-Phone

Thanks
Roland