why my datareader object of oledb in C# not properly reading

[kalaveer]

i am trying to read a memo field of database using oledb datareader after executing the query like below datareader.GetValue(0).ToString() which only reading the first 255 chars in the memo field how could i read the whole contents at a time please help.

[ednrgc]

What database are you using that has Memo fields?

[lost in transition]

Sounds like MS Access. If at first you don't succed give up go play XBox:laugh: Try something other than a datareader. Try a datatable or if you are only intrested in on field use a SQL statement and run a OleDbCommand.ExecuteScalar();

Programmer: A biological machine designed to convert caffeine into code. * Developer: A person who develops working systems by writing and using software. [^]

[ednrgc]

Try something like this: dr.Read(); FieldLen = dr[MemoCol].Length; char[] MemoBuffer = new char[FieldLen]; int startIndex = 0; retVal = dr.GetChars(1, startIndex, MemoBuffer, 0, MemoBuffer.Length); Console.WriteLine(MemoBuffer);