How can we load multiple tables in a DataSet

Q

How can we load multiple tables in a DataSet ?

✍: Guest

A

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. Sample code shows two tables “Table1” and “Table2” in object ObjDataSet.

lstdata.DataSource = objDataSet.Tables("Table1").DefaultView

In order to refer “Table1” DataTable, use Tables collection of DataSet and the Defaultview object will give you the necessary output.

2007-10-24, 5109👍, 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, 6007👍, 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, 5675👍, 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, 5483👍, 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, 5478👍, 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, 5465👍, 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, 5436👍, 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, 5293👍, 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, 5271👍, 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, 5173👍, 0💬

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.