HELP!!!!
I am attempting to write a SQL insert statement, but not having too much luck. I am attempting to write it as a business object, and modeling it based on the code below. I am capturing the data from a web page, from lookups and data entered into text boxes. I do not want to write the record into the main table until all data is validated on the web page, and insert it all ay once to create the master record. I intend passing the data to the business object as parameters, returning the new dataset. This is holding up my whole project.

Please see the cide I am using for the lookup tables below.
_________________________________________________________________________
using System;
using System.Data;

using OakLeaf.MM.Main.Business;
using OakLeaf.MM.Main.Data;
using PMR.Business;


namespace PMR.Business
{
///

/// Summary description for Employee.
///

public class Program : ABusinessObject
{
public Program()
{
this.TableName = "Program";
this.PrimaryKey = "Program_ID";
}

///

/// Returns all Programs
///

/// DataSet containing all employees
public DataSet GetPrograms()
{
return this.GetDataSet("SELECT * From Program ORDER by Srt_Order");
}

}
}
____________________________________________________________________

I would greatly appreciate any advice you can offer.


TIA.