What is "Connection string"?what is "View"?what is "Stored procedure"?what is "delegate"?

Showing Answers 1 - 15 of 15 Answers


  • Sep 11th, 2006

view: view is a mirror of the table

  Was this answer useful?  Yes


  • Sep 11th, 2006

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

  Was this answer useful?  Yes


  • Oct 4th, 2006

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

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

  Was this answer useful?  Yes


  • Oct 25th, 2006

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.


vinita tyagi

  • Oct 30th, 2006

 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.

  Was this answer useful?  Yes

Satish jha

  • Jan 3rd, 2007

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.

  Was this answer useful?  Yes

Mob: +91 9849255958

  • Jan 4th, 2007


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.

  Was this answer useful?  Yes


  • Jan 18th, 2007

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

  Was this answer useful?  Yes


  • Sep 22nd, 2007

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.

  Was this answer useful?  Yes


  • Sep 14th, 2008

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. 

  Was this answer useful?  Yes


  • Dec 10th, 2008

Store procedure are like functions in some other languages. it is pre complied block of
SQL statements. using which we can connect database very fastly and securily.

Delegates are function pointers. which can holds the address of functions.

View is logical which is used for filtering the data from table.

Connection string is string to connect to the database.

  Was this answer useful?  Yes


  • Jun 27th, 2010

Connection string: This is a combination of server name, database name and credentials (user name and password). This string is used to connect with the database.

View: This is the logical representation of the table. Like if you want to show only few fields of the table and in specific order then you can make a view with selected columns in particular order.

Stored procedure: This is a group of compiled SQL statements stored in a database. We can call those statements in by its name. execution is fast as SQL engine does not parse the statements every time.

Delegate: This is a type safe function pointer.

  Was this answer useful?  Yes


  • May 12th, 2011

  • Connection String contains attributes (credentials, data source, authentication type,  etc) for connecting our application to a data source.
  • View, returns a table which might be combination of tables generated by complex query and used in many places in the system.
  • Stored Procedure, is a precompiled set of SQL statements which can be used to return,update data to Database.
  • Delegate, can be defined as function pointer. Events in ASP.NET are best examples for delegate. Delegates invokes the corresponding function by its signature.

  Was this answer useful?  Yes

1.Connection sting contains servername, database and credentials of db, without connection string we cannot working with a backend application
2.View is similar to a table, user can modify the data in view but cant in table
3.Stored procedure contains a queries, by using sp we can run the applications quickly
4.Delegate is like a pointer to a function

  Was this answer useful?  Yes

rohit chittora

  • Aug 20th, 2011

view : it is a mirror image or shadow of table with some modification so that only the essential information is display hidden some information from end user.

Store procedure : this are group of executable statement store in database call by its name so that execution is fast no need to parse the statement.

delegate : it is reference to method
syntax : delegate type delegate name( );

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions