ASP Interview Questions
Questions Answers Views Company eMail

___________ and ____________ properity to be used to create localized version of a form

DCI,

1724

what are the two main compononet in remoting

DCI,

1831

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

2277

What is difference between Physical path and Virtual path? Explanin with example.

2 18649

what is the difference between sql server2000 and 2005

1674

what is database deployment?

1804

Suppose someone gives a VB dll file (component). How to use that in an ASP file?

Perot Systems,

1679

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

2 3529

how to connect asp with sql server.......? Write some code for connectivity between sql server and ASP...

2 3722

how to disable previous page complete after logout process

powercom,

2 4196

why many web.config files are used in are project

1 3208

Do you know ASP? Are u willing to work in it?

RealPage,

2 5992

What process happens behind, when we try to access any page on the internet.

1858

In case of we are not saving the information as cookies. how server detects the same user?

1983

Enter the roll number of a student and get his marks from a database file called MARKS. Use an ASP code for the same

2018


Post New ASP Questions

Un-Answered Questions { ASP }

explain joints in .net.

2116


How do I view an aspx file?

736


Define garbage collection?

762


How to handle error in asp

757


Explain how to refresh an asp page on a single click of a button?

653


What is the default scripting language in asp?

732


i want question papers of ASP

1716


How do you make it so that code runs when the security system is stopping it?

758


Name the methods in application object?

792


What is the default scripting language on the client side?

686


What is an err object?

741


Describe ways to present an arbitrary endpoint (URL) and route requests to that endpoint to ASP.NET.

4065


What is the command to display characters to the html page in asp?

695


Give the comment tags for the following?

716


What are the asp objects?

736