System.Data.SQLite

i develop a mobile dictionary(ppc 5) with pictures

i've searched this site and i found this thread:

http://sqlite.phxsoftware.com/forums/t/1684.aspx

 

the problem is that it gives me error because i think that some of the syntax(like fromstream and memomystream) is not supported in windows mobile

 

any help please...tnx

 I try this code

           private void GetImage(string fullName)
        {            
            SQLiteConnection sqlite_con = new SQLiteConnection("Data Source=|DataDirectory|dbasedict.s3db;Version=3;New=False;Compress=True;");
            String querry2 = "select iimages from dictionario where word = '" + searchBox.Text + "'";
            SQLiteDataAdapter adap3 = new SQLiteDataAdapter(querry2, sqlite_con);
            DataSet set = new DataSet();
            adap3.Fill(set, "dictionario");
            DataTable dataTable = new DataTable();
            dataTable = (DataTable)set.Tables[0];
            MemoryStream ms = null;
            foreach (DataRow row in dataTable.Rows)            
            {
                int id = Convert.ToInt32(row["iimages"]);
                byte[ data = (byte[)row["dictionario"];
                ms = new MemoryStream(data);
            }
            pictureBox1.Image = Image.FromStream(ms);            
        }

 then i got a syntax error because fromstream is not supported in ppc 5

then i found a thread that I can use Bitmap method  as an alternative of fromstream in ppc and i found this code 

 

public static Image GetImage(string fullName)
{
Assembly thisExe = System.Reflection.Assembly.GetExecutingAssembly();
System.IO.Stream file = thisExe.GetManifestResourceStream(fullName);

//Image image = Image.FromStream(file); // This won't work with the CF
Bitmap image = new Bitmap(file); // But this works in both environments!

file.Close();

return image;

}

 

Now, my problem is i didn't know how to debug it coz im just a newbie in developing .net cf

anyone who can debug it please...

thanks....

Byte[ ] data; MemoryStream ms; data = (byte[ ]) row["dictionario"]; ms = new MemoryStream(data); pictureBox1.Image = New Bitmap(ms);

 Byte[ ] data; MemoryStream ms; data = (byte[ ]) row["dictionario"]; ms = new MemoryStream(data); pictureBox1.Image = New Bitmap(ms);

 

when i use this code, it gives me an error: Exception was unhandled: Message: Exception.

Ok,

i guess the error is at runtime, so maybe an exception occurs. With Visual Studio in debug mode you could see which exception occurs.
Or you can add to the code:

try
{
/// the code ....Byte[ ] data;.....
}
catch (System.Exception excep)
{
MessageBox.Show(excep.Message);
}

and see what's happening.

maybe row["dictionario"] is null.

Hope this helps.

in previous posts i assume that row["Dictionario"] it's a BLOB COLLATE BINARY field.

 this is my code

                    byte[ ] data = (byte[ ])row["iimages"];
                    MemoryStream ms = new MemoryStream(data);
                    Bitmap bmp = new Bitmap(ms);
                    pictureBox1.Image = bmp;

 

by using try and catch, it gives me the Message: invalidcasexception error when i try a null field while Message: exception error when field is not equl to null.

Ok, You must check that row["iimages"] is not null: if ( ! IsDBNull(row["iimages"]) ) { byte[ ] data = (byte[ ])row["iimages"]; MemoryStream ms = new MemoryStream(data); Bitmap bmp = new Bitmap(ms); pictureBox1.Image = bmp; } else { picturebox1.Image = null; } And also check that row["iimages"] has a valid image; This example works for me. you only need to change the static image with the code to read image from db (row["iimages"]). using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.IO; namespace csharpimage { public partial class Form1 : Form { public Form1() { InitializeComponent(); Test(); } private void Test() { byte[ row = {0xFF,0xD8,0xFF,0xE0,0x00,0x10,0x4A,0x46,0x49,0x46,0x00,0x01,0x01,0x00,0x00,0x01, 0x00,0x01,0x00,0x00,0xFF,0xDB,0x00,0x43,0x00,0x01,0x01,0x01,0x01,0x01,0x01,0x01, 0x01,0x01,0x01,0x01,0x01,0x01,0x02,0x02,0x03,0x02,0x02,0x02,0x02,0x02,0x04,0x03, 0x03,0x02,0x03,0x05,0x04,0x05,0x05,0x05,0x04,0x04,0x04,0x05,0x06,0x07,0x06,0x05, 0x05,0x07,0x06,0x04,0x04,0x06,0x09,0x06,0x07,0x08,0x08,0x08,0x08,0x08,0x05,0x06, 0x09,0x0A,0x09,0x08,0x0A,0x07,0x08,0x08,0x08,0xFF,0xDB,0x00,0x43,0x01,0x01,0x01, 0x01,0x02,0x02,0x02,0x04,0x02,0x02,0x04,0x08,0x05,0x04,0x05,0x08,0x08,0x08,0x08, 0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08, 0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08, 0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0x08,0xFF,0xC0, 0x00,0x11,0x08,0x00,0x10,0x00,0x10,0x03,0x01,0x22,0x00,0x02,0x11,0x01,0x03,0x11, 0x01,0xFF,0xC4,0x00,0x1F,0x00,0x00,0x01,0x05,0x01,0x01,0x01,0x01,0x01,0x01,0x00, 0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x01,0x02,0x03,0x04,0x05,0x06,0x07,0x08,0x09, 0x0A,0x0B,0xFF,0xC4,0x00,0xB5,0x10,0x00,0x02,0x01,0x03,0x03,0x02,0x04,0x03,0x05, 0x05,0x04,0x04,0x00,0x00,0x01,0x7D,0x01,0x02,0x03,0x00,0x04,0x11,0x05,0x12,0x21, 0x31,0x41,0x06,0x13,0x51,0x61,0x07,0x22,0x71,0x14,0x32,0x81,0x91,0xA1,0x08,0x23, 0x42,0xB1,0xC1,0x15,0x52,0xD1,0xF0,0x24,0x33,0x62,0x72,0x82,0x09,0x0A,0x16,0x17, 0x18,0x19,0x1A,0x25,0x26,0x27,0x28,0x29,0x2A,0x34,0x35,0x36,0x37,0x38,0x39,0x3A, 0x43,0x44,0x45,0x46,0x47,0x48,0x49,0x4A,0x53,0x54,0x55,0x56,0x57,0x58,0x59,0x5A, 0x63,0x64,0x65,0x66,0x67,0x68,0x69,0x6A,0x73,0x74,0x75,0x76,0x77,0x78,0x79,0x7A, 0x83,0x84,0x85,0x86,0x87,0x88,0x89,0x8A,0x92,0x93,0x94,0x95,0x96,0x97,0x98,0x99, 0x9A,0xA2,0xA3,0xA4,0xA5,0xA6,0xA7,0xA8,0xA9,0xAA,0xB2,0xB3,0xB4,0xB5,0xB6,0xB7, 0xB8,0xB9,0xBA,0xC2,0xC3,0xC4,0xC5,0xC6,0xC7,0xC8,0xC9,0xCA,0xD2,0xD3,0xD4,0xD5, 0xD6,0xD7,0xD8,0xD9,0xDA,0xE1,0xE2,0xE3,0xE4,0xE5,0xE6,0xE7,0xE8,0xE9,0xEA,0xF1, 0xF2,0xF3,0xF4,0xF5,0xF6,0xF7,0xF8,0xF9,0xFA,0xFF,0xC4,0x00,0x1F,0x01,0x00,0x03, 0x01,0x01,0x01,0x01,0x01,0x01,0x01,0x01,0x01,0x00,0x00,0x00,0x00,0x00,0x00,0x01, 0x02,0x03,0x04,0x05,0x06,0x07,0x08,0x09,0x0A,0x0B,0xFF,0xC4,0x00,0xB5,0x11,0x00, 0x02,0x01,0x02,0x04,0x04,0x03,0x04,0x07,0x05,0x04,0x04,0x00,0x01,0x02,0x77,0x00, 0x01,0x02,0x03,0x11,0x04,0x05,0x21,0x31,0x06,0x12,0x41,0x51,0x07,0x61,0x71,0x13, 0x22,0x32,0x81,0x08,0x14,0x42,0x91,0xA1,0xB1,0xC1,0x09,0x23,0x33,0x52,0xF0,0x15, 0x62,0x72,0xD1,0x0A,0x16,0x24,0x34,0xE1,0x25,0xF1,0x17,0x18,0x19,0x1A,0x26,0x27, 0x28,0x29,0x2A,0x35,0x36,0x37,0x38,0x39,0x3A,0x43,0x44,0x45,0x46,0x47,0x48,0x49, 0x4A,0x53,0x54,0x55,0x56,0x57,0x58,0x59,0x5A,0x63,0x64,0x65,0x66,0x67,0x68,0x69, 0x6A,0x73,0x74,0x75,0x76,0x77,0x78,0x79,0x7A,0x82,0x83,0x84,0x85,0x86,0x87,0x88, 0x89,0x8A,0x92,0x93,0x94,0x95,0x96,0x97,0x98,0x99,0x9A,0xA2,0xA3,0xA4,0xA5,0xA6, 0xA7,0xA8,0xA9,0xAA,0xB2,0xB3,0xB4,0xB5,0xB6,0xB7,0xB8,0xB9,0xBA,0xC2,0xC3,0xC4, 0xC5,0xC6,0xC7,0xC8,0xC9,0xCA,0xD2,0xD3,0xD4,0xD5,0xD6,0xD7,0xD8,0xD9,0xDA,0xE2, 0xE3,0xE4,0xE5,0xE6,0xE7,0xE8,0xE9,0xEA,0xF2,0xF3,0xF4,0xF5,0xF6,0xF7,0xF8,0xF9, 0xFA,0xFF,0xDA,0x00,0x0C,0x03,0x01,0x00,0x02,0x11,0x03,0x11,0x00,0x3F,0x00,0xFD, 0x57,0xFD,0xA1,0xFF,0x00,0xE0,0xB6,0xB7,0x3F,0x08,0xFC,0x7F,0xF1,0x4B,0xC2,0x32, 0xFC,0x69,0xD5,0xEC,0xFC,0x47,0xA6,0x78,0xD3,0xC4,0xDA,0x25,0xB6,0x8F,0x67,0xA5, 0xE9,0x92,0x88,0x6D,0x6C,0xB5,0x7B,0xBB,0x48,0x3E,0xFD,0xA3,0xB8,0xFD,0xD5,0xBC, 0x79,0x67,0x90,0x96,0x6D,0xD8,0xF4,0x1E,0x09,0xF0,0x1B,0xFE,0x0E,0x3C,0xF8,0x87, 0x79,0xE3,0x9B,0xAD,0x1F,0x58,0xF0,0xA5,0x97,0xC6,0xFF,0x00,0x0F,0xDF,0x6B,0xDA, 0x17,0x87,0x6D,0xBC,0xFB,0xAB,0x5D,0x2E,0x7D,0x2A,0x6B,0xB9,0xA7,0x46,0x97,0x75, 0xAD,0xBB,0x2C,0xA0,0xED,0x4F,0x91,0xB0,0x46,0xC3,0xC8,0xCE,0x29,0xFF,0x00,0xF0, 0x51,0x5F,0xF8,0x37,0x7B,0xC7,0x9E,0x2A,0xF1,0xD7,0x8A,0x7C,0x71,0xFB,0x18,0x5A, 0xF8,0xD3,0xC7,0x3E,0x29,0xF1,0xA7,0x88,0xF5,0xAF,0x14,0x78,0xA6,0xF7,0xC6,0x7F, 0x10,0xB4,0xFB,0x6B,0x0D,0x3A,0x5B,0xDB,0xA9,0x27,0x68,0x2C,0xED,0x21,0xD2,0xE1, 0xB9,0x3F,0x3C,0xF2,0x32,0x31,0xBA,0x22,0x30,0x88,0xAC,0x26,0xDC,0xD5,0x83,0xFB, 0x3F,0x7F,0xC1,0xB2,0xDF,0x13,0xFE,0x18,0x37,0xC1,0x2F,0x1B,0xE8,0xBF,0x13,0xFC, 0x39,0xE0,0xAF,0x11,0xA7,0x8A,0x74,0x2F,0x11,0x78,0xD3,0x47,0xD7,0xAF,0x93,0x59, 0x4B,0x48,0x2C,0x66,0x95,0xDE,0xDA,0xC9,0xA1,0xB3,0x44,0x96,0x47,0xF3,0x32,0xB3, 0xB3,0x47,0x81,0x8F,0x91,0x0E,0x6B,0xFA,0x96,0x1C,0x55,0xE1,0xB4,0xB2,0x48,0x60, 0x96,0x12,0xA7,0xD7,0x1A,0x8F,0x34,0xE5,0x18,0xA8,0xDD,0x59,0xCA,0xCE,0x13,0x73, 0xB3,0xB3,0x49,0xDA,0xEF,0xAD,0xAF,0xA7,0xE5,0xF8,0x4C,0x97,0x88,0xFF,0x00,0xB5, 0x65,0x89,0xAF,0x5E,0x2B,0x0C,0x9B,0xE5,0x84,0x5B,0x6D,0xA6,0x9A,0x4E,0x5C,0xD1, 0x4B,0xCE,0xCB,0x6E,0xEC,0xFF,0xD9}; byte[ data = (byte[)row; MemoryStream ms = new MemoryStream(data); Bitmap bmp = new Bitmap(ms); pictureBox1.Image = bmp; } } }