public DataSet CreateDataSet( 
   string sql 
)

using System.Data;

namespace Dynamicweb.Examples.CSharp
{
class DataManagerSample
{
    public int Save(int id)
    {
        //Create a new datamanager instance
        using (var dtm = new DataManager())
        {
            //Create a dataset with zero, one or more rows to update.
            var ds = dtm.CreateDataSet("SELECT * FROM UrlPath WHERE UrlPathID=" + id, "Dynamic.mdb");
            DataRow row;

            //If the id is 0, there will be no records in the returned dataset
            if (id == 0)
            {
                //Add a new row to the table in the dataset
                row = ds.Tables[0].NewRow();
                ds.Tables[0].Rows.Add(row);
                //Set column values that only needs to be set on new rows
                row["UrlPathCreated"] = System.DateTime.Now;
            }
            else
            {
                //We had a record in the table
                row = ds.Tables[0].Rows[0];
            }

            //Update the column values
            row["UrlPathPath"] = "Contact";
            row["UrlPathRedirect"] = "Default.aspx?ID=1";
            row["UrlPathStatus"] = 301;
            row["UrlPathUpdated"] = System.DateTime.Now;
            row["UrlPathActive"] = true;

            //Pass the dataset to the datamanagers UpdateDataset method that will commit our changes to the database
            dtm.Update(ds);

            //If the id is 0, it was a new record - GetIdentity will return the id of the newest row added.
            if (id == 0)
            {
                id = dtm.GetAddedIdentityKey();
            }

            //Dispose the dataset
            ds.Dispose();
        }
        return id;
    }

}
}