public abstract string deleteRow(string tablename, ColVal key);
public override string deleteRow(string tablename, ColVal key)
{
throw new NotImplementedException();
}
public abstract string updateRow(string tablename, List <ColVal> values, ColVal key);
public abstract string deleteRow(string tablename, ColVal key);
public override string updateRow(string tablename, List <ColVal> values, ColVal key)
{
throw new NotImplementedException();
}
public abstract string updateRow(string tablename, List<ColVal> values, ColVal key);
public override string updateRow(string tablename, List<ColVal> values, ColVal key)
{
string commandText = ("UPDATE [" + tablename + "] SET ");
bool putcolumn = false;
foreach (ColVal cv in values)
{
if (putcolumn) commandText += ",";
putcolumn = true;
commandText += " [" + cv.NameOfCol + "] = '" + cv.ColValue + "' ";
}
commandText += " WHERE ["+key.NameOfCol+"]= '"+key.ColValue+"'";
return commandText;
}
public override string deleteRow(string tablename, ColVal key)
{
string commandtext = "DELETE FROM " + tablename + " WHERE [" + key.NameOfCol + "]='" + key.ColValue + "'";
return commandtext;
}
public override string updateRow(string tablename, List<ColVal> values, ColVal key)
{
throw new NotImplementedException();
}
public override string deleteRow(string tablename, ColVal key)
{
throw new NotImplementedException();
}