Print DataSet out : DataSet : Database C# Source Code

Print DataSet out

    


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

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

class Program {
    static void Main(string[] args) {
        string cnStr = "uid=sa;pwd=;Initial Catalog=yourDatabase;Data Source=(local)";
        DataSet myDS = new DataSet("Cars");
        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");

        try {
            dAdapt.Fill(myDS, "Inventory");
        } catch (Exception ex) {
            Console.WriteLine(ex.Message);
        }
        PrintDataSet(myDS);
    }
    static void PrintDataSet(DataSet ds) {
        Console.WriteLine("Tables in '{0}' DataSet.\n", ds.DataSetName);
        foreach (DataTable dt in ds.Tables) {
            Console.WriteLine("{0} Table.\n", dt.TableName);
            for (int curCol = 0; curCol < dt.Columns.Count; curCol++) {
                Console.Write(dt.Columns[curCol].ColumnName.Trim() + "\t");
            }
            for (int curRow = 0; curRow < dt.Rows.Count; curRow++) {
                for (int curCol = 0; curCol < dt.Columns.Count; curCol++) {
                    Console.Write(dt.Rows[curRow][curCol].ToString().Trim() + "\t");
                }
                Console.WriteLine();
            }
        }
    }

}


           
       
    
   
  
   

Related in same category :
• 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
• Read data from DataSet