ALLInterview.com :: Home Page KalAajKal.com
 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  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     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
Google
 
 Categories  >>  Software  >>  Scripts  >>  ASP       
Suggest New Category 
 


 

View Page with Answers
  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   PHP Interview Questions  ASP interview questions   ASP Interview Questions  CGI Perl interview questions   CGI Perl Interview Questions
 JavaScript interview questions   JavaScript Interview Questions  VB Script interview questions   VB Script Interview Questions  JSP interview questions   JSP Interview Questions
 Shell Script interview questions   Shell Script Interview Questions  Python interview questions   Python Interview Questions  Tcl interview questions   Tcl Interview Questions
 Awk interview questions   Awk Interview Questions  AJAX interview questions   AJAX Interview Questions  Ruby on Rails interview questions   Ruby on Rails Interview Questions
 Scripts AllOther 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