Best Practices Question - Data Access

  • Thread starter Thread starter gb
  • Start date Start date
G

gb

hi,

i'm working on a large project involving numerous tables.
there are instances, that i only need to do a simple select statement
for each table (e.g. select * from table1 or select fld1, fld3 from table1
or
select fld1,fld2 from table2). my question is, do i need to create stored
procedure (SP) for each? because if i do, i will be having a lot of SPs
for a single table alone.

thanks in advance.

--
 
FWIW, stored procedures are also useful as a means of protecting data
from unauthorized access.

Regards,
Jeff
 
Jeff,
As a newbie also, I'm in a position at work, where I need to basically teach myself
EVERYTHING about programming in .NET/SQL 2000.

I've been playing with C# for about 4 months now, and I've seen a few examples of ASP.NET
app's that connect to an SQL 2000 DB using a SP, but I could never 'find' the code to practice
making my own.

Do you have any examples or know of where I can actually 'get' my hands on code to do this.
Obviously, the actual connection string properties would be for the Server(s), UID & P/W's at
work, but with an example, I can practice the implementation thereof without beating my head on
a brick wall every day (though I wonder if sometimes I like doing that..<grin>).

TIA

JPM
 
Andrew,
Thanks! I'll play with that tomorrow at work (kinda nice to be in a position where I have
no deadlines; simply write code at my leisure and do R&D)...:)

JPM
 
Back
Top