Hi,

my code

command.CommandText = "SELECT COLUMN_NAME, SEARCH_CONDITION " & _
"FROM(USER_TAB_COLUMNS) " & _
"WHERE TABLE_NAME ='" & tableName & "'" & _
"AND DATA_DEFAULT IS NOT NULL"
reader = command.ExecuteReader()
constraintsList.Load(reader)

constraintsList is datatable

it is not showing the SEARCH_CONDITION column when it is binded with
a datagrid
desc USER_TAB_COLUMNS shows that SEARCH_CONDITION is LONG column(Oracle db)
i searched google also

can i see long column in a datagrid using datatable

please help.
thanks:)

jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

Sure you can... maybe you have no auto columns for the grid??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Column is there
But no data in it

using debugger i found that DataTable itself is not populated
for that column only

i think this is the problem of LONG() datatype of Oracle

by googling similar problem is found at
http://www.experts-exchange.com/Prog..._21175989.html

thanks

jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

Anyy other way to dispaly LONG dataType in VB.NET

jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

Something I didn't know till I looked it up, Oracle's LONG data type is not a numeric field - it is in fact a text field of variable length (a bigger version of oracles VARCHAR2, similar perhaps to SQL Server's text data type).

If you are using the Oracle ODP.Net drivers then I found the following link:

http://www.howtodothings.com/compute...pnet-in-c.html


/- Sam Judson : Wrox Technical Editor -/

Yes i am using Oracle ODP.Net drivers

command.InitialLONGFetchSize = 1000 solved my problem
many thanks for your help


jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

mY requirement is changed
now i have to use
  // .NET DataProvider from Microsoft
using System.Data.OracleClient;

another solution with reader.getBytes(.....)
gives me unhandled exceptions
code like:
cmd.commandText = " select rowid, long_raw_field from table1 "
               con.open()
               dataReader = cmd.ExecuteReader()
               dataReader.Read()
     dim DiskFile as string = "C:\temp.txt"
     dim byteData(2000) as byte
     dim numbytes as long
                numbytes = dataReader.GetBytes(1, 0, byteData, 0, 2000)
                Dim fstreamwriter As StreamWriter = File.AppendText(DiskFile)
                i = 0
                Do While i < numbytes
                    fstreamwriter.Write(System.Convert.Tochar(byteData (i)))
                    i += 1
                Loop
                fstreamwriter.Close()

jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.