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… 6 5789
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.
.
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
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
.
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******** *******@TK2MSFT NGP10.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
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******** ********@TK2MSF TNGP11.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.
I meant the following model:
Interface <--> Business Rules (= Business Logic <--> DATA ACCESS) <-->
ADO.NET <--> Data Engine.
"Norman Yuan" <no********@Rem oveThis.shaw.ca > wrote in message
news:tIvub.4263 65$6C4.249658@p d7tw1no... 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******** ********@TK2MSF TNGP11.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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 implementation, data
abstraction layer. But because each data adapter in the implementation
layer has a connection object that opens and closes as needed, I found
I got several errors from the Jet engine when there were simultaneous
connections to...
|
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 to whether the current row index of the data grid can be
used directly as the Rows index of the DataTable. This is documented in the
DataGrid Overview.
3. No way to access the default grid table style to make minor changes to
just one column...
|
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 table and 11 sub items with
data about each column.
When a Row in ListView1 is selected the Data in ListVies2 is loaded to show
the correct data. Initially the first row in ListView1 is selected in FormX
load
|
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 but the ByRef
dataset variable is empty after the call to the data access layer. The
class successfully retrieves the data but the ByRef dataset variable is
empty when examined in the Windows form.
I wrote the same code as a C# Windows Form...
|
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 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
| |
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:
Public Form1()
public void SetLabel4Text(string theText)
|
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 SQL statements in the Data Acess Layer to create more secure web service application. The Web service class is also in the Data Access Layer. I need to populates the 4 Dropdown list boxes on the web form from one table. I have Customer table which...
|
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 Oracle DB.
My job is to support the current application and possibly upgrade teh
client app to .Net. I have a few options:
I can rewrite the client desktop application .in Dot Net (FW3.0)
utilizing the same Tux calls or
Write a new desktop...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |