what is "View"? what is "Stored procedure"? what is "delegate"? ">
what is "Connection string"?what is "View"?what is "Stored procedure"?what is "delegate"?
Hanan
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 exec...
1.Connection sting contains servername, database and credentials of db, without connection string we cannot working with a backend application2.View is similar to a table, user can modify the data in ...
SQLClient: 1. It does not use translation layer. So providing high performance. 2. This is only to connect with SQL server. OleDB: 1. We can connect with any database using OLEDB. 2. There is a transl...
sqldata provider is a native provider for the sqlserver developed by micrsoft, it contains all native drivers that gets connected to the sqlserver. Where as, oledbprovider is to make access to any dat...
I know the DataAdapter provides this functionality but I prefer to create a SQL Statement that performs the merge and creates a single DataSet. The servers are usually high powered machines so by let...
You can pass multiple select statements in data adapter separated by “;”.SqlDataAdapter dataAdapter = new SqlDataAdapter(“select * from table1;select * from table2”, connection);DataSet ds = new DataSet();dataAdapter.Fill(ds);
Repeater itself a presentation control, not the data editing control.Repeater still can support a multiple records updates which i have done to support some client requirements.Basically its not the b...
Repeater control does not have default selecting and editing support. This control is just to read and display the information. This control has better performance. But if you want to enable the editi...