ASP Interview Questions
Questions Answers Views Company eMail

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

DCI,

1701

what are the two main compononet in remoting

DCI,

1801

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

2253

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

2 18600

what is the difference between sql server2000 and 2005

1659

what is database deployment?

1788

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

Perot Systems,

1660

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

2 3482

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

2 3657

how to disable previous page complete after logout process

powercom,

2 4162

why many web.config files are used in are project

1 3169

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

RealPage,

2 5955

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

1838

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

1961

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

1995


Post New ASP Questions

Un-Answered Questions { ASP }

How do I open an asp file in excel?

735


What is msmq?

699


What is asp content?

720


What is full form of aspx?

715


How to insert the records in a database table by using asp?

678


Explain the differences between asp and asp.net and is asp.net backward compatible to asp?

687


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

679


what is SDLC in Software?pl.give proper explaination

1798


What is the common type system (cts)?

714


Why we need stored procedures?

735


How do I open aspx file on mac?

816


What happens to a html page in asp?

687


how u can use asp.net for making website?

1770


What happens to asp pages?

713


Write a program in asp to find out the leap year. [Accept the year from the user ]

2494