public string GetInsertStatement(object[] row) { StringBuilder a = new StringBuilder(); a.Append("INSERT INTO \""); a.Append(Name); a.Append("\" VALUES("); for (int i = 0; i < iVisibleColumns; i++) { if (i > 0) { a.Append(','); } a.Append(Column.CreateString(row[i], GetColumn(i).ColumnType)); } a.Append(')'); return(a.ToString()); }
private string GetDeleteStatement(object[] row) { StringBuilder a = new StringBuilder(); a.Append("DELETE FROM \""); a.Append(sName); a.Append("\" WHERE "); if (iVisibleColumns < iColumnCount) { for (int i = 0; i < iVisibleColumns; i++) { a.Append('"'); a.Append(GetColumn(i).Name); a.Append('"'); a.Append('='); a.Append(Column.CreateString(row[i], GetColumn(i).ColumnType)); if (i < iVisibleColumns - 1) { a.Append(" AND "); } } } else { a.Append('"'); a.Append(GetColumn(iPrimaryKey).Name); a.Append('"'); a.Append("="); a.Append(Column.CreateString(row[iPrimaryKey], GetColumn(iPrimaryKey).ColumnType)); } return(a.ToString()); }