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:
Enviar comentarios (Atom)
No hay comentarios:
Publicar un comentario