Results 1 to 3 of 3

Thread: datareader - number of cols

  1. Jul 26th, 2005, 06:07 AM #1
    ronlahav
    ronlahav is offline

    Thread Starter
    Addicted Member
    Join Date
    Jan 2003
    Posts
    175

    datareader - number of cols

    dir all
    I have datareader object that holds an sql (select *) result. i need to know how many columns this datagrid holds - the result of the sql is comming from access file - mabe i can retrieve this data by sql to the access file???
    thnks
    Reply With Quote Reply With Quote
  2. Jul 26th, 2005, 10:32 AM #2
    dj4uk
    dj4uk is offline
    Frenzied Member dj4uk's Avatar
    Join Date
    Aug 2002
    Location
    Birmingham, UK Lobotomies: 3
    Posts
    1,131

    Re: datareader - number of cols

    All the datareaders have a FieldCount property - this should do what you want - DataReader1.FieldCount

    Also you can access the number of columns a DataGrid contains - DataGrid1.Columns.Count

    HTH

    DJ

    If I have been helpful please rate my post. If I haven't tell me!
    Reply With Quote Reply With Quote
  3. Jul 27th, 2005, 01:28 AM #3
    ronlahav
    ronlahav is offline

    Thread Starter
    Addicted Member
    Join Date
    Jan 2003
    Posts
    175

    Re: datareader - number of cols

    thnks alot - you helped me
    the FieldCount is better for me because im generating script to the client in the server and i don use datagrid to show data.
    Thnks alot
    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