Asp.net 3.5 - Créer un DataSet from Scratch en C#

C’est la base, et pourtant de nos jours, devant la débauche de technologie dont on dispose, on l’oublie facilement.

Voici un petit rappel :

using System;

using System.Data;

namespace CrtDataSet

{

    class Program

    {

        static void Main(string[] args)

        {

            //-- Instantiate the data set and table

            DataSet SongDS = new DataSet();

            DataTable songTable = SongDS.Tables.Add();

            //-- Add columns to the data table

            songTable.Columns.Add("ID", typeof(int));

            songTable.Columns.Add("Band", typeof(string));

            songTable.Columns.Add("Song", typeof(string));

            //-- Add rows to the data table

            songTable.Rows.Add(1, "Breaking Benjamin", "Diary of Jane");

            songTable.Rows.Add(2, "Three Days Grace", "Pain");

            songTable.Rows.Add(3, "Seether", "Fake It");

            songTable.Rows.Add(4, "Finger Eleven", "Paralyzer");

            songTable.Rows.Add(5, "Three Doors Down", "Citizen Soldier");

            //-- Cycle thru the data table printing the values to the screen

            foreach (DataTable table in SongDS.Tables)

            {

                foreach (DataRow row in table.Rows)

                {

                    Console.WriteLine(row["Band"] + " ~ " + row["Song"] );

                }

            }

        }

    }

}

 

Source

http://rtipton.wordpress.com/2008/01/12/creating-a-data-set-from-scratch-in-c/