Tuesday, 7 June 2011

Loading multiple tables in a DataSet ?

Hi friends,in this post i would like to explain Loading multiple tables in a DataSet ?

sqlCommand.CommandText = "Employee"
sqlDataAdapter.Fill(sqlDataSet, " Employee ")
sqlCommand.CommandText = "Colleges"
sqlDataAdapter.Fill(sqlDataSet, " Colleges ")

In the above code,it will shows how to load multiple tables in single DataSet.

Firstdata.DataSource = sqlDataSet.Tables("Employee ").DefaultView

In order to get first table(Employee) data , use Tables collection of DataSet and the Defaultview object will give you the necessary output.

Thank You...
Shout it

Leave a Reply