create a data driven site

[cereldine]

Hi, i'm trying to teach myself how to create a data driven site in visual studio 2003 without much luck.

Is anyone aware of any good vb based tutorials that will help me understand better, i'm familiar with visual web developer 2005 (alllbeit beta version about 15 months ago) so just something to help trigger memory.

In mean time i'm struggling with how you get a datagrid to connect and show values in web forms. I would like to use oledbadaptor and generate dataset method i have read about in book, how do i set this up to be used in a website, also i'm using an access db as i have no current access to sqlserver.

Windows method =
oleDbDataAdapter1.fill(mydataSet)

 

[cereldine]

I have managed to work out how to get the columns of my table to show, still not clear on what i have to do to get values within these columns. Ive tried following, any help appreciated.

dim ds as new dataset

if oledbconnection1.state = connectionstate.closed then oledbconnection1.open

daInvoice.fill(ds)
datagrid2.datasource = ds
datagrid2.databind()

 

[Paszt]

With Visual Web Developer 2005 you can populate a DataGridView without typing any code: 2005 makes it really simple

Here are some tutorials, some even in video format:
Building and using a 3-tiered data architecture with ASP.NET 2.0
MSDN Easy to Learn

Also please use the search feature here at this forum: Search VbDotNetForums.com