private void addColumns(IColumnedObject table)
{
string sql = string.Format(sqlColumns, table.Name);
string dbConn = ConnectionString;
var cn = new SQLiteConnection(dbConn);
cn.Open();
var cmd = new SQLiteCommand(sql, cn);
SQLiteDataReader rd = cmd.ExecuteReader(CommandBehavior.SchemaOnly);
DataTable dt = rd.GetSchemaTable();
rd.Close();
foreach (DataRow dr in dt.Rows)
{
string columnName = dr.Field <string>("ColumnName");
bool isKey = dr.Field <bool>("IsKey");
string dataTypeName = dr.Field <string>("DataTypeName");
// string provDataTypeName = dr.Field<string>("ProviderSpecificDataType");
short?numericPrecision = dr.Field <short?>("NumericPrecision");
int id = dr.Field <int>("ColumnOrdinal");
int numPres = -1;
if (numericPrecision.HasValue)
{
numPres = numericPrecision.Value;
}
Sql8rColumn c = new Sql8rColumn(columnName, isKey, dataTypeName, numPres, id);
table.Columns.Add(c.ObjectId, c);
}
}
private void bindDataTable(Query query, IColumnedObject o)
{
bindDataTable(query);
if (_view.grdData.DisplayLayout.Bands.Count > 0)
{
foreach (Sql8rColumn c in o.Columns.Values)
{
if (c.InPrimaryKey)
{
UltraGridColumn ugc = getColumn(_view.grdData.DisplayLayout.Bands[0], c.Name);
if (ugc != null)
{
ugc.Header.Appearance.Image = MainPresenter.Instance.View.TreeImageList.Images[5];
ugc.CellClickAction = CellClickAction.RowSelect;
}
}
}
}
}
private void addColumns(IColumnedObject table)
{
}
private IList <SearchHit> checkForHit(Sql8rServer s, Sql8rDatabase db, bool isSystemObject, string objectType, IColumnedObject o, string criteria, bool exactMatch, bool caseSensitive)
{
IList <SearchHit> hits = new List <SearchHit>();
StringComparison cases = StringComparison.OrdinalIgnoreCase;
if (caseSensitive)
{
cases = StringComparison.Ordinal;
}
foreach (Sql8rColumn c in o.Columns.Values)
{
bool IsMatch = false;
if (exactMatch)
{
if (c.Name.Equals(criteria, cases))
{
IsMatch = true;
}
}
else
{
if (c.Name.IndexOf(criteria, cases) >= 0)
{
IsMatch = true;
}
}
if (IsMatch)
{
var hit = new SearchHit(s.Name, db.Name, isSystemObject, objectType, o.Schema, o.Name, c.Name);
hits.Add(hit);
}
}
return(hits);
}
