Answer / subodh

asp is interpreted where as asp.net is compiled
in asp control events are handled at client side where as in
asp.net the control events are handled server side

Answer / dheeraj

1). com component metadata is saved inside the registry of
windows whereas .net assembly metadata is save inside
menifest.

2). Com components are already compiled into native code .

3). As the metadata is saved inside menifest file inside
the assembly so ite becomes
(A) portable
(B) multiple versions of the assemby can be
saved on the same machine.

Answer / munna

asp is interpreted where as asp.net is compiled
in asp control events are handled at client side where as in
asp.net the control events are handled server side

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  

---

Which DLL file is needed to be registered for ASP?

3 Answers  

---

What is Exception ? When is try, catch block used ?

1 Answers  

---

Juxtapose the HTTP verbs GET and POST. What is HEAD?

0 Answers  

---

which property will make a control span an entire site office parent class

0 Answers  

---

Define a form collection?

0 Answers  

---

Which asp object is often used to retrieve user information from forms?

0 Answers  

---

What is the difference between razor and aspx view engine?

0 Answers  

---

What are private assemblies and shared assemblies?

0 Answers  

---

What is http header?

0 Answers  

---

What is full form of aspx?

0 Answers  

---

Name and explain about the Objects in ASP?

1 Answers  

---