Csharp/C Sharp by API/System.Data/DataColumn

DataColumn.AllowDBNull

 
using System;
using System.Collections.Generic;
using System.ruponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
public class Car {
    public string carPetName, carMake, carColor;
    public Car(string petName, string make, string color) {
        carPetName = petName;
        carColor = color;
        carMake = make;
    }
}
public class MainForm : Form {
    private List<Car> arTheCars = new List<Car>();
    private DataTable inventoryTable = new DataTable("Inventory");
    DataView coltsOnlyView;      // I only show red colts.
    public MainForm() {
        InitializeComponent();
        arTheCars.Add(new Car("C", "BMW", "Green"));
        arTheCars.Add(new Car("T", "Y", "White"));
        arTheCars.Add(new Car("AAA", "Jeep", "Tan"));
        arTheCars.Add(new Car("PInducer", "Caravan", "Pink"));
        arTheCars.Add(new Car("F", "BMW", "Pea Soup Green"));
        arTheCars.Add(new Car("B", "BMW", "Black"));
        arTheCars.Add(new Car("M", "DDD", "Red"));
        arTheCars.Add(new Car("S", "Colt", "Black"));
        CreateDataTable();
        CreateDataView();
    }
    private void CreateDataTable() {
        DataColumn carIDColumn = new DataColumn("CarID", typeof(int));
        carIDColumn.ReadOnly = true;
        carIDColumn.Caption = "Car ID";
        carIDColumn.AllowDBNull = false;
        carIDColumn.Unique = true;
        carIDColumn.AutoIncrement = true;
        carIDColumn.AutoIncrementSeed = 0;
        carIDColumn.AutoIncrementStep = 1;
        carIDColumn.ColumnMapping = MappingType.Attribute;
        DataColumn carMakeColumn = new DataColumn("Make", typeof(string));
        DataColumn carColorColumn = new DataColumn("Color", typeof(string));
        DataColumn carPetNameColumn = new DataColumn("PetName", typeof(string));
        carPetNameColumn.Caption = "Pet Name";
        inventoryTable.Columns.AddRange(new DataColumn[] { carIDColumn, carMakeColumn, carColorColumn, carPetNameColumn });
        inventoryTable.PrimaryKey = new DataColumn[] { inventoryTable.Columns[0] };
        foreach (Car c in arTheCars) {
            DataRow newRow = inventoryTable.NewRow();
            newRow["Make"] = c.carMake;
            newRow["Color"] = c.carColor;
            newRow["PetName"] = c.carPetName;
            inventoryTable.Rows.Add(newRow);
        }
        carInventoryGridView.DataSource = inventoryTable;
    }
    private void CreateDataView() {
        coltsOnlyView = new DataView(inventoryTable);
        coltsOnlyView.RowFilter = "Make = "Colt"";
        dataGridColtsView.DataSource = coltsOnlyView;
    }
    private void btnRemoveRow_Click(object sender, EventArgs e) {
        try {
            inventoryTable.Rows[(int.Parse(txtRowToRemove.Text))].Delete();
            inventoryTable.AcceptChanges();
        } catch (Exception ex) {
            MessageBox.Show(ex.Message);
        }
    }
    private void btnGetMakes_Click(object sender, EventArgs e) {
        string filterStr = string.Format("Make= "{0}" ", txtMakeToGet.Text);
        DataRow[] makes = inventoryTable.Select(filterStr, "PetName DESC");
        if (makes.Length == 0)
            MessageBox.Show("Sorry, no cars...", "Selection error!");
        else {
            string strMake = null;
            for (int i = 0; i < makes.Length; i++) {
                DataRow temp = makes[i];
                strMake += temp["PetName"] + "\n";
            }
            MessageBox.Show(strMake, txtMakeToGet.Text + " type(s):");
        }
    }
    private void btnChangeBeemersToColts_Click(object sender, EventArgs e) {
        string filterStr = "Make="BMW"";
        string strMake = null;
        DataRow[] makes = inventoryTable.Select(filterStr);
        for (int i = 0; i < makes.Length; i++) {
            DataRow temp = makes[i];
            strMake += temp["Make"] = "Colt";
            makes[i] = temp;
        }
    }
    private void ShowCarsWithIdLessThanFive() {
        DataRow[] properIDs;
        string newFilterStr = "ID > "5"";
        properIDs = inventoryTable.Select(newFilterStr);
        string strIDs = null;
        for (int i = 0; i < properIDs.Length; i++) {
            DataRow temp = properIDs[i];
            strIDs += temp["PetName"]
                + " is ID " + temp["ID"] + "\n";
        }
        MessageBox.Show(strIDs, "Pet names of cars where ID > 5");
    }
    private void InitializeComponent() {
        this.label1 = new System.Windows.Forms.Label();
        this.carInventoryGridView = new System.Windows.Forms.DataGridView();
        this.btnRemoveRow = new System.Windows.Forms.Button();
        this.txtRowToRemove = new System.Windows.Forms.TextBox();
        this.txtMakeToGet = new System.Windows.Forms.TextBox();
        this.btnGetMakes = new System.Windows.Forms.Button();
        this.btnChangeBeemersToColts = new System.Windows.Forms.Button();
        this.dataGridColtsView = new System.Windows.Forms.DataGridView();
        this.label2 = new System.Windows.Forms.Label();
        ((System.ruponentModel.ISupportInitialize)(this.carInventoryGridView)).BeginInit();
        ((System.ruponentModel.ISupportInitialize)(this.dataGridColtsView)).BeginInit();
        this.SuspendLayout();
        // 
        this.label1.AutoSize = true;
        this.label1.Location = new System.Drawing.Point(11, 76);
        this.label1.Name = "label1";
        this.label1.Size = new System.Drawing.Size(102, 13);
        this.label1.TabIndex = 0;
        this.label1.Text = "All Cars in DataTable";
        // 
        this.carInventoryGridView.Location = new System.Drawing.Point(12, 93);
        this.carInventoryGridView.Name = "carInventoryGridView";
        this.carInventoryGridView.Size = new System.Drawing.Size(392, 150);
        this.carInventoryGridView.TabIndex = 1;
        this.carInventoryGridView.Text = "dataGridView1";
        // 
        this.btnRemoveRow.Location = new System.Drawing.Point(12, 13);
        this.btnRemoveRow.Name = "btnRemoveRow";
        this.btnRemoveRow.Size = new System.Drawing.Size(101, 23);
        this.btnRemoveRow.TabIndex = 2;
        this.btnRemoveRow.Text = "Remove Row #";
        this.btnRemoveRow.Click += new System.EventHandler(this.btnRemoveRow_Click);
        // 
        this.txtRowToRemove.Location = new System.Drawing.Point(120, 15);
        this.txtRowToRemove.Name = "txtRowToRemove";
        this.txtRowToRemove.Size = new System.Drawing.Size(100, 20);
        this.txtRowToRemove.TabIndex = 3;
        // 
        this.txtMakeToGet.Location = new System.Drawing.Point(120, 44);
        this.txtMakeToGet.Name = "txtMakeToGet";
        this.txtMakeToGet.Size = new System.Drawing.Size(100, 20);
        this.txtMakeToGet.TabIndex = 5;
        // 
        // btnGetMakes
        // 
        this.btnGetMakes.Location = new System.Drawing.Point(12, 42);
        this.btnGetMakes.Name = "btnGetMakes";
        this.btnGetMakes.Size = new System.Drawing.Size(101, 23);
        this.btnGetMakes.TabIndex = 4;
        this.btnGetMakes.Text = "Get These Makes";
        this.btnGetMakes.Click += new System.EventHandler(this.btnGetMakes_Click);
        // 
        // btnChangeBeemersToColts
        // 
        this.btnChangeBeemersToColts.Location = new System.Drawing.Point(245, 15);
        this.btnChangeBeemersToColts.Name = "btnChangeBeemersToColts";
        this.btnChangeBeemersToColts.Size = new System.Drawing.Size(159, 23);
        this.btnChangeBeemersToColts.TabIndex = 6;
        this.btnChangeBeemersToColts.Text = "Change BMW to Colts";
        this.btnChangeBeemersToColts.Click += new System.EventHandler(this.btnChangeBeemersToColts_Click);
        // 
        // dataGridColtsView
        // 
        this.dataGridColtsView.Location = new System.Drawing.Point(12, 266);
        this.dataGridColtsView.Name = "dataGridColtsView";
        this.dataGridColtsView.Size = new System.Drawing.Size(392, 150);
        this.dataGridColtsView.TabIndex = 8;
        this.dataGridColtsView.Text = "dataGridView1";
        // 
        // label2
        // 
        this.label2.AutoSize = true;
        this.label2.Location = new System.Drawing.Point(11, 249);
        this.label2.Name = "label2";
        this.label2.Size = new System.Drawing.Size(76, 13);
        this.label2.TabIndex = 7;
        this.label2.Text = "Colts Only View";
        // 
        // MainForm
        // 
        this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
        this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
        this.ClientSize = new System.Drawing.Size(417, 433);
        this.Controls.Add(this.dataGridColtsView);
        this.Controls.Add(this.label2);
        this.Controls.Add(this.btnChangeBeemersToColts);
        this.Controls.Add(this.txtMakeToGet);
        this.Controls.Add(this.btnGetMakes);
        this.Controls.Add(this.txtRowToRemove);
        this.Controls.Add(this.btnRemoveRow);
        this.Controls.Add(this.carInventoryGridView);
        this.Controls.Add(this.label1);
        this.Name = "MainForm";
        this.Text = "Car Data Table";
        ((System.ruponentModel.ISupportInitialize)(this.carInventoryGridView)).EndInit();
        ((System.ruponentModel.ISupportInitialize)(this.dataGridColtsView)).EndInit();
        this.ResumeLayout(false);
        this.PerformLayout();
    }
    private System.Windows.Forms.Label label1;
    private System.Windows.Forms.DataGridView carInventoryGridView;
    private System.Windows.Forms.Button btnRemoveRow;
    private System.Windows.Forms.TextBox txtRowToRemove;
    private System.Windows.Forms.TextBox txtMakeToGet;
    private System.Windows.Forms.Button btnGetMakes;
    private System.Windows.Forms.Button btnChangeBeemersToColts;
    private System.Windows.Forms.DataGridView dataGridColtsView;
    private System.Windows.Forms.Label label2;
    [STAThread]
    static void Main() {
        Application.EnableVisualStyles();
        Application.Run(new MainForm());
    }
}

DataColumn.AutoIncrement

 

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
class Program {
    static void Main(string[] args) {
        DataSet carsInventoryDS = new DataSet("Inventory");
        carsInventoryDS.ExtendedProperties["TimeStamp"] = DateTime.Now;
        carsInventoryDS.ExtendedProperties["Company"] = "Name";
        DataColumn carIDColumn = new DataColumn("CarID", typeof(int));
        carIDColumn.ReadOnly = true;
        carIDColumn.Caption = "Car ID";
        carIDColumn.AllowDBNull = false;
        carIDColumn.Unique = true;
        carIDColumn.AutoIncrement = true;
        carIDColumn.AutoIncrementSeed = 0;
        carIDColumn.AutoIncrementStep = 1;
        carIDColumn.ColumnMapping = MappingType.Attribute;
        DataColumn carMakeColumn = new DataColumn("Make", typeof(string));
        DataColumn carColorColumn = new DataColumn("Color", typeof(string));
        DataColumn carPetNameColumn = new DataColumn("PetName", typeof(string));
        carPetNameColumn.Caption = "Name";
        DataTable inventoryTable = new DataTable("Inventory");
        inventoryTable.Columns.AddRange(new DataColumn[] { carIDColumn, carMakeColumn, carColorColumn, carPetNameColumn });
        inventoryTable.PrimaryKey = new DataColumn[] { inventoryTable.Columns[0] };
        DataRow carRow = inventoryTable.NewRow();
        carRow["Make"] = "B";
        carRow["Color"] = "C";
        carRow["PetName"] = "A";
        inventoryTable.Rows.Add(carRow);
        carRow = inventoryTable.NewRow();
        carRow["Make"] = "S";
        carRow["Color"] = "R";
        carRow["PetName"] = "E";
        inventoryTable.Rows.Add(carRow);
        carsInventoryDS.Tables.Add(inventoryTable);
        PrintTable(carsInventoryDS.Tables["Inventory"]);
    }
    private static void PrintTable(DataTable dt) {
        DataTableReader dtReader = dt.CreateDataReader();
        while (dtReader.Read()) {
            for (int i = 0; i < dtReader.FieldCount; i++) {
                Console.Write("{0} = {1} ",
                    dtReader.GetName(i).Trim(),
                    dtReader.GetValue(i).ToString().Trim());
            }
            Console.WriteLine();
        }
        dtReader.Close();
    }
}

DataColumn.AutoIncrementStep

 

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
class Program {
    static void Main(string[] args) {
        DataSet carsInventoryDS = new DataSet("Inventory");
        carsInventoryDS.ExtendedProperties["TimeStamp"] = DateTime.Now;
        carsInventoryDS.ExtendedProperties["Company"] = "Name";
        DataColumn carIDColumn = new DataColumn("CarID", typeof(int));
        carIDColumn.ReadOnly = true;
        carIDColumn.Caption = "Car ID";
        carIDColumn.AllowDBNull = false;
        carIDColumn.Unique = true;
        carIDColumn.AutoIncrement = true;
        carIDColumn.AutoIncrementSeed = 0;
        carIDColumn.AutoIncrementStep = 1;
        carIDColumn.ColumnMapping = MappingType.Attribute;
        DataColumn carMakeColumn = new DataColumn("Make", typeof(string));
        DataColumn carColorColumn = new DataColumn("Color", typeof(string));
        DataColumn carPetNameColumn = new DataColumn("PetName", typeof(string));
        carPetNameColumn.Caption = "Name";
        DataTable inventoryTable = new DataTable("Inventory");
        inventoryTable.Columns.AddRange(new DataColumn[] { carIDColumn, carMakeColumn, carColorColumn, carPetNameColumn });
        inventoryTable.PrimaryKey = new DataColumn[] { inventoryTable.Columns[0] };
        DataRow carRow = inventoryTable.NewRow();
        carRow["Make"] = "B";
        carRow["Color"] = "C";
        carRow["PetName"] = "A";
        inventoryTable.Rows.Add(carRow);
        carRow = inventoryTable.NewRow();
        carRow["Make"] = "S";
        carRow["Color"] = "R";
        carRow["PetName"] = "E";
        inventoryTable.Rows.Add(carRow);
        carsInventoryDS.Tables.Add(inventoryTable);
        PrintTable(carsInventoryDS.Tables["Inventory"]);
    }
    private static void PrintTable(DataTable dt) {
        DataTableReader dtReader = dt.CreateDataReader();
        while (dtReader.Read()) {
            for (int i = 0; i < dtReader.FieldCount; i++) {
                Console.Write("{0} = {1} ",
                    dtReader.GetName(i).Trim(),
                    dtReader.GetValue(i).ToString().Trim());
            }
            Console.WriteLine();
        }
        dtReader.Close();
    }
}

DataColumn.Caption

 


using System;
using System.Data;
using System.Data.SqlClient;
    public class CreatingDataTablesandPopulatingThem
    {
        static void Main(string[] args)
        {
            SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
            SqlDataAdapter MyAdapter = new SqlDataAdapter("SELECT * FROM CaseInfo", MyConnection);
            DataSet MyDataSet = new DataSet();
            //Create a new DataTable
            DataTable MyTable2 = MyDataSet.Tables.Add("My2ndTable");
            //Adding Columns and Rows
            DataColumn myColumn = new DataColumn();
            myColumn.DataType = System.Type.GetType("System.Decimal");
            myColumn.AllowDBNull = false;
            myColumn.Caption = "Price";
            myColumn.ColumnName = "Price";
            myColumn.DefaultValue = 25;
            // Add the column to the table. 
            MyTable2.Columns.Add(myColumn);
            // Add 10 rows and set values. 
            DataRow myRow;
            for (int i = 0; i < 10; i++)
            {
                myRow = MyTable2.NewRow();
                myRow[0] = i + 1;
                // Be sure to add the new row to the DataRowCollection. 
                MyTable2.Rows.Add(myRow);
            }
            SqlCommandBuilder Builder = new SqlCommandBuilder(MyAdapter);
            MyAdapter.Update(MyDataSet, "My2ndTable");
        }
    }

DataColumn.ColumnMapping

 

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
class Program {
    static void Main(string[] args) {
        DataSet carsInventoryDS = new DataSet("Inventory");
        carsInventoryDS.ExtendedProperties["TimeStamp"] = DateTime.Now;
        carsInventoryDS.ExtendedProperties["Company"] = "Name";
        DataColumn carIDColumn = new DataColumn("CarID", typeof(int));
        carIDColumn.ReadOnly = true;
        carIDColumn.Caption = "Car ID";
        carIDColumn.AllowDBNull = false;
        carIDColumn.Unique = true;
        carIDColumn.AutoIncrement = true;
        carIDColumn.AutoIncrementSeed = 0;
        carIDColumn.AutoIncrementStep = 1;
        carIDColumn.ColumnMapping = MappingType.Attribute;
        DataColumn carMakeColumn = new DataColumn("Make", typeof(string));
        DataColumn carColorColumn = new DataColumn("Color", typeof(string));
        DataColumn carPetNameColumn = new DataColumn("PetName", typeof(string));
        carPetNameColumn.Caption = "Name";
        DataTable inventoryTable = new DataTable("Inventory");
        inventoryTable.Columns.AddRange(new DataColumn[] { carIDColumn, carMakeColumn, carColorColumn, carPetNameColumn });
        inventoryTable.PrimaryKey = new DataColumn[] { inventoryTable.Columns[0] };
        DataRow carRow = inventoryTable.NewRow();
        carRow["Make"] = "B";
        carRow["Color"] = "C";
        carRow["PetName"] = "A";
        inventoryTable.Rows.Add(carRow);
        carRow = inventoryTable.NewRow();
        carRow["Make"] = "S";
        carRow["Color"] = "R";
        carRow["PetName"] = "E";
        inventoryTable.Rows.Add(carRow);
        carsInventoryDS.Tables.Add(inventoryTable);
        PrintTable(carsInventoryDS.Tables["Inventory"]);
    }
    private static void PrintTable(DataTable dt) {
        DataTableReader dtReader = dt.CreateDataReader();
        while (dtReader.Read()) {
            for (int i = 0; i < dtReader.FieldCount; i++) {
                Console.Write("{0} = {1} ",
                    dtReader.GetName(i).Trim(),
                    dtReader.GetValue(i).ToString().Trim());
            }
            Console.WriteLine();
        }
        dtReader.Close();
    }
}

DataColumn.ColumnName

 


using System;
using System.Data;
using System.Data.SqlClient;
    public class CreatingDataTablesandPopulatingThem
    {
        static void Main(string[] args)
        {
            SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
            SqlDataAdapter MyAdapter = new SqlDataAdapter("SELECT * FROM CaseInfo", MyConnection);
            DataSet MyDataSet = new DataSet();
            //Create a new DataTable
            DataTable MyTable2 = MyDataSet.Tables.Add("My2ndTable");
            //Adding Columns and Rows
            DataColumn myColumn = new DataColumn();
            myColumn.DataType = System.Type.GetType("System.Decimal");
            myColumn.AllowDBNull = false;
            myColumn.Caption = "Price";
            myColumn.ColumnName = "Price";
            myColumn.DefaultValue = 25;
            // Add the column to the table. 
            MyTable2.Columns.Add(myColumn);
            // Add 10 rows and set values. 
            DataRow myRow;
            for (int i = 0; i < 10; i++)
            {
                myRow = MyTable2.NewRow();
                myRow[0] = i + 1;
                // Be sure to add the new row to the DataRowCollection. 
                MyTable2.Rows.Add(myRow);
            }
            SqlCommandBuilder Builder = new SqlCommandBuilder(MyAdapter);
            MyAdapter.Update(MyDataSet, "My2ndTable");
        }
    }

DataColumn.DataType

 

using System;
using System.Data;
using System.Data.SqlClient;
    public class CreatingDataTablesandPopulatingThem
    {
        static void Main(string[] args)
        {
            SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
            SqlDataAdapter MyAdapter = new SqlDataAdapter("SELECT * FROM CaseInfo", MyConnection);
            DataSet MyDataSet = new DataSet();
            //Create a new DataTable
            DataTable MyTable2 = MyDataSet.Tables.Add("My2ndTable");
            //Adding Columns and Rows
            DataColumn myColumn = new DataColumn();
            myColumn.DataType = System.Type.GetType("System.Decimal");
            myColumn.AllowDBNull = false;
            myColumn.Caption = "Price";
            myColumn.ColumnName = "Price";
            myColumn.DefaultValue = 25;
            // Add the column to the table. 
            MyTable2.Columns.Add(myColumn);
            // Add 10 rows and set values. 
            DataRow myRow;
            for (int i = 0; i < 10; i++)
            {
                myRow = MyTable2.NewRow();
                myRow[0] = i + 1;
                // Be sure to add the new row to the DataRowCollection. 
                MyTable2.Rows.Add(myRow);
            }
            SqlCommandBuilder Builder = new SqlCommandBuilder(MyAdapter);
            MyAdapter.Update(MyDataSet, "My2ndTable");
        }
    }

DataColumn.DefaultValue

 


using System;
using System.Data;
using System.Data.SqlClient;
    public class CreatingDataTablesandPopulatingThem
    {
        static void Main(string[] args)
        {
            SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
            SqlDataAdapter MyAdapter = new SqlDataAdapter("SELECT * FROM CaseInfo", MyConnection);
            DataSet MyDataSet = new DataSet();
            //Create a new DataTable
            DataTable MyTable2 = MyDataSet.Tables.Add("My2ndTable");
            //Adding Columns and Rows
            DataColumn myColumn = new DataColumn();
            myColumn.DataType = System.Type.GetType("System.Decimal");
            myColumn.AllowDBNull = false;
            myColumn.Caption = "Price";
            myColumn.ColumnName = "Price";
            myColumn.DefaultValue = 25;
            // Add the column to the table. 
            MyTable2.Columns.Add(myColumn);
            // Add 10 rows and set values. 
            DataRow myRow;
            for (int i = 0; i < 10; i++)
            {
                myRow = MyTable2.NewRow();
                myRow[0] = i + 1;
                // Be sure to add the new row to the DataRowCollection. 
                MyTable2.Rows.Add(myRow);
            }
            SqlCommandBuilder Builder = new SqlCommandBuilder(MyAdapter);
            MyAdapter.Update(MyDataSet, "My2ndTable");
        }
    }

new DataColumn

 

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
class Program {
    static void Main(string[] args) {
        DataSet carsInventoryDS = new DataSet("Inventory");
        carsInventoryDS.ExtendedProperties["TimeStamp"] = DateTime.Now;
        carsInventoryDS.ExtendedProperties["Company"] = "Name";
        DataColumn carIDColumn = new DataColumn("CarID", typeof(int));
        carIDColumn.ReadOnly = true;
        carIDColumn.Caption = "Car ID";
        carIDColumn.AllowDBNull = false;
        carIDColumn.Unique = true;
        carIDColumn.AutoIncrement = true;
        carIDColumn.AutoIncrementSeed = 0;
        carIDColumn.AutoIncrementStep = 1;
        carIDColumn.ColumnMapping = MappingType.Attribute;
        DataColumn carMakeColumn = new DataColumn("Make", typeof(string));
        DataColumn carColorColumn = new DataColumn("Color", typeof(string));
        DataColumn carPetNameColumn = new DataColumn("PetName", typeof(string));
        carPetNameColumn.Caption = "Name";
        DataTable inventoryTable = new DataTable("Inventory");
        inventoryTable.Columns.AddRange(new DataColumn[] { carIDColumn, carMakeColumn, carColorColumn, carPetNameColumn });
        inventoryTable.PrimaryKey = new DataColumn[] { inventoryTable.Columns[0] };
        DataRow carRow = inventoryTable.NewRow();
        carRow["Make"] = "B";
        carRow["Color"] = "C";
        carRow["PetName"] = "A";
        inventoryTable.Rows.Add(carRow);
        carRow = inventoryTable.NewRow();
        carRow["Make"] = "S";
        carRow["Color"] = "R";
        carRow["PetName"] = "E";
        inventoryTable.Rows.Add(carRow);
        carsInventoryDS.Tables.Add(inventoryTable);
        PrintTable(carsInventoryDS.Tables["Inventory"]);
    }
    private static void PrintTable(DataTable dt) {
        DataTableReader dtReader = dt.CreateDataReader();
        while (dtReader.Read()) {
            for (int i = 0; i < dtReader.FieldCount; i++) {
                Console.Write("{0} = {1} ",
                    dtReader.GetName(i).Trim(),
                    dtReader.GetValue(i).ToString().Trim());
            }
            Console.WriteLine();
        }
        dtReader.Close();
    }
}