.NET Remoting versus Distributed COM ?
.NET Remoting versus Distributed COM ? In the past interprocess communication between applications was handled through Distributed COM, or DCOM. DCOM works well and the performance is adequate when applications exist on computers of similar type on the same network. However, DCOM has its drawbacks i... 2009-03-19, 4152👍, 0💬
How do we create DCOM object in VB6
How do we create DCOM object in VB6 Using the CreateObject method you can create a DCOM object. You have to put the server name in the registry. 2009-03-06, 4255👍, 0💬
What is use of interlocked class?
What is use of interlocked class? Interlocked class provides methods by which you can achieve following functionalities :- * Increment Values. * Decrement values. * Exchange values between variables. * Compare values from any thread. in a synchronization mode. Example :- System.Threading.Interlocked.. . 2009-03-06, 4164👍, 0💬
How Can We Know state of thread?
How Can We Know state of thread? "ThreadState" property can be used to get detail of a thread. Thread can have one or a combination of status.System.Threading. Threadstate enumeration has all the values to detect a state of thread. Some sample states are Isrunning, IsAlive, suspended etc. 2009-03-06, 4958👍, 0💬
Explain in detail the fundamental of connection pooling
Explain in detail the fundamental of connection pooling? When a connection is opened first time a connection pool is created and is based on the exact match of the connection string given to create the connection object. Connection pooling only works if the connection string is the same. If the conn... 2007-10-24, 5556👍, 0💬
Can you explain the difference between an ADO.NET Dataset and an ADO Recordset
Can you explain the difference between an ADO.NET Dataset and an ADO Recordset? There two main basic differences between recordset and dataset ? With dataset you an retrieve data from two databases like oracle and sql server and merge them in one dataset , with recordset this is not possible ? All r... 2007-10-24, 4290👍, 0💬
What is difference between Dataset. clone and Dataset.copy
What is difference between Dataset. clone and Dataset. copy ? Clone: - It only copies structure, does not copy data. Copy: - Copies both structure and data. 2007-10-24, 4590👍, 0💬
How can we perform transactions in .NET
How can we perform transactions in .NET? The most common sequence of steps that would be performed while developing a transactional application is as follows: ? Open a database connection using the Open method of the connection object. ? Begin a transaction using the Begin Transaction method of the ... 2007-10-24, 4358👍, 0💬
How many ways are there to implement locking in ADO.NET
How many ways are there to implement locking in ADO.NET ? Following are the ways to implement locking using ADO.NET 1. When we call gUpdateh method of DataAdapter it handles locking internally. If the DataSet values are not matching with current data in Database it raises concurrency exception err... 2007-10-24, 5152👍, 0💬
Whats difference between Optimistic and Pessimistic locking
Whats difference between Optimistic and Pessimistic locking ? In pessimistic locking when user wants to update data it locks the record and till then no one can update data. Other users can only view the data when there is pessimistic locking. In optimistic locking multiple users can open th... 2007-10-24, 4452👍, 0💬
What is the use of CommandBuilder
What is the use of CommandBuilder ? CommandBuilder builds Parameter objects automatically. Below is a simple code which uses commandbuilder to load its parameter objects. Dim pobjCommandBuilder As New OleDbCommandBuilder(pobjDataAd apter)pobjCommandBuilder.DeriveParam eters(pobjCommand)Be careful ... 2007-10-24, 4477👍, 0💬
How can we add relations between table in a DataSet
How can we add relations between table in a DataSet ? Dim objRelation As DataRelation objRelation=New DataRelation("CustomerAddresse s",objDataSet.Tables("Customer ").Columns("Custid"),objDataSet.Tables("Addresses" ).Columns("Custid_fk"))objDataSet.Relations.Add(objRe lation)Relations can be added b... 2007-10-24, 4229👍, 0💬
How can we load multiple tables in a DataSet
How can we load multiple tables in a DataSet ? objCommand.CommandText = "Table1" objDataAdapter.Fill(objDataSet ,"Table1") objCommand.CommandText = "Table2" objDataAdapter.Fill(objDataSet ,"Table2") Above is a sample code which shows how to load multiple DataTable objects in one DataSet object.... 2007-10-24, 4209👍, 0💬
Why is DataSet slower than DataReader
What is the difference between DataSet and DataReader ? Following are the major differences between DataSet and DataReader ? DataSet is a disconnected architecture, while DataReader has live connection while reading data. If we want to cache data and pass to a different tier DataS... 2007-10-24, 4334👍, 0💬
What is basic use of DataView
What is basic use of DataView ? DataView represents a complete table or can be small section of rows depending on some criteria. It is best used for sorting and finding data with in datatable. Dataview has the following methods Find It takes a array of values and returns the index of the r... 2007-10-24, 4791👍, 0💬
How can we add/remove rows in DataTable object of DataSet
How can we add/remove rows in DataTable object of DataSet ? Datatable provides NewRow method to add new row to DataTable. DataTable has DataRowCollection object which has all rows in a DataTable object. Following are the methods provided by DataRowCollection object Add Ad... 2007-10-24, 4519👍, 0💬
How can we check that some changes have been made to dataset since it was loaded
How can we cancel all changes done in dataset ? or How do we get values which are changed in a dataset ? For tracking down changes Dataset has two methods which comes as rescue GetChanges and HasChanges. GetChanges Returns dataset which are changed since it was loaded or since Acceptchanges was... 2007-10-24, 4694👍, 0💬
How can we save all data from dataset
How can we save all data from dataset ? Dataset has AcceptChanges method which commits all the changes since last time Acceptchanges has been executed. 2007-10-24, 4303👍, 0💬
What are the various methods provided by the dataset object to generate XML
What are the various methods provided by the dataset object to generate XML? Note:- XML is one of the most important leap between classic ADO and ADO.NET. So this question is normally asked more generally how can we convert any data to XML format. Best answer is convert in to dataset and use the bel... 2007-10-24, 4095👍, 0💬
How can we use dataadapter to fill a dataset ?
What are the steps involved to fill a dataset ? Sample code is provided in WindowsDataSetSample folder in CD.LoadData has all the implementation of connecting and loading to dataset. This dataset is finally bind to a ListBox. Below is the sample code. Private Sub LoadData() Dim strConnectionStr... 2007-10-24, 4211👍, 0💬
Which is the best place to store connectionstring in .NET projects
Which is the best place to store connectionstring in .NET projects ? Config files are the best places to store connectionstrings. If it is a web-based application Web.config file will be used and if it is a windows application App.config files will be used. 2007-10-24, 4233👍, 0💬
How can we fine tune the command object when we are expecting a single row
How can we fine tune the command object when we are expecting a single row ? Again CommandBehaviour enumeration provides two values SingleResult and SingleRow. If you are expecting a single value then pass and the query is optimized accordingly, if you are expecting s... 2007-10-24, 4669👍, 0💬
I want to force the datareader to return only schema of the datastore rather than data
I want to force the datareader to return only schema of the datastore rather than data ? pobjDataReader = pobjCommand.ExecuteReader(Comm andBehavior.SchemaOnly) 2007-10-24, 4584👍, 0💬
In C#, what is a weak reference? Generally, when you talk about a reference to an object in .NET (an...
How can we connect to Microsoft Access , Foxpro , Oracle etc ? Microsoft provides System.Data.OleDb ...
How To Give a User Read-Only Access to a Database? - MySQL FAQs - Managing User Accounts and Access ...
How To Increment Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
How can I use tables to structure forms Small forms are sometimes placed within a TD element within ...