Web Forms :: Create A Simple Class Based One Tier Architecture
Mar 20, 2014
I am beginner in asp.net / vb.net and I developed a web application for inventory management. here I have my insertion procedure that I entered in my code behind all the different page of my application. My problem is the following:
* I would like to put my procedure in a class that I will call on my different page * how to create this class * how to call this class on my pages
here is my procedure:
Private Sub reqinsertion (ByVal sreq As String)
Dim con As New System.Data.Odbc.OdbcConnection ("Dsn = dshealthboard")
Sun ocommand As System.Data.Odbc.OdbcCommand
con.Open ()
ocommand = New System.Data.Odbc.OdbcCommand (sreq, con)
ocommand.ExecuteNonQuery ()
con.Close ()
End Sub
View 1 Replies
Similar Messages:
Oct 30, 2012
How to create the DAL Layer for the 3tier Architechture
View 1 Replies
Mar 29, 2011
I was tasked to create 3 tier web application. However, i browsed through many books & tutorials. The examples are doing it using Object data source which my lecturers claimed that it is not 3 tier at all. Shouldn't be dragging any data source into deisgn view. Any comprehensive examples for me to take reference from?
View 4 Replies
Sep 16, 2010
structure of 3-tier architrcture
View 7 Replies
Dec 25, 2010
recently i've studied on ADO.NET's Entity Model Framework and say 'wow' as ORM is one of the fevourite pattern i practice..but suddenly i've come to an ambiguous situation when i'm going to start. i usually follow the following 3-tier architecture..
1. UI Layer
2. BLL - business logic layer
3. DAL - Data Access Layer
a. DTO / DAO
b. Gateway (contains the sql query/stored procedure and connection with DB)
now when i'm going to use the Entity Model Design,where the DBML/ .edmx File should be placed? Because many a times i'm using the DBML file as DTO because of the mapped objects.. in the same time, sometimes DBML ( .edmx file in .NET 4.0) contains CRUD methods and stored procedured method as well as methods with different selection operations,- which should be in Gateway. so where the .edmx file should be placed !?!! IN DTO namespace !? or in Gateway namespace!
moreover sometimes there is no need for the BLL which breaks the rules of inter-layer-communication (UI > BLL > DAL.Gateway)! what makes me confuse is, what should be the ideal n-tier architecture when i'll use the ADO.NET Entity Model Design Framework
View 4 Replies
Jul 30, 2010
I am working on 3 tier architecture: UI, BL, DAL. In my UI i have following code for Asynchronous page processing:
[Code]....
But I want a database fetch operation to be performed in this asyncronous method. And due to 3 tier arch. i am unable to do this in UI Layer. Can anyone guide me that how can I implement Asynchronous processing in 3 tier architecture? Note: If you are going to place EndAsyncWork1 in DAL then show that how can I return a value back to UI layer from this function.
[Code]....
View 1 Replies
May 20, 2010
I want to know that What are the factors if we use methods on each .cs page for connection and executing query on each aspx code behind page rather then using BAL .
How our application get affected in terms of performance and speed or other way?
when we put our website on server after publish/compile in general approach (using query in C# code behind) rathor than using stored procedures?
then which logic is better and why ?
View 8 Replies
Mar 25, 2011
've created a simple gridView which lists all products based on category within a dropDownMenu (select * where CatID = dropDownMenu).This works just fine, but is there a simple way to add 'Show All' in the dropDownMenu -
View 5 Replies
Apr 28, 2010
I have implemented the 3-tier architecture project; DAL, BAL, and presentation layer are three layers in it. I am going to implement the following scenario:
Presentation layer calls to a function in the BAL layer which returns 2 string variable, and in turn this function from BAL layer calls to a DAL layer function which also returns 2 string variable. How can I implement the above scenario?
View 2 Replies
May 13, 2010
I'm developing a n-tier architecture... I'm confused with handling exception in the layers... Is it a good practise to add a Exception Layer to the architecture.
View 3 Replies
Jun 12, 2010
I am a newbie to asp.net and work in a firm where the projects are quite small.
I was told by my manager that in a few weeks or so we would be getting a bigger project and I need to be well versed with Design Patterns and N tier arcihtecture.
I would really appreciate if someone could provide me some links and also drop me a few sentences on how this things are useful?
View 4 Replies
Jun 1, 2012
My application was designed using following n-architecture : Presentation layer...wcf service layer...business logic layer..data access layer Presentation layer is in one server,wcf service,bll,dal are in another server. I knew something about wcf but how to implement this architecture.
I am looking for code sample for the above type of architecture.
View 1 Replies
May 7, 2015
I want to use 3 -tier archhitecture in my registration form how to do that in a simple way....
View 1 Replies
Apr 12, 2010
Is it possible to create REST based web service using asmx?
View 1 Replies
Nov 30, 2010
I am trying to use a 3-tier architecture (UI, BAL & DAL) for my project. I have each of the tier in different physical machines.
UI - Machine 1
BAL - Machine 2
DAL - Machine 3
How can DAL & BAL interact? What would be the best way to call one component from another?
View 9 Replies
Aug 18, 2010
i want to develop an application in asp.net using 3 tier architecture .
i know that there are three layers
Data layerBusiness Layer
Data Access LayerBusiness Logic Layer Presentation Layer. I am confused between Data Access Layer and Business Logic Layer.
In data access layer we develop the property classes and main class function which returns datasets, datatables and data reader to Presentation layer.
what is the use of Business Logic Layer ? what actually we do in Business logic Layer
?? we can pass data directly from data access layer to presentation layer ?
View 6 Replies
Feb 5, 2010
i am in the process of creating 3 tier architecture for ASP.net with Microsoft Studio 2005.
My architerture is as below
Presentation Layer Business Logic Layer Data Access Layer
-------------------------- --------------------------- -------------------------------
Form1 BLTable1 DaTable1
(NameSpace = MyCompany.MyProject.BL. BLTable1) (NameSpace = MyCompany.MyProject.DA. DaTable1)
Form2 BLTable2 DaTable2
(NameSpace = MyCompany.MyProject.BL. BLTable2) (NameSpace =
MyCompany.MyProject.DA. DaTable2)
Form3 BLTable3 DaTable3
(NameSpace = MyCompany.MyProject.BL. BLTable3) (NameSpace = MyCompany.MyProject.DA. DaTable3)
I have 2 question here:
(1).MSDN say that we should not have the namespace where its name is same with class name but it does not exlpain why.Does anyone know why? The msdn page is
http://msdn.microsoft.com/en-us/library/893ke618%28VS.71%29.aspx
(2). Business Logic Layer BLTable1 need to interact with Data Access Layer
DaTable1 , so i put the code: imports MyCompany.MyProject.DA. DaTable1 inside
BLTable1, so that i can have access to all the public shared method inside
DaTable1 in BLTable1 for example : DaTable1.Save()
But problem arise when BLTable1 want to use the public shared method in BLTable2 .
I have put the code imports MyCompany.MyProject.BL. BLTable2 inside BLTable1,but i need to
key in the class name twice only can access to the public shared method inside
BLTable2 for example :BLTable2.BLTable2.Save.
View 1 Replies
Feb 19, 2011
some link of some articles for learning N-tier architecture ....
View 5 Replies
Nov 9, 2012
Any good example of Three tier architecture in entity framework 4.0 ...
View 1 Replies
Jan 25, 2011
actually i was developing 3 tier login page application as following :
DAL which containes UsersDS.xsd
in UsersDS.xsd i created one select statement as (SELECT UserID, Name, Password
FROM Users
WHERE (Name = @Name)
in BLL class in have following :
UserBL.cs
[Code]....
Then i created login.aspx (User Interface )
[Code]....
But this did not work , it is just like it's not connecting to DB ..
View 4 Replies
May 24, 2010
i m using GridView through n-tier architecture(BAL,DAL etc). Data binding is fine but problem is that there is no page sorting , edit, delete functions are not coming in smart tag.it comes when m using SqlDataSource connection. The many functions will come.
View 2 Replies
Oct 7, 2010
What is the use of 3-Tier Architecture?
View 6 Replies
Dec 27, 2010
What is tier architecture and MVC for ASP.NET?
View 3 Replies
Mar 10, 2011
I need to run a method before my 90% of the views in my project run. I thought about adding the code to the _ViewStart.cshtml file, but this rule does not apply to all views. If I could subclass the view class then I could base my views on that class.
View 1 Replies
May 31, 2010
can any one tell about 3 tier architecture in asp.net using C#How can i develop a project using 3 tier?
View 8 Replies