public CreateDataReader ( ) : |
||
return |
using System.Data; using System.Data.Common; DataTable dt = new DataTable(); // Add columns to the DataTable dt.Columns.Add(new DataColumn("Id", typeof(int))); dt.Columns.Add(new DataColumn("Name", typeof(string))); // Add rows to the DataTable dt.Rows.Add(1, "John"); dt.Rows.Add(2, "Jane"); // Create a data reader from the DataTable DbDataReader dataReader = dt.CreateDataReader(); while (dataReader.Read()) { // Access the data in each row int id = (int)dataReader["Id"]; string name = (string)dataReader["Name"]; Console.WriteLine("Id: " + id + ", Name: " + name); }This example demonstrates how to use the DataTable.CreateDataReader method to create a data reader from a DataTable and read its data. The package library used is System.Data. Overall, this method is useful for scenarios where you want to read data from a DataTable but retrieve it using a data reader interface. It provides a lightweight and efficient way to access the data without having to load it into another data structure.