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();
}
}
|