Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How can we load multiple tables in a DataSet
How can we load multiple tables in a DataSet ?
✍: Guest
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, 4580👍, 0💬
Popular Posts:
Are risk constant through out the project ? * Never say that risk is high through out the project. R...
What is difference between custom JSP tags and JavaBeans? Custom JSP tag is a tag you defined. You d...
What Happens If a Hyper Link Points to a Music File? - XHTML 1.0 Tutorials - Understanding Hyper Lin...
The object that contains all the properties and methods for every ASP.NET page, that is built is .. ...
How do you open an SSH connection to a remote box? ????