DataTable t = Ctx.con.GetSchema(OleDbMetaDataCollectionNames.Columns); StringBuilder sb = new StringBuilder(); foreach(DataRow r in t.Rows){ foreach(DataColumn c in t.Columns){ sb.Append(String.Format("{0}: {1}||",c.ColumnName,r[c.ColumnName])); } sb.AppendLine(); } Clipboard.SetText(sb.ToString()); MessageBox.Show(sb.ToString()); DataRow []dr = t.Select("TABLE_NAME = 'AnoActual' and COLUMN_NAME = 'Ano'"); MessageBox.Show(dr[0]["TABLE_NAME"].ToString() + dr[0]["COLUMN_NAME"].ToString());
6/3/14
Obtener información de catálogo de Base de datos Access
Suscribirse a:
Entradas (Atom)