Category: Coding

[HowTo] Application start on “Wake up” event

Using this code will allow you to configure your application to start or to display following a system wakeup event. /// <summary> /// This function starts running an application when a specified event occurs. /// </summary> /// <param name=”application”>The application. eg: @”\Program Files\testapp\testapp.exe”</param> /// <param name=”notificationEvent”>Event at which the application is to be started. Use […]

[HowTo] Save Image into SqlCE database

Save into database. //Image to byte[] Image myImage = Image.FromFile(“c:\\xyz.jpg”); System.IO.MemoryStream imgMemoryStream = new System.IO.MemoryStream(); myImage.Save(imgMemoryStream, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] imgByteData = imgMemoryStream.GetBuffer(); //Store image bytes data into database SqlCeConnection scon = new SqlCeConnection(“Data Source=D:\\myDB.sdf”); SqlCeCommand cmd = new SqlCeCommand(“Update ImageTable Set Picture=@myPicture Where Username=’Martin'”, scon); cmd.Parameters.Add(“@myPicture”, SqlDbType.Image).Value = imgByteData; // Or cmd.Parameters.Add(“@myPicture”, SqlDbType.Binary).Value = imgByteData scon.Open(); […]