473,241 Members | 1,448 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,241 software developers and data experts.

What are the benefits and drawbacks of web form and windows form at the layer of Data Access?

Hello

I have employed as a developer in a software company that its team uses
FoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is going to
migrate to VS.NET. There is a project modified that is to upgrade a big,
more than 100,000 lines DOS based program developed by FoxPro 2.x to .NET
platform. The design is as previous and the implementation will be
reprogrammed. As a duty in my job I should find an answer about the
following question:

There seems to be two options in .NET to develop the program: Win Form and
Web Form. The question is if we want to redesign the application as a multi
tire program which front-end is best to choose so that we have less problems
in developing the Data Access tire. Is it better to choose Web Form and use
wrapper classes exist in ASP.NET environment or we can choose to use Win
Form?

There are some facts:

1 - Windows forms have more flexibility in view and effects and users prefer
to have a Windows based interface but it is not a "must to be done" rule.

2 - Our programming team has developed VB and VFP applications and they are
more familiar with VB 6.0 than IIS, ASP and VBScript. The company can hire
some web programmers but prefer not to do it if possible

3 - They are not familiar with XML at all and I am the only person that
knows this technology. It seems I myself should develop the Data Access tire
and I am new in .NET technology but have developed several ADO based ASP
applications

4 - The new application should be able to use different data engines such as
Access, VFP, MS SQL Server and Oracle.

It seems developing a multi tire application using windows forms is highly
dependent on web services and xml communications. Using web forms as a front
end have a little flexibility but at least all data access layer will be in
the server using ADO.NET wrapper classes those are the same as ADO. But it
seems using windows forms means that we should use "Dataset" and ".NET
Framework Data Provider" that is a topic I am new in. Microsoft says either
using web forms or windows forms, there is no difference in data access
layer but I don't feel so. Am I right? What are the benefits and drawbacks
of web form and windows form at the layer of Data Access?

Thanks in advance

Hamed…
Jul 21 '05 #1
6 5659
The use of ADO.net is the same for both cases as .net
disconnects the database and only uses quick hits to get
data and update the data.

As I see it the advantages of web forms are:

Workstation platform independednt. ie easy to install on a
Mac/Win 95/XP workstation.

There is no updating of workstations as all the work is
done on the server and just uses ie/navigator/other to
access the program

The advantages of Windows forms:

Easier to set up events on the forms.

Full control over presentation layer (not all browsers
show controls etc the same)

Nobody needs to learn Java Script to do clever things on
browsers that are not VB script compliant.

Only need one server to set up, ie database server.

Nobody needs to learn IIS/Apache or whatever web server
you use.

Hope this helps
Paul
-----Original Message-----
Hello

I have employed as a developer in a software company that its team usesFoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is going tomigrate to VS.NET. There is a project modified that is to upgrade a big,more than 100,000 lines DOS based program developed by FoxPro 2.x to .NETplatform. The design is as previous and the implementation will bereprogrammed. As a duty in my job I should find an answer about thefollowing question:

There seems to be two options in .NET to develop the program: Win Form andWeb Form. The question is if we want to redesign the application as a multitire program which front-end is best to choose so that we have less problemsin developing the Data Access tire. Is it better to choose Web Form and usewrapper classes exist in ASP.NET environment or we can choose to use WinForm?

There are some facts:

1 - Windows forms have more flexibility in view and effects and users preferto have a Windows based interface but it is not a "must to be done" rule.
2 - Our programming team has developed VB and VFP applications and they aremore familiar with VB 6.0 than IIS, ASP and VBScript. The company can hiresome web programmers but prefer not to do it if possible

3 - They are not familiar with XML at all and I am the only person thatknows this technology. It seems I myself should develop the Data Access tireand I am new in .NET technology but have developed several ADO based ASPapplications

4 - The new application should be able to use different data engines such asAccess, VFP, MS SQL Server and Oracle.

It seems developing a multi tire application using windows forms is highlydependent on web services and xml communications. Using web forms as a frontend have a little flexibility but at least all data access layer will be inthe server using ADO.NET wrapper classes those are the same as ADO. But itseems using windows forms means that we should use "Dataset" and ".NETFramework Data Provider" that is a topic I am new in. Microsoft says eitherusing web forms or windows forms, there is no difference in data accesslayer but I don't feel so. Am I right? What are the benefits and drawbacksof web form and windows form at the layer of Data Access?

Thanks in advance

Hamed.
.

Jul 21 '05 #2
Do you mean that accessing data is exactly the same in web and windows
forms?

"Paul Edwards" <pa**@nospam.go-dcl.co.uk> wrote in message
news:0d****************************@phx.gbl...
The use of ADO.net is the same for both cases as .net
disconnects the database and only uses quick hits to get

Jul 21 '05 #3
Yes mainly.

To use ADO.net you have to copy the data into a datatable
before you change it. Obviously things work slightly
different because the client is disconnected from the web
server but the basis is the same. It is impossible in
ADO.net to open a cursor and change the data directly. You
have to use a select statement to get the data and an
update statement to change it or insert statement to add
new data. Often in a web form you will use a data reader
for memory/speed efficiency that can loop throught the
data only once rather than keep it open in the server.

Paul
-----Original Message-----
Do you mean that accessing data is exactly the same in web and windowsforms?

"Paul Edwards" <pa**@nospam.go-dcl.co.uk> wrote in message
news:0d****************************@phx.gbl...
The use of ADO.net is the same for both cases as .net
disconnects the database and only uses quick hits to get

.

Jul 21 '05 #4
Databinding is 'better' in winforms, but... will be greatly improved in the
next release of .NET.

I have just completed a very large project using WIN FORMS, the data binding
worked VERY WELL, I am now starting an even bigger ( the old version of the
APP is over 250,000 lines of code ) this is all going to be WEBBASED and I
have not gone near the databinding. All the presentation logic is held in
server controls.

Both this app were true n-teir designs.

Steve
"Hamed" <ha***@e-sols.com> wrote in message
news:O5***************@TK2MSFTNGP10.phx.gbl...
Do you mean that accessing data is exactly the same in web and windows
forms?

"Paul Edwards" <pa**@nospam.go-dcl.co.uk> wrote in message
news:0d****************************@phx.gbl...
The use of ADO.net is the same for both cases as .net
disconnects the database and only uses quick hits to get


Jul 21 '05 #5
You are talking about Data Access Tier. It should not be tied to particular
User Interface, web form or win form. That is the whole point of n-tier
approach. Your data access objects query database to get DataSet, or put
data into business object and then hands them out to web/win form to display
(or business layer to be dealt with there). The presentation layer/business
layer passes DataSet/object with changed data in it to your data access
objects to get the changes updated to database. A good data access tier
design does not need to have knowledge of presentation tier, whether it is
web form or win form or mobile accessories...

"Hamed" <ha***@e-sols.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
Hello

I have employed as a developer in a software company that its team uses
FoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is going to
migrate to VS.NET. There is a project modified that is to upgrade a big,
more than 100,000 lines DOS based program developed by FoxPro 2.x to .NET
platform. The design is as previous and the implementation will be
reprogrammed. As a duty in my job I should find an answer about the
following question:

There seems to be two options in .NET to develop the program: Win Form and
Web Form. The question is if we want to redesign the application as a multi tire program which front-end is best to choose so that we have less problems in developing the Data Access tire. Is it better to choose Web Form and use wrapper classes exist in ASP.NET environment or we can choose to use Win
Form?

There are some facts:

1 - Windows forms have more flexibility in view and effects and users prefer to have a Windows based interface but it is not a "must to be done" rule.

2 - Our programming team has developed VB and VFP applications and they are more familiar with VB 6.0 than IIS, ASP and VBScript. The company can hire
some web programmers but prefer not to do it if possible

3 - They are not familiar with XML at all and I am the only person that
knows this technology. It seems I myself should develop the Data Access tire and I am new in .NET technology but have developed several ADO based ASP
applications

4 - The new application should be able to use different data engines such as Access, VFP, MS SQL Server and Oracle.

It seems developing a multi tire application using windows forms is highly
dependent on web services and xml communications. Using web forms as a front end have a little flexibility but at least all data access layer will be in the server using ADO.NET wrapper classes those are the same as ADO. But it
seems using windows forms means that we should use "Dataset" and ".NET
Framework Data Provider" that is a topic I am new in. Microsoft says either using web forms or windows forms, there is no difference in data access
layer but I don't feel so. Am I right? What are the benefits and drawbacks
of web form and windows form at the layer of Data Access?

Thanks in advance

Hamed.

Jul 21 '05 #6
I meant the following model:

Interface <--> Business Rules (= Business Logic <--> DATA ACCESS) <-->
ADO.NET <--> Data Engine.
"Norman Yuan" <no********@RemoveThis.shaw.ca> wrote in message
news:tIvub.426365$6C4.249658@pd7tw1no...
You are talking about Data Access Tier. It should not be tied to particular User Interface, web form or win form. That is the whole point of n-tier
approach. Your data access objects query database to get DataSet, or put
data into business object and then hands them out to web/win form to display (or business layer to be dealt with there). The presentation layer/business layer passes DataSet/object with changed data in it to your data access
objects to get the changes updated to database. A good data access tier
design does not need to have knowledge of presentation tier, whether it is
web form or win form or mobile accessories...

"Hamed" <ha***@e-sols.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
Hello

I have employed as a developer in a software company that its team uses
FoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is going to
migrate to VS.NET. There is a project modified that is to upgrade a big,
more than 100,000 lines DOS based program developed by FoxPro 2.x to ..NET platform. The design is as previous and the implementation will be
reprogrammed. As a duty in my job I should find an answer about the
following question:

There seems to be two options in .NET to develop the program: Win Form and Web Form. The question is if we want to redesign the application as a multi
tire program which front-end is best to choose so that we have less

problems
in developing the Data Access tire. Is it better to choose Web Form and

use
wrapper classes exist in ASP.NET environment or we can choose to use Win
Form?

There are some facts:

1 - Windows forms have more flexibility in view and effects and users

prefer
to have a Windows based interface but it is not a "must to be done" rule.
2 - Our programming team has developed VB and VFP applications and they

are
more familiar with VB 6.0 than IIS, ASP and VBScript. The company can hire some web programmers but prefer not to do it if possible

3 - They are not familiar with XML at all and I am the only person that
knows this technology. It seems I myself should develop the Data Access

tire
and I am new in .NET technology but have developed several ADO based ASP
applications

4 - The new application should be able to use different data engines such as
Access, VFP, MS SQL Server and Oracle.

It seems developing a multi tire application using windows forms is

highly dependent on web services and xml communications. Using web forms as a

front
end have a little flexibility but at least all data access layer will be

in
the server using ADO.NET wrapper classes those are the same as ADO. But it seems using windows forms means that we should use "Dataset" and ".NET
Framework Data Provider" that is a topic I am new in. Microsoft says

either
using web forms or windows forms, there is no difference in data access
layer but I don't feel so. Am I right? What are the benefits and drawbacks of web form and windows form at the layer of Data Access?

Thanks in advance

Hamed.


Jul 21 '05 #7

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

Similar topics

0
by: Andrew Dowding | last post by:
Hi Everybody, I have been looking at problems with my Windows Forms C# application and it's little Jet 4 (Access) database for the last few days. The Windows Forms app implements a facade and...
6
by: Fred Morrison | last post by:
1. No Columns collection. 2. No ability to easily synchronize the underlying DataTable of a DataGrid when a row is deleted in the Grid. Once you sort (via the column headers) all bets are off as...
21
by: StriderBob | last post by:
Situation : FormX is mdi child form containing 2 ListViews ListView1 contains a list of table names and 4 sub items with data about each table. ListView2 contains a list of the columns on each...
1
by: mjhillman | last post by:
I have a web project (ASP.Net/VB.net) with a data access layer class that passes dataset objects to the web form based on a passed SQL query. I tried to reuse this class in a VB.Net Windows form...
12
by: Hamed | last post by:
Hello I have employed as a developer in a software company that its team uses FoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is going to migrate to VS.NET. There is a project...
9
by: tirrell payton | last post by:
Hello, I am trying to manipulate the properties of a form's controls from a class. I dont want to make the form's control public. Attached is a code snippet of what I am trying to accomplish:...
0
by: koonda | last post by:
Hi all, I have a Project due after one week. It is a web service project. I have a Web Form which communicates to the web service and this web service communicates to the database. I have all my...
6
by: BJ | last post by:
I just started this week on a new project. The existing project uses BEA Tuxedo as a second layer service broker. The clients make calls to the Tux services which in turn retrieves data from an...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
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
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...

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.