Best method of data access...

[Terry Olsen]

Can I bind directly to an .mdb database? Or is using MSDE/SQL better? I am
trying to design a web form that presents a list of Projects & Sites,
displays the current status of each project at each site (each project must
be completed at each site), and allows the assigned person to enter the
planned completion date and then the actual completion date once completed.

Where would I find the best tutorial on how to accomplish something like
this? I have an Access Database with a table containing the sites &
technician assigned. Another table lists the projects. I would like to
present it in an expandable manner (click a '+' by each site name and the
projects for that site are expanded).

I'm a baby when it comes to working with databases. I'm okay with VB...
Thanks!

[Eliyahu Goldin]

Terry,

You don't bind to a database, you typically bind to a data table. You need
to look at ADO.NET to understand how to populate data tables.

It is OK to use Access.

If you want expandable rows, look at 3rd-party controls like WebGrid.Net
from http://www.intersoftpt.com/

Eliyahu

"Terry Olsen" <to******@hotmail.com> wrote in message
news:Oy**************@TK2MSFTNGP11.phx.gbl...

Can I bind directly to an .mdb database? Or is using MSDE/SQL better? I am trying to design a web form that presents a list of Projects & Sites,
displays the current status of each project at each site (each project must be completed at each site), and allows the assigned person to enter the
planned completion date and then the actual completion date once completed.
Where would I find the best tutorial on how to accomplish something like
this? I have an Access Database with a table containing the sites &
technician assigned. Another table lists the projects. I would like to
present it in an expandable manner (click a '+' by each site name and the
projects for that site are expanded).

I'm a baby when it comes to working with databases. I'm okay with VB...
Thanks!