Answer / shubh dasgupta

As said by "Careed" in forums.asp.net..
An ASP.NET Button control in HTML is an HTML input element with a type attribute set to "submit". A submit button in HTML invokes a POST, using the action attribute from the form element, which, for ASP.NET, is the current page. Since this is a POST, the form variables are populated with all of the values from the input elements in the form element, including the value (name) of the submit button. When the POST arrives at the server and is parsed by ASP.NET, it will acknowledge that the POST was initiated by the submit button, which is turned into a Click event for the original ASP.NET Button control.

What is the difference between the value-type variables and reference-type variables

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  

---

What is the purpose of application.lock method?

0 Answers  

---

Define a variable in asp?

0 Answers  

---

What is .asp in html?

0 Answers  

---

---

What is the full name of asp in vb net?

0 Answers  

---

What must be installed on an IIS4 machine to use the CDONTS e-mail server object? A. FTP service B. SMTP service C. IIS administrator D. Exchange Server E. IPX/SPX protocol

1 Answers  

---

What does asp mean in technology?

0 Answers  

---

What does Internet Information Server (IIS) assume to be the default language for Active Server Pages? A. Jscript B. JavaScript C. JAVA D. VBScript E. ECMAScript

2 Answers  

---

What is a Dictionary object?

2 Answers  

---

How many types of cookies are there?

10 Answers   TechSolution, Tops Technologies,

---

Explain how do you initiate a string without escaping each backslash?

0 Answers  

---