private void button1_Click(object sender, EventArgs e)
        {
            //connect the to the database
            OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb");
            connection.Open();

            //create the adapters
            OleDbDataAdapter channelAdapter = new OleDbDataAdapter("Select * From channel",connection);
            OleDbDataAdapter threadAdapter = new OleDbDataAdapter("Select * From thread", connection);
            OleDbDataAdapter postAdapter = new OleDbDataAdapter("Select * From post", connection);

            //create the command builders
            OleDbCommandBuilder channelCommandBuilder = new OleDbCommandBuilder(channelAdapter);
            OleDbCommandBuilder threadCommandBuilder = new OleDbCommandBuilder(threadAdapter);
            OleDbCommandBuilder postCommandBuilder = new OleDbCommandBuilder(postAdapter);
            DataSet ds = new DataSet();

            //create the schemas
            channelAdapter.FillSchema(ds, SchemaType.Source);
            ds.Tables["Table"].TableName = "channel";
            threadAdapter.FillSchema(ds, SchemaType.Source);
            ds.Tables["Table"].TableName = "thread";
            postAdapter.FillSchema(ds,SchemaType.Source);
            ds.Tables["Table"].TableName = "post";
            
            //create the relationships
            ds.Relations.Add("ChannelThread", ds.Tables["channel"].Columns["url"], ds.Tables["thread"].Columns["channel"]);
            ds.Relations.Add("ThreadPost", ds.Tables["thread"].Columns["url"], ds.Tables["post"].Columns["thread"]);

            //create the tables
            channelAdapter.Fill(ds,"channel");
            threadAdapter.Fill(ds, "thread");
            postAdapter.Fill(ds, "post");

            //below is just for testing
            DataRow ch = ds.Tables["channel"].NewRow();
            DataRow th = ds.Tables["thread"].NewRow();

            ch["url"] = "http://google.com";
            ch["title"] = "Google";
            ch["type"] = "podcast";
            ch["description"] = "some text here";

            th["url"] = "http://google.com/thread1.htm";
            th["title"] = "google thread 1";
            th["channel"] = "http://google.com";
            ds.Tables["channel"].Rows.Add(ch);
            ds.Tables["thread"].Rows.Add(th);
            channelAdapter.Update(ds, "channel");
            threadAdapter.Update(ds, "thread");
        }