All pastes #431594 Raw Edit

Something

public text v1 · immutable
·published 2007-04-09 19:50 UTC
rendered paste body
// putting the parameter string together
            cmds["model"].CommandText = "INSERT INTO models (firstName, surName, facePicture) VALUES (?, ?, ?)";
            parameters.Add("modelparamsFirstname", new SQLiteParameter());
            parameters.Add("modelparamsSurname", new SQLiteParameter());
            parameters.Add("modelparamsFacepicture", new SQLiteParameter());

public void insertModelData(path)
{
            string[] modelname;
            // get model name from image name - returns a null array on fail
            modelname = getModelPicture(path);

            parameters["modelparamsFirstname"].Value = modelname[0];
            parameters["modelparamsSurname"].Value = null;

            if (modelname[0] != null)
                parameters["modelparamsFacepicture"].Value = System.IO.File.ReadAllBytes(path + "/" + modelname[1]);
            else
                parameters["modelparamsFacepicture"].Value = null;

            cmds["model"].ExecuteNonQuery();
}