Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Pop DataTable

using System; using System.Data; using System.Data.SqlClient;     class PopDataTable     {         static void Main(string[] args)         {             string connString = @"server = .\sqlexpress;integrated security = true;database = northwind";             string sql = @"select productname,unitprice from products where unitprice < 20";             SqlConnection conn = new SqlConnection(connString);             try{                 conn.Open();                 SqlDataAdapter da = new SqlDataAdapter(sql, conn);                 DataTable dt = new DataTable();                 da.Fill(dt);                 foreach (DataRow row in dt.Rows)                 {                     foreach (DataColumn col in dt.Columns)                         Console.WriteLine(row[col]);                 }             }             catch (Exception e)             {                 Console.WriteLine("Error: " + e);             }             finally             {                 conn.Close();             }         }     }