New db application advise

[John]

Hi

I need to write my first vb.net/sql server app and I just need pointers as
to how pros do it. My app is a multi-user apps which needs to refresh from
what other users are adding to the backend sql server db.

My question is;

1. Do I just drag the fields on to a form and let the vs 2008 generate all
code (I understand bindingsource will not automatically show the records
added by other user in this technique?), or

2. Write some sort of stored procedures to return one record or some records
at a time) at a time and assign manually to the form fields, or

3. Do something else?

Thanks

Regards

 

[John]

Thanks Bill. I have ordered your book btw expecting it a couple of days.

My frustration is that even with decades of progress in technology there are
still so many ifs and buts in writing dbs app while db apps have been around
for decades and in my opinion relatively simple piece of software.
Add/edit/delete/report what else is there?

Regards

 

[William \(Bill\) Vaughn]

I agree. The problem is (as I see it), Microsoft tends to build
one-size-fits-all tools in too many situations--often compromising the
technology to accommodate one architecture or another. The code generators
in Visual Studio are (IMHO) designed predominatly for very simple forms over
data applications. No, I'm not convinced that the new wave of entity
framework code generators is any better. Sure, lots of applications have
been created using VB.NET and C# using VS as the development platform.
Developers have learned how to pick and choose among the tools and roll
their own classes when they don't meet their requirements.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[Backwater Geezer]

3. Do something else?

By asking such question you deserved to be retrained as a window
cleaner. Where (and how) did you learn to be a programmer?

MH