A Data Set resembles a database. Data Table resembles the database table. Data Row resembles a record in the table.
DataSet reqClasses = new DataSet();
DataTable reqClassesTable = new DataTable();
//.. from stored procedure … selecting ClassID from InstCrsReq …The dataset is defined as DataSet reqList in this line…
objDA.Fill(reqList, “ReqList”);
So I can access the data using this assignment…
reqClassesTable = reqClasses.Tables[“reqList”];
Then I can loop through the data and do whatevs…
foreach (DataRow row in reqClassesTable.Rows)
{string ClassID = row[“ClassID”].ToString();}
Another way to use the data set is to call to a database and return one.
DataSet movieList = new DataSet();
myDatabaseCall(movieList);
movieList.Tables[“movieList”] now contains the results of the database call, maybe somthing like:
| MovieID | MovieName |
| 1 | The Matrix |
| 2 | Justice League |
You can loop through the rows as so…
foreach (DataRow row in movieList.Tables[“movieList”] )
{ Label1.Text += row[“MovieName”];}
The control named “Label1” would contain: The MatrixJustice League
because I didn’t use any logic to add commas or a space between the field results display.