Advertise your Business Here      Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new    Refer this Site                     Login  |  Sign Up                       Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories  >>  Software  >>  Scripts  >>  ASP        Suggest New Category      Question  Asked @ Answers Views     select   what is database deployment?  0  27 what is the difference between sql server2000 and 2005  0  22 What is difference between Physical path and Virtual path? Explanin with example.  1  266 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  71 what are the two main compononet in remoting DCI  0  41 ___________ and ____________ properity to be used to create localized version of a form DCI  0  33 How can I break Search  0  39 How to run FileSystemObject in ASP Karvy  1  514 How to use XML file as a database in the ASP  0  61 How to refersh an asp page on a single click of a button. IBM  2  541 How will u make automatic login program in asp as u see in yahoo messanger? When any body login to their system they no need to fill userid and password. It automatically fills the userid and password.  0  90 . which tag i need to use manually to bind columns in a datagrid ?  0  61 hi this is madhu i have one doubt,regarding siebel Q: is this is mandatory when we r doing join between a bc & table , the table should extension table Reqired or not, can we do the join with base table also,  0  53 6) Events in page life cycle?  1  613 what is mean of ASP?  3  595 E-Mail New Answers        Answer Selected Questions     Prev    1   2    [3]   4   5   6   7   8   9   10   11    Next         PHP Interview Questions     ASP Interview Questions     CGI Perl Interview Questions     JavaScript Interview Questions     VB Script Interview Questions     JSP Interview Questions     Shell Script Interview Questions     Python Interview Questions     Tcl Interview Questions     Awk Interview Questions     AJAX Interview Questions     Ruby on Rails Interview Questions     Scripts AllOther Interview Questions       Un-Answered Questions    Question Views Asked at   Select   Describe ways to present an arbitrary endpoint (URL) and route requests to that endpoint to ASP.NET. 112   Write a program in asp to find out the leap year. [Accept the year from the user ] 65   how we can establish the connectivity between front end and backend?(asp as front end and c# as back end) 30 Polycom difference between html and asp? 32 Polycom how to disable previous page complete after logout process 54 powercom Juxtapose the HTTP verbs GET and POST. What is HEAD? 118   Enter the roll number of a student and get his marks from a database file called MARKS. Use an ASP code for the same 41   What process happens behind, when we try to access any page on the internet. 105   How to use XML file as a database in the ASP 61   What is difference between Physical path and Virtual path? Explanin with example. 266   Suppose someone gives a VB dll file (component). How to use that in an ASP file? 45 Perot-Systems What is wsdl file? (explain in detail) 41 DLI how to delete windows application in vs.net 58   Give an example of how using an HttpHandler could simplify an existing design that serves Check Images from an .aspx page. 116   hi this is madhu i have one doubt,regarding siebel Q: is this is mandatory when we r doing join between a bc & table , the table should extension table Reqired or not, can we do the join with base table also, 53   • How do you relate an aspx page with its code behind page? 88 3i-Infotech How could u display all of the cookies/cookie values for a user through a Web page in ASP? 93   what is the difference between sql server2000 and 2005 22   I am not doing well in my oracle class and desparetly need some help. My main problem is the join chapter. I am very frustrated right now because I got my first zero in my in school lastweek. I excell in every other subject except oracle. I really would like to learn the program, but it looks dim for me right now and it is too late to drop the class without getting 'F'. Can someone pleae help me. with this one because I only have a few days before my assignment is due. If you leave your email I will get intouch with you immediately. Thanks 33   In case of we are not saving the information as cookies. how server detects the same user? 53   E-Mail New Answers        Answer Selected Questions

Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us     Copyright © 2007  ALLInterview.com.  All Rights Reserved. ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com