SQL Select Problem with Visual Studio C# 2003--HELP!

[DoubleShot]

HELP!

I am trying to write a database app with three tables. I have figured out how to connect to my database with oledbconnect. From there I am confused as to how to get a select command to work. I have found plenty of info on selecting data from one table using the SQL QUERY option. I do not want to select from one table. I want to select from two tables, for example:
select tbl1.name, tbl2.address
from table1 tbl1, table2 tbl2
where
tbl1.id = tbl2.id

This should not be so difficult, but it is. I am not certain if I have to do something with the dataset, data-adapter or what. I would like someone out there to give me a step-by-step as to what I need to click-and-or-drag when setting up the connection, dataset, etc. Thanks ahead of time for the expertise!

[scripto]

I will assume that you know how to create the SqlConnection1


dim txt as string
txt = "select tbl1.name, tbl2.address
from table1 tbl1, table2 tbl2
where tbl1.id = tbl2.id"

dim cmd as SqlCommand = SqlConnection1.CreateCommand
cmd.CommandType = CommandType.Text
cmd.CommandText = txt
dim da as SqlDataAdapter = New SqlDataAdapter()
dim ds as DataSet = new DataSet()
da.Fill(ds, "txtResults")

'bind to a datagrid
dgrid.DataSource = ds
dgrig.DataMember = "txtResults"
dgrid.DataBind()

[DoubleShot]

I think I can figure out the SqlConnection, though I am using an Access database. I am also working in C#. But I will try what you have here using VB for C#. I assume it is close to the same.
Thanks

I will assume that you know how to create the SqlConnection1


dim txt as string
txt = "select tbl1.name, tbl2.address
from table1 tbl1, table2 tbl2
where tbl1.id = tbl2.id"

dim cmd as SqlCommand = SqlConnection1.CreateCommand
cmd.CommandType = CommandType.Text
cmd.CommandText = txt
dim da as SqlDataAdapter = New SqlDataAdapter()
dim ds as DataSet = new DataSet()
da.Fill(ds, "txtResults")

'bind to a datagrid
dgrid.DataSource = ds
dgrig.DataMember = "txtResults"
dgrid.DataBind()