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
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
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.
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.
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.
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.
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.