Articles → ADO.NET → Dataset In ADO.NET
Dataset In ADO.NET
What Is A Dataset?
Example
using System;
using System.Data;
namespace datasetdemo
{
class Program
{
static void Main(string[] args)
{
// Create a new Dataset
DataSet dataSet = new DataSet();
// Create a DataTable
DataTable table = new DataTable("Employees");
// Define columns
table.Columns.Add("ID", typeof(int));
table.Columns.Add("Name", typeof(string));
// Add data to the DataTable
table.Rows.Add(1, "John");
table.Rows.Add(2, "Jane");
// Add the DataTable to the Dataset
dataSet.Tables.Add(table);
// Access data from the Dataset
foreach (DataRow row in dataSet.Tables["Employees"].Rows)
{
Console.WriteLine($"ID: {row["ID"]}, Name: {row["Name"]}");
}
Console.ReadLine();
}
}
}
Output