DataTable- retreiving Description Field from schema

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

If you go to the Design View for any database table in MS Access, you
will find three fields-

1. Field Name - e.g. "PointID"
2. Data Type - e.g. "Text"
3. Description - e.g. "ID of the point"

The first two are accessible from a dataset that has been properly
'filled', using

1. m_DataSet.Tables[TableName].Columns[index].ColumnName
2. m_DataSet.Tables[TableName].Columns[index].DataType

How do I read the third field, viz. "Description"

Thanks...
Sam
 
Hi,

There is no built in support.
One way would be to use OleDbConnection.GetOleDbSchemaTables method or use
database specific sql statements.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SqlDataAdapter and/or SqlCommandBilder Problem 2
DataSet Textbox Time 3
Sort structure on date 4
how to get the id of the inserted datarow? 3
Trying to link DataGrideTableStyle to DataGrid 2
Access DS TextBox - wrong value 4
DataTable Binding with DataGridView -- Doco Example Needs Work 3
Transform DataTables 3

Back
Top