GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Microsoft  >  Ado.NET
Go To First  |  Previous Question  |  Next Question 
 Ado.NET  |  Question 14 of 31    Print  
what is "Connection string"?
what is "View"?
what is "Stored procedure"?
what is "delegate"?

  
Total Answers and Comments: 11 Last Update: December 11, 2008     Asked by: Hanan 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: NNN
 

connection String - a string which contains address of the database we want to connect to.

View - Desired shape of a table we want to show to user. if we want to hide any particular field of table then we can create view.

Stored Procedure -collection of SQL statements that are stored in the database. It can be called by its name. We need not to execute these statements every time we use, so we get higher speed of execution.

Delegate -

A delegate is an important element of C# and is extensively used in every type of .NET application. A delegate is a class whose object (delegate object) can store a set of references to methods.

 



Above answer was rated as good by the following members:
surendra_sahu786
  Sorting Options  
  Page 1 of 2   « First    1    2    >     Last »  
September 11, 2006 10:00:54   #1  
vijay1 Member Since: September 2006   Contribution: 2    

RE: what is "Connection string"?what is "View"?
view: view is a mirror of the table
 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
September 11, 2006 10:04:04   #2  
vijay1 Member Since: September 2006   Contribution: 2    

RE: what is "Connection string"?what is "View"?
Store Procedure: it is a collection of t-sql statementsits reduce a network trafficit allows condinational state mentsthere are different type of store proc used1 system 2.remote 3.local 4.temp
 
Is this answer useful? Yes | No
October 04, 2006 04:40:10   #3  
fazal        

RE: what is "Connection string"?what is "View"?

when u want connecting to database then using the connection string.

eg: server server;database NorthWind;uid sa;pwd sa


 
Is this answer useful? Yes | No
October 25, 2006 09:48:01   #4  
NNN Member Since: May 2006   Contribution: 2    

RE: what is "Connection string"?what is "View"?

connection String - a string which contains address of the database we want to connect to.

View - Desired shape of a table we want to show to user. if we want to hide any particular field of table then we can create view.

Stored Procedure -collection of SQL statements that are stored in the database. It can be called by its name. We need not to execute these statements every time we use so we get higher speed of execution.

Delegate -

A delegate is an important element of C# and is extensively used in every type of .NET application. A delegate is a class whose object (delegate object) can store a set of references to methods.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
October 30, 2006 05:07:46   #5  
vinita tyagi        

RE: what is "Connection string"?what is "View"?

connection string A string which contain the address of database which we want to connect.
this string contains
servername/hostname databasename username and password
these are the mandatory field.

but this string also has some optional part like

Packet size: no of TCP/IP protocals transfered.
....
view are the logical unit of database. it is not exist physically it just like the select statenamte which is made by one or more tables.means it is a logical statement which is defined by the programmers according to their suits and need for retriving data.


 
Is this answer useful? Yes | No
January 03, 2007 11:05:53   #6  
Satish jha        

what is "Connection string"?what is "View"?

Connection string :It is type of Connection nnd its a important part of ADO when u want to handle any databaes then its must because he is provided

all the path of database eg:provider idpwd Server or Database..

View : View is a mirror of table its help for logically work on this tables.


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
January 04, 2007 13:15:41   #7  
Mob: +91 9849255958        

RE: what is "Connection string"?what is "View"?

Hi

u said that we need not execute everytime in case of storedprocedure.......its wrong

we must execute but we need not compile the statements in a storedprocedure everytime becoz a storedprocedure is stored in the server in a precompiled form.

and one more thing ....if u want u can also complile everytime by using an option called 'with recompile' while writing a storedprocedure.


 
Is this answer useful? Yes | No
January 18, 2007 08:20:34   #8  
deen        

RE: what is "Connection string"?what is "View"?

view is not mirror of table we can store particular coloums from a single table or multible tables and stored as view.


 
Is this answer useful? Yes | No
September 22, 2007 10:23:30   #9  
bornToLose        

RE: what is "Connection string"?what is "View"?

Connection string state the details of connection like database server name user id password etc

View is used in SQL to create a copy or viurtual table with some existing table. It has same structure for base table and used where we want to do do changes locally not in original database.

Stored procedure is a collection of query which is stored in a file and run on the server. It make the retreival fast and save lot of resources .

Delegate is to provide delegation to particular task or querry to be run on the server.


 
Is this answer useful? Yes | No
September 14, 2008 23:09:26   #10  
Pendurti Member Since: September 2008   Contribution: 10    

RE: what is "Connection string"?what is "View"?what is "Stored procedure"?what is "delegate"?
Connection String is something that is stored in the HTML code and contains information about the security the connection to the database error handling etc.

View is a property that allows you to store the values in the variables when a postback occurs.

Stored procedure is an already written SQL statement. These give us faster execution as they are pre-compiled. These are stored on the web server and can be called in any application when needed.

Delegates are functional pointers. They point to certain methods and allow us to perform certain actions without even knowing what method it is at run time. These are basically used for event-handling purposes.

 
Is this answer useful? Yes | No
  Page 1 of 2   « First    1    2    >     Last »  


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape