ASP Interview Questions
Questions Answers Views Company eMail

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

DCI,

1502

what are the two main compononet in remoting

DCI,

1590

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

1959

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

2 18146

what is the difference between sql server2000 and 2005

1445

what is database deployment?

1571

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

Perot Systems,

1455

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

2 3036

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

2 3094

how to disable previous page complete after logout process

powercom,

2 3741

why many web.config files are used in are project

1 2836

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

RealPage,

2 5493

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

1635

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

1733

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

1779


Post New ASP Questions

Un-Answered Questions { ASP }

What is the difference between cshtml and aspx?

523


Name the methods in application object?

567


How do I administer security for my machine? For an enterprise?

487


How do I change a aspx file to a pdf?

496


What is pdf aspx?

481






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

1363


What purpose is served by the application.lock method?

521


What is Debit Memo & Credit Memo in Payables?

1542


Explain how is method overriding different from overloading?

478


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

490


Name the collections of session object?

525


How to handle error in asp

520


what is execute dataset for sp

2038


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

491


we are doing Design of Placement Website as our academic project. Home page is in c#.net format and register page is in asp.net format. We met a problem in this.register page is not linked in home page. how i complete my project with out any change..?

1546