public static string ToString(SqlCommand cmd) { StringBuilder s = new StringBuilder(); s.AppendLine(cmd.CommandText); foreach (SqlParameter p in cmd.Parameters) { s.AppendLine(UStr.Bracket(p.ParameterName) + " = " + UStr.Bracket(p.Value)); } return(s.ToString()); }
public static string ToString(DataRow row) { if (row == null) { return(""); } StringBuilder s = new StringBuilder(); s.AppendLine("Table Name = " + UStr.Bracket(row.Table.TableName)); foreach (DataColumn col in row.Table.Columns) { s.AppendLine(UStr.Bracket(col.ColumnName) + " = " + UStr.Bracket(row[col.ColumnName])); } return(s.ToString()); }
public static string FilterExact(string columnName, object value) { return(UStr.Bracket(columnName) + "='" + value + "'"); }
public static string FilterInt32(string columnName, object value) { return(UStr.Bracket(columnName) + "=" + value); }
public static string FilterParam(string columnName, object value) { return("LOWER(" + UStr.Bracket(columnName) + ") LIKE LOWER(" + value + ")"); }