Csharp/C Sharp by API/System.Data/DataTableCollection
DataTableCollection.Indexer
<source lang="csharp"> using System; using System.Data; using System.Data.SqlClient;
class FilterSort { static void Main(string[] args) { string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI"; string sql1 = @"select * from employee;"; string sql2 = @"select firstname, lastname from employee"; string sql = sql1 + sql2; SqlConnection conn = new SqlConnection(connString); try { SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(sql, conn); DataSet ds = new DataSet(); da.Fill(ds, "employee"); DataTableCollection dtc = ds.Tables; Console.WriteLine("Results from Customers table:"); Console.WriteLine("FirstName".PadRight(20) + "LastName".PadLeft(23) + "\n"); string fl = "FirstName = "Z""; string srt = "LastName asc"; foreach (DataRow row in dtc["Employee"].Select(fl, srt)) { Console.WriteLine( "{0}\t{1}", row["FirstName"].ToString().PadRight(25), row["LastName"]); } Console.WriteLine("Results from Products table:"); Console.WriteLine("FirstName".PadRight(20) + "LastName".PadLeft(21) + "\n"); foreach (DataRow row in dtc[1].Rows){ Console.WriteLine("{0}\t{1}", row["FirstName"].ToString().PadRight(25), row["LastName"]); } } catch(Exception e) { Console.WriteLine("Error: " + e); } finally { conn.Close(); } } } </source>