Problem in filling data from Ms Access into a Datatable and notepad

DataColumn.MaxLength Property sets or gets the maximum length of the column in characters. If the column has no maximum length, the value is –1 (default). Is it your datacolumn that is limited to 256 characters or is it your view that only displays 256 characters? What datatype is your datatablse datacolumn? Can you post the code showing how you create your datatabla and how you fill it with data?

Hi,

I have this column as "Memo" in my database (Msaccess).

Also, I am simply writing a sql query using ADO.net to collect a table based on certain parameters into a DataTable.

And when I am checking the text contained in cell of that particular column, it is truncated to 256 characters only.

BTW below is the code :

----------------------

string strsql = "Select distinct c_ImageName,c_OCRText,c_Page from OCR_RawData where c_ImageName = '"+filepath[t].ToString()+"' and c_Page ='"+myPagesarray[i]+"'";

DataUtility objDUT = new DataUtility();//Class to access ADO methods

DataTable dteachfieldperpageocrvalue = objDUT.GetDataTable(strsql);

string datafetchedfromdatabase = "";
if (dteachfieldperpageocrvalue.Rows.Count > 0)
{
datafetchedfromdatabase = dteachfieldperpageocrvalue.Rows[0]["c_OCRText"].ToString();
}

--------------------------------------------------------------------

Regards,
Ankit