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...