Hi, I am new to C# and Visual Studio.
I am trying to make a web page which accesses a database.

All I want to do is have a few textboxes = to data in the DB but I'm flummuxedf by the new Visual Studio 2005.

I tried coding the ADO.NET connection strings myself but it wouldn't work so I decided to use the API to set up the data connection and the dataset.

I want to set Textbox1.Text to a cell in my DataTable called MainTable in my dataset which is called Dataset1.

I was going to try the following:
Textbox1.Text = DataSet1.Tables["TableName"].Rows[1].ItemArray[2].ToString();

However VS 2005 DataSets are Typed and no longer have the .Tables method.

I've read articles such as http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/newdtastvs05.asp
and others like it but none of them solve my problem.

they talk about a data source Tab, I think this only applies to applications and VB as there is no data source tab in my c# VS website api.

I'm flummoxed,
Please advise.
Thanks