Quick DB maintenance build in VB.Net 2005 1

[bitseeker]

I'm deciding between MS Access and SQL Server Express for a ASP.NET application prototype. One of the last points I'm considering is that Access has built in data maintenance, with the datasheet view. I don't see an equivalent "built in" UI for data maintenance in SQL Server, so I guess I have to build that.

Is it reasonable to assume that simple SQL DB data maintenance forms can be built quickly and easily in VS 2005 VB.Net using mostly wizards? Like literally a few minutes for each table? The books on ASP.NET 2.0 say so, but I'd like to get some cross validation.

Any guidance would be appreciated.

Thanks!

 

[RiverGuy]

What's your definition of "data maintenance"?

 

[ca8msm]

If you have the choice, I'd avoid access as much as possible for any applications!

As for "data maintenance" I assume you mean that you just want to view/edit the data in which case you can use the VS database explorer to do this or you can create you own editable pages (so that your users can edit the data) very simply by dragging and dropping a few controls onto the page (personally, I don't like to but you can if you want).


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[bitseeker]

Ok, thanks.

 

[bitseeker]

Riverguy: Data maintenance = change the content of the rows, as opposed to the definitions of the columns.

 

[chrissie1]

you can make something very quick using the data wizards. And it will take even longer to undo the things that limit you in further development. And this isn't the asp.net forum.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[bitseeker]

Thanks for the info. I'm done with this one.