Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

DataView and DataRowView

using System; using System.Data; using System.Data.SqlClient;     class DataViews     {         static void Main(string[] args)         {             string connString = @"server = .\sqlexpress;integrated security = true;database = northwind";             string sql = @"select contactname,country from customers";             SqlConnection conn = new SqlConnection(connString);             try             {                 SqlDataAdapter da = new SqlDataAdapter();                 da.SelectCommand = new SqlCommand(sql, conn);                 DataSet ds = new DataSet();                 da.Fill(ds, "customers");                 DataTable dt = ds.Tables["customers"];                 DataView dv = new DataView(dt,"country = 'Germany'","country",DataViewRowState.CurrentRows);                 foreach (DataRowView drv in dv)                 {                     for (int i = 0; i < dv.Table.Columns.Count; i++)                         Console.Write(drv[i] + "\t");                 }             }             catch (Exception e)             {                 Console.WriteLine("Error: " + e);             }             finally             {                 conn.Close();             } Console.ReadLine();         }     }