ASP Interview Questions
Questions Answers Views Company eMail

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

DCI,

1511

what are the two main compononet in remoting

DCI,

1603

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

1970

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

2 18182

what is the difference between sql server2000 and 2005

1454

what is database deployment?

1582

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

Perot Systems,

1467

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

2 3060

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

2 3132

how to disable previous page complete after logout process

powercom,

2 3765

why many web.config files are used in are project

1 2851

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

RealPage,

2 5520

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

1654

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

1749

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

1791


Post New ASP Questions

Un-Answered Questions { ASP }

What is asp full form?

536


Explain the difference between post & get method in asp?

491


How does asp differ from html?

499


Which is an advantage of application service providers (asps)?

476


how can i connect to ms-access database, with ASP??

1377






What is asp model?

540


What do you mean by asp?

510


Write code for the following in ASP a)Display attributes of a file b) File copy c) get disk capacity.

1528


Define text stream object?

543


How do I open an asp file in excel?

537


What is msmq? What is n-tier system?

563


What is aspx format?

522


Explain the difference between sap r/2 and r/3?

511


Name the methods by which output stream is controlled?

486


What are the tasks performed by <> tags?

501