matt-awg wrote: If you are just asking for a way to insert row in a custom table.... here is a generic function I wrote that you can reuse for any table. you pass it a dictionary of field name/values to insert so it is totally flexible.

    public static bool AddNewCustomTableItem(CMS.SiteProvider.UserInfo uiObj, string customTableClassName, Dictionary<string, Object> setNameAndValues, ref string statMsg)
    {
        CustomTableItemProvider customTableProvider = new CustomTableItemProvider(uiObj);

        // Checks if Custom table exists
        DataClassInfo customTable = DataClassInfoProvider.GetDataClass(customTableClassName);
        if (customTable != null)
        {
            // Creates new custom table item
            CustomTableItem newCustomTableItem = CustomTableItem.New(customTableClassName, customTableProvider);

            // Set new values based on looping through dictionary object of fields and values to update
            foreach (KeyValuePair<String, Object> pair in setNameAndValues)
            {
                string fldName = pair.Key;
                if (fldName.EndsWith("~NULL"))
                {
                    //ending in "~NULL" is a code we are using to indicate a field should be null not empty string, which requires different SetValue call
                    newCustomTableItem.SetValue(fldName.Replace("~NULL", ""), pair.Value, false);
                }
                else
                {
                    newCustomTableItem.SetValue(fldName, pair.Value);
                }
            }

            // Inserts the custom table item into database
            try
            {
                newCustomTableItem.Insert();
                statMsg += "Success<br />";
                return true;
            }
            catch (Exception ex)
            {
                statMsg += "  Error was: " + ex.Message + ".<br />";
            }
        }
        else
        {
            statMsg += " This custom table does not exist.<br />";
        }

        return false;
    }

public static bool CreateCustomTableItem(DataClassInfo Dci, DataRow Row)
{
    bool okInsert = false;

    // Creates new Custom table item provider
    CustomTableItemProvider customTableProvider = new CustomTableItemProvider(ui);

    if (Dci == null)
    {
        throw new Exception("Data class info cannot be null.");
    }
    else
    {
        // Creates new custom table item object
        CustomTableItem newCustomTableItem = CustomTableItem.New(Dci.ClassName, customTableProvider);

        List<string> classProperties = new List<string>();
        // get the class definition
        var doc = XDocument.Parse(Dci.ClassFormDefinition);
        // get a list of all the tables properties by column value
        List<string> elements = doc.Descendants("field").Select(el => el.Attribute("column").Value).ToList();

        // got the class properties now compare
        foreach (string s in elements)
        {
            // see if the class info contains the column in the data row passed in this method
            if (Row.Table.Columns.Contains(s))
            {
                // contains the column so set a value
                newCustomTableItem.SetValue(s, Row);
                okInsert = true;
            }
        }

        if (okInsert)
        {
            // Inserts the custom table item into database
            newCustomTableItem.Insert();
        }
    }
    return okInsert;
}