Help With Displaying Items...

[Kris Jacyna]

Hey everyone,
I'm not too sure if this is the best room to put this in but..

I am trying to make an app, that uses an SQL Server database to store data. I'll try to explain what i am trying to do. Say the data base has one table with 3 items:

Item ID
Item Title
Item Description

Say there are 10 records in the table, i want to show the top 3 items in text boxes on a form. I have drawn a very quick sketch of what I mean...

The 3 boxes where it says "Item 1" etc, is where i want to show the Item Title. I know how to display the items in a list box or combobox but i want to have them in seperate text boxes. I know this is most probably simple but i would really apprechiate it if some one could head me in the right direction.

Thank in advance,
Kris Jacyna

 

[cjard]

Take a read of the DW2 link in my signature, the section on "Simple Data App" (Ctrl+F and search for simple) - it will give you an idea about how to connect to a database, and show data on a form. The other sections you will read, probably in order, are:

Displaying Data on a Form
Displaying Related Data
Saving Data
Creating a form to Search Data
TableAdapter With Multiple Queries