Answer / manoj batra

3-Tier architecture generally contains UI or Presentation
Layer, Business Access Layer (BAL) or Business Logic Layer
and Data Access Layer (DAL).

Presentation Layer (UI)
Presentation layer cotains pages like .aspx or windows form
where data is presented to the user or input is taken from
the user.

Business Access Layer (BAL) or Business Logic Layer
BAL contains business logic, validations or calculations
related with the data, if needed. I will call it Business
Access Layer in my demo.


Data Access Layer (DAL)
DAL contains methods that helps business layer to connect
the data and perform required action, might be returning
data or manipulating data (insert, update, delete etc).

What is Application-scope?

2 Answers  

---

What is asp code?

0 Answers  

---

What is the difference between asp and html? Or why asp is better than html?

0 Answers  

---

How many Max Cookies can we create in Server? A. 10 B. 20 C. 30 D. 40

4 Answers   TCS,

---

What does aspx stand for?

0 Answers  

---

---

How are sessions maintained? A. The browser sends a cookie to the server with each request. B. The browser sends a Querystring variable to the server with each request. C. The browser sends a hidden Form variable to the server with each request. D. The browser sends a long variable to the server in the BODY of each request. E. None of the above.

1 Answers  

---

how can we bind the multiplication of two drop down lists?

0 Answers  

---

Name the event handlers of application object?

0 Answers  

---

using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class Default2 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { SqlConnection cn = new SqlConnection("Data Source =Prg1; Initial Catalog= DBTEST; Integrated Security = True"); cn.Open(); DataSet ds= new DataSet (); string str = "DB_test"; SqlDataAdapter da = new SqlDataAdapter(str, cn); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.CommandText = str; da.Fill(ds); Session["test"] = ds; } protected void btnSubmit_Click(object sender, EventArgs e) { DataSet ds1 = new DataSet(); ds1= (DataSet ) Session ["test"]; DataTable dt = ds1.Tables[0].Clone(); DataRow[] dr; string[] sqlInput = txtNo.Text.Split("-".ToCharArray ()); if (txtNo.Text != "" && txtWeight.Text != "") { if (sqlInput.Length > 1) { string query = ("t1 <=" + sqlInput[0] + " and " + "t2 >=" + sqlInput[1]); dr = ds1.Tables[0].Select(query); } else { string query = ("t1 <=" + txtNo.Text + "and " + "t2 >=" + txtNo.Text); dr = ds1.Tables[0].Select(query); } foreach (DataRow dr1 in dr) { dt.Rows.Add(dr1.ItemArray); } int i = Convert.ToInt32(dt.Rows[0] ["zone"].ToString()); DataTable dt1 = new DataTable(); DataRow[] dr2; dt1 = ds1.Tables[1].Clone(); dr2 = ds1.Tables[1].Select("weight=\'" + txtWeight.Text + "\'"); foreach (DataRow dr3 in dr2) { dt1.Rows.Add(dr3.ItemArray); } DataRow[] dr4; DataTable dt2 = ds1.Tables[2].Clone(); dr4 = ds1.Tables[2].Select(("weight=\'" + txtWeight.Text + "\'")); foreach (DataRow dr5 in dr4) { dt2.Rows.Add(dr5.ItemArray); } int j = Convert.ToInt32(dt.Rows[0] ["days"].ToString()); lbl.Text = dt1.Rows[0][i].ToString(); lbldays.Text = dt2.Rows[0][j].ToString(); } else { } } } ============================================================ ================ CREATE PROCEDURE DB_test AS BEGIN DECLARE @tb1 table ( t1 bigint, t2 bigint, zone bigint, days bigint ) insert into @tb1(t1,t2,zone,days) select (case when(charindex("-",No)-1>0) then convert (bigint,substring(No,1,charindex("-",No)-1)) else No end) as t1, (case when(charindex("-",No)-1>0) then convert(bigint,substring(No,charindex("-",No) +1,len(No))) else No end) as t2, Zone as zone, Days as days from [926] select * from @tb1 select * from zone select * from days end GO

0 Answers  

---

I have all files relating one project in ASP.... I want to make a Localhost for running like website........

2 Answers  

---

What is classic asp application?

0 Answers  

---

Explain how is method overriding different from overloading?

0 Answers  

---