// 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();
}