473,324 Members | 2,246 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

asp.net and mssql

Hi Group,
I worked with asp.net v1 and mssql2000 about 1.5 year ago. Since then,
surely, the technology has changed significantly.
I am now working on a small project which will pull out data from mssql2005,
do display, checking and updates records in asp.net 2
I am looking for recommended way for data, business and presentation layers.
Back then, the recommended way was
data: write a bunch of store procedure to retrieve, update records
business: create custom object with methods and properties correcsponding to
fields of table in order to update records
presentation: mostly just call the business object from business layer

Question: what is the new recommendation? is there any links on white papers
so that I can catch up with new development

tia

Peter
Apr 12 '07 #1
6 1414
Sounds about right to me. Unless you want to go WCF.

http://msdn2.microsoft.com/en-us/net.../aa663324.aspx

Might be overkill in your case.
Peter

"L.Peter" <pe***@local.localwrote in message
news:Ow**************@TK2MSFTNGP05.phx.gbl...
Hi Group,
I worked with asp.net v1 and mssql2000 about 1.5 year ago. Since then,
surely, the technology has changed significantly.
I am now working on a small project which will pull out data from
mssql2005,
do display, checking and updates records in asp.net 2
I am looking for recommended way for data, business and presentation
layers.
Back then, the recommended way was
data: write a bunch of store procedure to retrieve, update records
business: create custom object with methods and properties correcsponding
to
fields of table in order to update records
presentation: mostly just call the business object from business layer

Question: what is the new recommendation? is there any links on white
papers
so that I can catch up with new development

tia

Peter


Apr 12 '07 #2
Try this:

6/5/2006
Custom Objects and Tiered Development II // 2.0
http://sholliday.spaces.live.com/blog/

as an example. In the 1.1 version I reference a MS article. I'd read
that
thing 3 or 4 times over.
the one I call from a "birds eye" view or something like that.


"L.Peter" <pe***@local.localwrote in message
news:Ow**************@TK2MSFTNGP05.phx.gbl...
Hi Group,
I worked with asp.net v1 and mssql2000 about 1.5 year ago. Since then,
surely, the technology has changed significantly.
I am now working on a small project which will pull out data from
mssql2005,
do display, checking and updates records in asp.net 2
I am looking for recommended way for data, business and presentation
layers.
Back then, the recommended way was
data: write a bunch of store procedure to retrieve, update records
business: create custom object with methods and properties correcsponding
to
fields of table in order to update records
presentation: mostly just call the business object from business layer

Question: what is the new recommendation? is there any links on white
papers
so that I can catch up with new development

tia

Peter


Apr 12 '07 #3
SAL
This site may be of some help also:
http://www.asp.net/learn/dataaccess/....aspx?tabid=63

S

"L.Peter" <pe***@local.localwrote in message
news:Ow**************@TK2MSFTNGP05.phx.gbl...
Hi Group,
I worked with asp.net v1 and mssql2000 about 1.5 year ago. Since then,
surely, the technology has changed significantly.
I am now working on a small project which will pull out data from
mssql2005,
do display, checking and updates records in asp.net 2
I am looking for recommended way for data, business and presentation
layers.
Back then, the recommended way was
data: write a bunch of store procedure to retrieve, update records
business: create custom object with methods and properties correcsponding
to
fields of table in order to update records
presentation: mostly just call the business object from business layer

Question: what is the new recommendation? is there any links on white
papers
so that I can catch up with new development

tia

Peter


Apr 12 '07 #4
On Apr 12, 10:25 am, "L.Peter" <p...@local.localwrote:
Hi Group,
I worked with asp.net v1 and mssql2000 about 1.5 year ago. Since then,
surely, the technology has changed significantly.
I am now working on a small project which will pull out data from mssql2005,
do display, checking and updates records in asp.net 2
I am looking for recommended way for data, business and presentation layers.
Back then, the recommended way was
data: write a bunch of store procedure to retrieve, update records
business: create custom object with methods and properties correcsponding to
fields of table in order to update records
presentation: mostly just call the business object from business layer

Question: what is the new recommendation? is there any links on white papers
so that I can catch up with new development

tia

Peter
Sorry to hi-jack your thread a little, but its related, and your
question has peaked my interest in a response.

ASP.NET 2.0 can make data related applications really easy thanks to
the DataSource controls (SqlDataSource, AccessDataControls, etc.), and
with a little event code, you can make huge expanses to their default
behaviors. But where does it reach the breaking point where you'd want
to swtich from the simple use of the DataSource controls to a more
"robust" design using something like an MVC architecture with a DAL?

As well, when do you switch from using a SqlDataSource to an
ObjectDataSource? The ODS jsut seems like a huge integration problem
to me.

Thanks.

Apr 12 '07 #5
Hi Evan,
There is no breaking point. I just prefer the model. Actually, the
advantages are we can change datasource (be it mssql, oracle or mysql),
consistant business rules and if clients don't like asp.net then we can swap
to console app, windows or web services. But I have to amit for small
project, it may not worth it.
Thanks
Peter

"Evan M." <em*************@gmail.comwrote in message
news:11**********************@y5g2000hsa.googlegro ups.com...
On Apr 12, 10:25 am, "L.Peter" <p...@local.localwrote:
>Hi Group,
I worked with asp.net v1 and mssql2000 about 1.5 year ago. Since then,
surely, the technology has changed significantly.
I am now working on a small project which will pull out data from
mssql2005,
do display, checking and updates records in asp.net 2
I am looking for recommended way for data, business and presentation
layers.
Back then, the recommended way was
data: write a bunch of store procedure to retrieve, update records
business: create custom object with methods and properties correcsponding
to
fields of table in order to update records
presentation: mostly just call the business object from business layer

Question: what is the new recommendation? is there any links on white
papers
so that I can catch up with new development

tia

Peter

Sorry to hi-jack your thread a little, but its related, and your
question has peaked my interest in a response.

ASP.NET 2.0 can make data related applications really easy thanks to
the DataSource controls (SqlDataSource, AccessDataControls, etc.), and
with a little event code, you can make huge expanses to their default
behaviors. But where does it reach the breaking point where you'd want
to swtich from the simple use of the DataSource controls to a more
"robust" design using something like an MVC architecture with a DAL?

As well, when do you switch from using a SqlDataSource to an
ObjectDataSource? The ODS jsut seems like a huge integration problem
to me.

Thanks.

Apr 13 '07 #6
"Evan M." <em*************@gmail.comwrote in message
news:11**********************@y5g2000hsa.googlegro ups.com...
ASP.NET 2.0 can make data related applications really easy thanks to
the DataSource controls (SqlDataSource, AccessDataControls, etc.), and
with a little event code, you can make huge expanses to their default
behaviors. But where does it reach the breaking point where you'd want
to swtich from the simple use of the DataSource controls to a more
"robust" design using something like an MVC architecture with a DAL?
If, like me, you never go anywhere near the DataSource controls because you
have a very lightweight DAL which can simply be dropped into any project no
matter what type, then you never need to ask yourself this question... :-)
Apr 13 '07 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: badz | last post by:
Hi frenz Lately I try to use MSSQL and PHP , the problem arise when PHP try to read MSSQL field with 'image' data type, header("Content-type: image/jpeg"); // act as a jpg file to browser I...
7
by: mj | last post by:
Hello, thanks for the help. I am running a WinXP Pro w/ SP2 (my home computer, with ZoneAlarm firewall) Apache 2.0.52 MySQL 4.1.7 PHP 5.1.0-dev I have developed a PHP/MySQL web app that...
1
by: JackTorrance | last post by:
Hi i have a problem with IIS6 and MSSQL and i hope that someone can help me. this is the configuration: Windows 2003 IIS6 MSSQL 7.0 Standard Edition ADO 2.5
14
by: Kukurydz | last post by:
I've got such problem: My database is stored on MSSQL Server. I have to write reports for it in MSAccess. I've got a problem with creating a query which will select records from MSSQL table with...
3
by: gharmel | last post by:
I'm trying to get some clues on why I get (much) slower responses from my PHP applications when dealing with a remote sql server as opposed to a local sql server. Here's my situation: Server...
11
by: ralphie | last post by:
hi all since nearly 2 days i fight with mssql and utf-8 as i need to store and retrieve arabic characters. i tried the com approach ...
0
by: DariuszK | last post by:
I am greeting I would like to consult the better solution(with security consideration) to the access is for MSSQL(2005) from ASP(Classic) in the system of the intranet. a) SQL mixed mode and...
8
by: php-taz | last post by:
I built a PHP website on Windows 2000 (using IIS) that connects to a SQL Server 2000 database using the mssql functions. I migrated the website and the database onto a Windows 2003 machine, and...
0
by: Derftics | last post by:
Hi Guys, Is there anyone who have tried installing MSSQL 2000 and MSSQL 2005 servers in one desktop computer? I have tried using MSDE and successfully install the MSSQL 2000 server but when I...
14
by: guswebb | last post by:
Hi. I'm a newbie to PHP and am having a few problems as follows... I have installed PHP successfully on server 1 which is running IIS 6 (W2k3) and hosting multiple sites, some of which connect to...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.