Re: Reading MS Access Memo Field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



What do you expect the data type to be? You can create a string from it by
using the System.String constructor overload:

new string(char[])

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Hard work is a medication for which
there is no placebo.

"M. Noroozi Eghbali" <galaxy@xxxxxxxxxxxxx> wrote in message
news:%23yRF7efYGHA.500@xxxxxxxxxxxxxxxxxxxxxxx
Hi All,

I used the below code to get the information from a MS Access database
file:
----------------------------------------------------
bdpConnection1.Open();
bdpDataAdapter1.SelectCommand.CommandText = "SELECT * FROM Info WHERE
Email = '" +
email.Text + "'";

bdpDataAdapter1.FillSchema(dataSet1, SchemaType.Source, "Info");
RowNum = bdpDataAdapter1.Fill(dataSet1);
if(RowNum != 0)
{
UserInf.DownloadedFile =
dataSet1.Tables["Info"].Rows[0]["DownloadedFile"].ToString();//***
}
bdpConnection1.Close();
------------------------------------------------------

The "DownloadedFile" field of the database is of type Memo. After running
the code, the value of the UserInf.DownloadedFile is "system.char[]"
instead of the correct value of that. Any help?

Thank you,
Mehrdad




.



Relevant Pages

  • Re: Upsizing Wizard and SQl Server 2005
    ... >> I had imported the same Access Database using DTS some time ago, ... >> have not taken a close look at the data/time fields to make sure all ... but when I changed the data type from date/time to text it ... > The Date/Time type in Access has a wider range of valid values than the ...
    (microsoft.public.access.gettingstarted)
  • Re: Show Last Weeks Data
    ... Is it a table in this Access database? ... If it is a local Access table, open it in design view. ... I'm guessing that JET is not understanding the data type as you expect, and so it may be necessary to typecast the field and/or the criteria expression. ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.queries)
  • Re: ASP SQL Statement
    ... Its an Auto Number in a Access Database ... "Kevin Spencer" wrote: ... > What data type is ID in the database? ...
    (microsoft.public.frontpage.programming)
  • Re: View image using ADODC
    ... I have a access database and set a field named "Picture", the data type ... navigation. ...
    (microsoft.public.vb.general.discussion)
  • Re: Upsizing Wizard and SQl Server 2005
    ... > I had imported the same Access Database using DTS some time ago, ... > have not taken a close look at the data/time fields to make sure all ... but when I changed the data type from date/time to text it ... The Date/Time type in Access has a wider range of valid values than the ...
    (microsoft.public.access.gettingstarted)