Results 1 to 8 of 8

Thread: Read Column Type, Lengtg from Access Tables

  1. Nov 21st, 2004, 11:27 PM #1
    Andreex
    Andreex is offline

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Posts
    843

    Read Column Type, Lengtg from Access Tables

    Hi everyone. I am trying to read the table columns definitions of tables in an access database. How can I do this?

    Thank you very much...!
    Last edited by Andreex; Nov 22nd, 2004 at 09:57 AM.
    "The difference between mad and genius is the success"
    Reply With Quote Reply With Quote
  2. Nov 22nd, 2004, 09:02 AM #2
    Andreex
    Andreex is offline

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Posts
    843
    bump
    "The difference between mad and genius is the success"
    Reply With Quote Reply With Quote
  3. Nov 22nd, 2004, 09:18 AM #3
    Asgorath
    Asgorath is offline
    Frenzied Member Asgorath's Avatar
    Join Date
    Sep 2004
    Location
    Saturn
    Posts
    2,036
    Hi

    Well checkout the dataset class in msdn there's everything you need...

    Regards
    Jorge
    "The dark side clouds everything. Impossible to see the future is."
    Reply With Quote Reply With Quote
  4. Nov 22nd, 2004, 09:56 AM #4
    Andreex
    Andreex is offline

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Posts
    843
    how can the dataset help me reading the column type, length, if it is the primary key, max length of field, etc???
    "The difference between mad and genius is the success"
    Reply With Quote Reply With Quote
  6. Nov 22nd, 2004, 10:22 AM #5
    Asgorath
    Asgorath is offline
    Frenzied Member Asgorath's Avatar
    Join Date
    Sep 2004
    Location
    Saturn
    Posts
    2,036
    Hi

    As you know a dataset is a collection of datatables and each datatable is a collection of DataColumn and DataRow. The DataColumn has many useful properties one of them being .DataType.

    Just browse all DataColumns of each table you need to gather information.

    Regards
    Jorge
    "The dark side clouds everything. Impossible to see the future is."
    Reply With Quote Reply With Quote
  7. Nov 22nd, 2004, 10:33 AM #6
    Andreex
    Andreex is offline

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Posts
    843
    ok sounds good.... oh... hummm... so when yo do a dataadapter.fill(table) the table object columns will have that info automatically?????
    "The difference between mad and genius is the success"
    Reply With Quote Reply With Quote
  8. Nov 22nd, 2004, 10:38 AM #7
    Asgorath
    Asgorath is offline
    Frenzied Member Asgorath's Avatar
    Join Date
    Sep 2004
    Location
    Saturn
    Posts
    2,036
    Originally posted by Andreex
    ok sounds good.... oh... hummm... so when yo do a dataadapter.fill(table) the table object columns will have that info automatically?????
    Yes if you select all fields in the table like this 'select * from Mytable'

    Regards
    Jorge
    "The dark side clouds everything. Impossible to see the future is."
    Reply With Quote Reply With Quote
  9. Nov 22nd, 2004, 11:55 AM #8
    Andreex
    Andreex is offline

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Posts
    843
    oh ok... well that makes a lot of sense...

    thanks a lot for your help
    "The difference between mad and genius is the success"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width