Reading MS Access Memo fields problem

Article View: borland.public.csharpbuilder.language.csharp

Article #100

Back to borland.public.csharpbuilder.language.csharp Previous Next

#100

From: M. Noroozi Eghbali
Date: Mon, 17 Apr 2006 13:30

25 lines
1731 bytes

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

Technical Details

Message-ID: <4443987c@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1efe35,4333d6d24eb37ebf,start
X-Google-Attributes: gid1efe35,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "M. Noroozi Eghbali" <galaxy@irandoc.ac.ir>
Newsgroups: borland.public.csharpbuilder.language.csharp
Subject: Reading MS Access Memo fields problem
Date: Mon, 17 Apr 2006 18:00:24 +0430
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: 213.176.21.106
Message-ID: <4443987c@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1145280636 213.176.21.106 (17 Apr 2006 06:30:36 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail