Best Practices Question - Data Access

[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.

--

[Jeff Louie]

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

Regards,
Jeff

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Benny Mathew]

It is better to have SPs from the security point of view.

Cheers
Benny

gb wrote:

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.

--

[JPM]

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

"Jeff Louie" <je********@yahoo.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

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

Regards,
Jeff

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Andrew]

Look at MSDN at the Data Access Block:

http://msdn.microsoft.com/library/de...ml/daab-rm.asp
"JPM" <So************@Nunya.org> wrote in message
news:uM**************@tk2msftngp13.phx.gbl...

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

"Jeff Louie" <je********@yahoo.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

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

Regards,
Jeff

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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

"Andrew" <a.****@d2k.com.au> wrote in message news:u%***************@TK2MSFTNGP12.phx.gbl...

Look at MSDN at the Data Access Block:

http://msdn.microsoft.com/library/de...ml/daab-rm.asp
"JPM" <So************@Nunya.org> wrote in message
news:uM**************@tk2msftngp13.phx.gbl...

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

"Jeff Louie" <je********@yahoo.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

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

Regards,
Jeff

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!