Read data from DataSet : DataSet : Database C# Source Code

Read data from DataSet

    


using System;
using System.Data;
using System.Data.SqlClient;

class PopDataset
{
   static void Main()
   {
      string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
      string sql = @"select * from employee";
      SqlConnection conn = new SqlConnection(connString);

      try
      {
         conn.Open();
         SqlDataAdapter da = new SqlDataAdapter(sql, conn);
         DataSet ds = new DataSet();    
         da.Fill(ds, "employee");
         DataTable dt = ds.Tables["employee"];
         foreach (DataRow row in dt.Rows)
         {
            foreach (DataColumn col in dt.Columns)
               Console.WriteLine(row[col]);
            Console.WriteLine("".PadLeft(20, '='));
         }
      }
      catch(Exception e)
      {
         Console.WriteLine("Error: " + e);
      }
      finally
      {
         conn.Close();
      }
   }  
}


           
       
    
   
  
   

Related in same category :
• Print DataSet out
• Finding Data
• How to perform a SELECT statement and store the returned rows in a DataSet object
• Populate a DataSet object using a SELECT statement
• Populate a DataSet object with multiple DataTable objects
• Populate a DataSet with multiple DataTable objects using multiple SELECT statements
• Use the Merge() method
• DataSet Delete
• For each row in DataSet, reference the column data by column name
• DataSet Read
• ReadXml
• Open the XML file and read into a DataSet
• Populate a DataSet object with a range of rows from a SELECT statement
• Using Datasets
• Using Multi Tabled Datasets