Пример #1
0
        private List<Column> GetColumns(Table table)
        {
            List<Column> cols;
            using (IDbConnection db = _factory.OpenDbConnection())
            {
                var sql = string.Format("select *  from information_schema.columns where LOWER(table_name) =LOWER('{0}') order by ordinal_position", table.Table_Name);
                cols= db.Select<Column>(sql);
            }

            cols = PopulateColumnMetaData(cols);
            return cols;

        }
Пример #2
0
 private string GenerateForm(Table table)
 {
     var sb = new StringBuilder();
     foreach (var c in table.Columns)
     {
         sb.AppendFormat("<input type={0}");
     }
     return sb.ToString();
 }