Help ! Database Problem, Unknown Information in an Access DataBase by the MEMO type! [modified]

[maysam gamini]

Dear Friends, Well i found that, it's definitely a String Base 64, 'cause I was able to build a byte array from it with this code:

string strData = dataGridView1[2, 0].Value.ToString();//this from visit table in sample database that i //attached
byte[] data = Convert.FromBase64String(strData);

and i use this :

public Image ByteToImageConvert(byte[] byteArrayIn)
                  {
                           MemoryStream ms = new MemoryStream(byteArrayIn);
                           Image returnImage = Image.FromStream(ms);
                           return returnImage;
                  }

but i face with this problem on " Image returnImage = Image.FromStream(ms);": Parameter is not valid. What should i do? PLease HELP! thank you!

modified on Thursday, November 5, 2009 6:55 PM

[Lost User]

maysam gamini wrote:

If you do more attention

If you would go back and read your original post, no where in the post is any reference to any C# code that you have tried to address your database problem. I paid very careful attention. In any case you might try this C# Image to Byte Array and Byte Array to Image Converter Class[^]

Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Individuality is fine, as long as we do it together - F. Burns Help humanity, join the CodeProject grid computing team here

[maysam gamini]

THank you Wes Aday, i use this :

public Image ByteToImageConvert(byte[] byteArrayIn)
{
MemoryStream ms = new MemoryStream(byteArrayIn);
Image returnImage = Image.FromStream(ms);
return returnImage;
}

    private void button2\_Click(object sender, EventArgs e)
    {
        string strData = dataGridView1\[2, 0\].Value.ToString();
        byte\[\] data = Convert.FromBase64String(strData);
        pictureBox1.Image = ByteToImageConvert(data);
    }

but i face with this problem on " Image returnImage = Image.FromStream(ms);": Parameter is not valid. What should i do? PLease HELP! thank you!

[Lost User]

I wouldn't be too sure that the string is encoded in base 64 unless you know for sure that it is. Would be unusual to my way of thinking. I am thinking that the MemoryStream is the invalid parameter because the byte array is invalid.

maysam gamini wrote:

string strData = dataGridView1[2, 0].Value.ToString();

try something like:

byte [] data = new ASCIIEncoding().GetBytes(strData);
MemoryStream ms = new MemoryStream(data);
Image im = new Image.FromStream(ms);

Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Individuality is fine, as long as we do it together - F. Burns Help humanity, join the CodeProject grid computing team here

[maysam gamini]

Thank you, but unfortunately i sill have he same problem as before. Parameters is not valid!

private void button2_Click(object sender, EventArgs e)
{
string strData = dataGridView1[2, 0].Value.ToString();
byte[] data = new ASCIIEncoding().GetBytes(strData);
MemoryStream ms = new MemoryStream(data);
Image im;
im = Image.FromStream(ms);//Parameters is not valid! :((
pictureBox1.Image = im;
}

[Lost User]

maysam gamini wrote:

Parameter is not valid.

I think this message is telling you that the stream is not a valid image stream. It does not matter how you create the stream, unless it is a valid image it will not convert. You need to check the format of correct image streams and then compare to your data to see what the differences are.

[maysam gamini]

thank YOu! Guys, I attached the Database File and all information that i have, please just try, and find a soloution for me. tnx! i probably know what the problem is, but i don't know how could i handle it! :(( :confused: :((

[Lost User]

maysam gamini wrote:

Guys, I attached the Database File and all information that i have, please just try, and find a soloution for me.

I don't have the time or the expertise to do this; I am sorry but the problem is yours to resolve. People here will help where they can but if you need a full solution you will probably have to pay someone for it.

[maysam gamini]

ok THANK YOU!

[Lost User]

Sorry Like Richard said. There are 2 things that I can think of: 1. It's not really a valid image stream. That is, the data is not an image but something else. 2. The data string is encrypted. BTW I think that you will have a hard finding someone that will take your database and just open it up. Especially from an unknown source. *I* won't do it. Good luck.

Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Individuality is fine, as long as we do it together - F. Burns Help humanity, join the CodeProject grid computing team here