Striing Data Getting Truncated to 256 characters when loading in DataTable from an Access Table.

See more:

C#

C#4.0

Hi,

I have a Ms Access database. In this inside one of the table, I have a column (which is of 'memo' type) which contain high number of characters for g. 2000 to 4000 characters.

Using Ado.net, I tried to load the values present in a particular row in the datatable for further computation.

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. This is the issue where I need your help.

BTW below is the code :

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

string strsql = "Select distinct c_ImageName,c_tttText,c_Page from ttt_RawData where c_ImageName = '"+filepath[t].ToString()+"' and c_Page ='"+myPagesarray[i]+"'";
 
DataUtility objDUT = new DataUtility();//Class to access ADO methods
 
DataTable dteachfieldperpagetttvalue = objDUT.GetDataTable(strsql);
 
string datafetchedfromdatabase = "";
if (dteachfieldperpagetttvalue.Rows.Count > 0)
{
datafetchedfromdatabase = dteachfieldperpagetttvalue.Rows[0]["c_tttText"].ToString();
}

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

Thanks in advance.

Ankit