What is the use of CommandBuilder

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > .NET > ADO.NET

What is the use of CommandBuilder ?

✍: Guest

CommandBuilder builds “Parameter” objects automatically. Below is a simple code which uses commandbuilder to load its parameter objects.

Dim pobjCommandBuilder As New OleDbCommandBuilder(pobjDataAdapter)
pobjCommandBuilder.DeriveParameters(pobjCommand)

Be careful while using “DeriveParameters” method as it needs an extra trip to the Datastore which can be very inefficient.

2007-10-24, 5219👍, 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 method’s Find It takes a array of values and returns the index of the r... 2007-10-24, 5812👍, 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, 5443👍, 0💬

How can we add/remove row’s in “DataTable” object of “DataSet”
How can we add/remove row’s 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, 5288👍, 0💬

What’s difference between “Optimistic” and “Pessimistic” locking
What’s 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 user’s can only view the data when there is pessimistic locking. In optimistic locking multiple users can open th... 2007-10-24, 5273👍, 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, 5252👍, 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, 5220👍, 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, 5197👍, 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, 5092👍, 0💬

How can we add relation’s between table in a DataSet
How can we add relation’s 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, 5031👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.