Mobile

Deepali Khalkar wrote:

SqlCeParameter para = new SqlCeParameter();
para.ParameterName = "@uname";
para.Value = textBox1 .Text ;
comm.Parameters.Add(para);
para.ParameterName = "@psw";
para.Value = textBox2 .Text ;
comm.Parameters.Add(para);
para.ParameterName = "@fname";
para.Value = textBox3 .Text ;
comm.Parameters.Add(para);
para.ParameterName = "@lname";
para.Value = textBox3 .Text ;
comm.Parameters.Add(para);

<br />
SqlCeParameter para1 = new SqlCeParameter();<br />
para1.ParameterName = "@uname";<br />
para1.Value = textBox1 .Text ;<br />
comm.Parameters.Add(para1);<br />
<br />
SqlCeParameter para2 = new SqlCeParameter();<br />
para2.ParameterName = "@psw";<br />
para2.Value = textBox2 .Text ;<br />
comm.Parameters.Add(para2);<br />
<br />
SqlCeParameter para3 = new SqlCeParameter();<br />
para3.ParameterName = "@fname";<br />
para3.Value = textBox3 .Text ;<br />
comm.Parameters.Add(para3);<br />
<br />
SqlCeParameter para4 = new SqlCeParameter();<br />
para4.ParameterName = "@lname";<br />
para4.Value = textBox3 .Text ;<br />
comm.Parameters.Add(para4);

private int GetRowCount()
{
            int intCount = 0;
            SqlCeConnection objCon = new SqlCeConnection("ConnectionString");
            objCon.Open();
            SqlCeCommand objCmd = new SqlCeCommand("SELECT COUNT(*) AS UserCount FROM  Users", objCon);
            intCount = System.Convert.ToInt32( objCmd.ExecuteScalar().ToString());
            objCon.Close();
            objCmd.Dispose();

            return intCount;
}

IntPtr deviceContext = GetDC(IntPtr.Zero);
            
            Rectangle rectangle = Screen.PrimaryScreen.Bounds;
            using (Bitmap capture = new Bitmap(rectangle.Width, rectangle.Height))
            //Get screen context
            using (Graphics deviceGraphics = Graphics.FromHdc(deviceContext))
            //Get graphics from bitmap
            using (Graphics captureGraphics = Graphics.FromImage(capture))
            {
                // Blit the image data
                BitBlt(captureGraphics.GetHdc(), 0, 0,
                    rectangle.Width, rectangle.Height, deviceGraphics.GetHdc(),
                    rectangle.Left, rectangle.Top, SRCCOPY);
                          
                
                deviceGraphics.DrawString("Hello", Font, new SolidBrush(Color.Black), 10, 10);                
            }
            // Doesn't work: InvalidateRect(deviceContext, IntPtr.Zero, true);
            //Doesn't work: RedrawWindow(deviceContext, IntPtr.Zero, IntPtr.Zero, RDW_ERASE | RDW_INTERNALPAINT | RDW_UPDATENOW | RDW_INVALIDATE);
            // Doesn't work: SendMessage(deviceContext, WM_PAINT, 0, 0);

            // I tried RedrawWindow with all possibile combinations of all parameters (RDW_XXXX)!
            // I also tried to add directly IntPtr.Zero as Handle parameter
            // In all cases the text "Hello" is still drawn until I click on the start button
            // I run the code on WM 6.1.4 Professional (Emulator)