Problem while reading from excel

Discussion in 'ASP .Net' started by Gomathi, Feb 13, 2006.

  1. Gomathi

    Gomathi Guest

    hi,

    I'm reading an excel sheet which contains more than 500 chars in a single
    column using OledbDataReader. But while reading value using
    dr[0].toString(), its taking only 255 chars. It removed the remaining chars.
    How to solve this problem?

    thanks in advance.
    regards,
    Gomathi
     
    Gomathi, Feb 13, 2006
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?UGF1cmF2aQ==?=

    Problem while reading excel file with mix datatypes

    =?Utf-8?B?UGF1cmF2aQ==?=, Mar 2, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    724
    Alvin Bruney [MVP]
    Mar 4, 2004
  2. =?Utf-8?B?U2lsZWVzaA==?=
    Replies:
    4
    Views:
    578
    =?Utf-8?B?U2lsZWVzaA==?=
    Nov 5, 2004
  3. =?Utf-8?B?U2lsZWVzaA==?=
    Replies:
    1
    Views:
    894
    Jim Corey
    Nov 8, 2004
  4. Yelena Kaplun
    Replies:
    1
    Views:
    5,492
    Yelena Kaplun
    Jan 19, 2005
  5. Niraj Agarwal
    Replies:
    3
    Views:
    3,833
    Niraj Agarwal
    Jan 13, 2004
  6. pps!
    Replies:
    0
    Views:
    1,179
  7. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,991
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  8. Sudhakar

    Datagrid to Excel Export Problem while adding summation values

    Sudhakar, May 10, 2004, in forum: ASP .Net Datagrid Control
    Replies:
    1
    Views:
    260
    Alvin Bruney [MVP]
    May 10, 2004
Loading...