Fill DataSet With SqlDataAdapter : SqlDataAdapter « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. SqlDataAdapter

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

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

  class Program
  {
    static void Main(string[] args)
    {
      string cnStr = "Integrated Security = SSPI;Initial Catalog=YourDB;Data Source=(local)\\SQLEXPRESS";
      DataSet ds = new DataSet("YourDB");
      SqlDataAdapter dAdapt = new SqlDataAdapter("Select * From Inventory", cnStr);
      DataTableMapping custMap = dAdapt.TableMappings.Add("Inventory", "Current Inventory");
      custMap.ColumnMappings.Add("CarID", "Car ID");
      custMap.ColumnMappings.Add("PetName", "Name of Car");
      dAdapt.Fill(ds, "Inventory");
      PrintDataSet(ds);
    } 
    static void PrintDataSet(DataSet ds)
    {
      Console.WriteLine(ds.DataSetName);
      foreach (System.Collections.DictionaryEntry de in ds.ExtendedProperties)
      {
        Console.WriteLine("Key = {0}, Value = {1}", de.Key, de.Value);
      }
      foreach (DataTable dt in ds.Tables)
      {
        Console.WriteLine(dt.TableName);
        for (int curCol = 0; curCol < dt.Columns.Count; curCol++)
        {
          Console.Write(dt.Columns[curCol].ColumnName.Trim() + "\t");
        }
        PrintTable(dt);
      }
    }

    private static void PrintTable(DataTable dt)
    {
      DataTableReader dtReader = dt.CreateDataReader();
      while (dtReader.Read())
      {
        for (int i = 0; i < dtReader.FieldCount; i++)
        {
          Console.WriteLine(dtReader.GetValue(i).ToString().Trim());
        }
      }
      dtReader.Close();
    }
  }