Answer / guest

? Flush ? sends previous buffered output to the client
immediately, but continues processing the script.
? Clear ? erases any already-buffered HTML.
? End ? causes the server to stop processing the script.

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  

---

Explain the difference between a namespace and an assembly name?

0 Answers  

---

How do you initialize a two-dimensional array that you don't know the dimensions of?

0 Answers  

---

I have written an assembly that I want to use in more than one application. Where do I deploy it?

0 Answers  

---

Explain what are the attributes of the tags? What are their functions?

0 Answers  

---

---

1)Declare array with five elements a[]={8,4,6,2,1,10} Print minimum and maximum no from array. 2)Accept values from Textbox and add into Listbox on click ok button. 2)Accept these values store them in cookie collection and show them in next form. Assignment 3 20Marks 1) Display EmpId ,EmpName ,EmpSal usind datagrid view (use sqlerver 2005) 2) Insert Item Id, Item Name, Qty, Rate using ado.net(use sqlerver 2005)

5 Answers  

---

Which choice is NOT a property of Dictionary Object? A. Key() B. CompareMode C. Item () D. Exists () E. Count

1 Answers  

---

Using VBScript, which of the following Scripting Object(s) is NOT available from scrrun.dll? A. TextStream B. Dictionary Object C. Err Object D. FileSystemObject E. All are available from scrrun.dll.

1 Answers  

---

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

0 Answers  

---

What are the stored procedures?

0 Answers  

---

difference between html and asp?

0 Answers   Polycom,

---

What is difference between Server.transfer and Response.redirect ?

7 Answers  

---