(C#) .NET Smart Device เขียนโปรแกรมบน Smartphone, Pocket PC , Windows CE , Window Mobile 5-6, Hand Held,...

using System;
using System.Linq;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace SmartDeviceProject
{
    public partial class frmMain : Form
    {
        // By https://www.thaicreate.com (mr.win)//

        public frmMain()
        {
            InitializeComponent();
        }

        private void btnHome_Click(object sender, EventArgs e)
        {
            frmHome f = new frmHome();
            f.Show();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            if(MessageBox.Show("Are you sure to exit?", "Confirm.", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
            {
                Application.Exit();
            }
        }

        private readonly byte VK_OFF = 0xdf;
        private readonly byte KEYEVENTF_KEYUP = 0x2;

        [System.Runtime.InteropServices.DllImport("coredll.dll", SetLastError = true)]
        public static extern void keybd_event(byte bVk, byte bScan, int dwFlags, int dwExtraInfo);

        private void btnShutdown_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Are you sure to shutdown?", "Confirm.", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
            {
                keybd_event(VK_OFF, 0, 0, 0);
                keybd_event(VK_OFF, 0, KEYEVENTF_KEYUP, 0);
            }
        }

    }
}

using System;
using System.Linq;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;
using System.Data.SqlTypes;

namespace SmartDeviceProject
{
    public partial class frmHome : Form
    {
        // By https://www.thaicreate.com (mr.win)//

        public frmHome()
        {
            InitializeComponent();
        }

        private void frmHome_Load(object sender, EventArgs e)
        {
            BindDataGrid();
        }

        private void BindDataGrid()
        {
                SqlCeConnection myConnection = default(SqlCeConnection);
                DataTable dt = new DataTable();
                SqlCeDataAdapter Adapter = default(SqlCeDataAdapter);
                myConnection = new SqlCeConnection("Data Source =" + (System.IO.Path.GetDirectoryName( System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase ) + "\\AppDatabase1.sdf;"));
                myConnection.Open();
                SqlCeCommand myCommand = myConnection.CreateCommand();
                myCommand.CommandText = "SELECT [id], [name], [email] FROM [mytable]";
                myCommand.CommandType = CommandType.Text;

                Adapter = new SqlCeDataAdapter(myCommand);
                Adapter.Fill(dt);

                myConnection.Close();

                DataGridTableStyle tableStyle = new DataGridTableStyle();
                tableStyle.MappingName = dt.TableName;


                DataGridTextBoxColumn column = new DataGridTextBoxColumn();
                column.MappingName = "id";
                column.HeaderText = "ID";
                column.Width = 30;
                tableStyle.GridColumnStyles.Add(column);

                column = new DataGridTextBoxColumn();
                column.MappingName = "name";
                column.HeaderText = "Name";
                column.Width = 40;
                tableStyle.GridColumnStyles.Add(column);

                column = new DataGridTextBoxColumn();
                column.Width = 70;
                column.MappingName = "email";
                column.HeaderText = "Email";
                tableStyle.GridColumnStyles.Add(column);

                this.dgName.DataSource = dt;

                this.dgName.TableStyles.Clear();
                this.dgName.TableStyles.Add(tableStyle);

                dt = null;
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            frmAdd f = new frmAdd();
            f.Show();
        }

        private void btnEdit_Click(object sender, EventArgs e)
        {
                   frmEdit f =  new frmEdit();
                    f._strID = this.dgName[this.dgName.CurrentRowIndex, 0].ToString();
                    f.Show();
        }

        private void btnDel_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Are you sure to delete?", "Confirm.", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
            {
                string strID = this.dgName[this.dgName.CurrentRowIndex, 0].ToString();

                SqlCeConnection myConnection = default(SqlCeConnection);
                myConnection = new SqlCeConnection("Data Source =" + (System.IO.Path.GetDirectoryName( System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase ) + "\\AppDatabase1.sdf;"));
                myConnection.Open();
                SqlCeCommand myCommand = myConnection.CreateCommand();
                myCommand.CommandText = "DELETE FROM [mytable] WHERE id = '" + strID + "'";
                myCommand.CommandType = CommandType.Text;
                myCommand.ExecuteNonQuery();
                myConnection.Close();
                MessageBox.Show("Delete Successfully");

                BindDataGrid();
            }
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            frmMain f =  new frmMain();
            f.Show();
        }

    }
}

using System;
using System.Linq;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;
using System.Data.SqlTypes;

namespace SmartDeviceProject
{
    public partial class frmAdd : Form
    {
        // By https://www.thaicreate.com (mr.win)//

        public frmAdd()
        {
            InitializeComponent();
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(this.txtName.Text))
            {
                MessageBox.Show("Please input (Name)");
                this.txtName.Focus();
                return;
            }

            if (string.IsNullOrEmpty(this.txtEmail.Text))
            {
                MessageBox.Show("Please input (Email)");
                this.txtEmail.Focus();
                return;
            }

            SqlCeConnection myConnection = default(SqlCeConnection);
            myConnection = new SqlCeConnection("Data Source =" + (System.IO.Path.GetDirectoryName( System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase ) + "\\AppDatabase1.sdf;"));
            myConnection.Open();
            SqlCeCommand myCommand = myConnection.CreateCommand();
            myCommand.CommandText = "INSERT INTO [mytable] ([name], [email]) VALUES  " + " ('" + this.txtName.Text + "','" + this.txtEmail.Text + "' ) ";
            myCommand.CommandType = CommandType.Text;
            myCommand.ExecuteNonQuery();
            myConnection.Close();

            MessageBox.Show("Save Successfully");

            frmHome f = new frmHome();
            f.Show();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            frmHome f = new frmHome();
            f.Show();
        }

        private void txtName_GotFocus(object sender, EventArgs e)
        {
            this.inputPanel1.Enabled = true;
        }

        private void txtEmail_GotFocus(object sender, EventArgs e)
        {
            this.inputPanel1.Enabled = true;
        }

        private void txtName_LostFocus(object sender, EventArgs e)
        {
            this.inputPanel1.Enabled = false;
        }

        private void txtEmail_LostFocus(object sender, EventArgs e)
        {
            this.inputPanel1.Enabled = false;
        }

    }
}

using System;
using System.Linq;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;
using System.Data.SqlTypes;

namespace SmartDeviceProject
{
    public partial class frmEdit : Form
    {
        // By https://www.thaicreate.com (mr.win)//

        public frmEdit()
        {
            InitializeComponent();
        }

        string strID = "";
        public string _strID
        {
            get { return strID; }
            set { strID = value; }
        }

        private void frmEdit_Load(object sender, EventArgs e)
        {
            SqlCeConnection myConnection = default(SqlCeConnection);
            DataTable dt = new DataTable();
            SqlCeDataAdapter Adapter = default(SqlCeDataAdapter);
            myConnection = new SqlCeConnection("Data Source =" + (System.IO.Path.GetDirectoryName( System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase ) + "\\AppDatabase1.sdf;"));
            myConnection.Open();
            SqlCeCommand myCommand = myConnection.CreateCommand();
            myCommand.CommandText = "SELECT [id], [name], [email] FROM [mytable] WHERE id = '" + strID + "' ";
            myCommand.CommandType = CommandType.Text;

            Adapter = new SqlCeDataAdapter(myCommand);
            Adapter.Fill(dt);

            myConnection.Close();

            if (dt.Rows.Count > 0)
            {
                this.txtName.Text = dt.Rows[0]["name"].ToString();
                this.txtEmail.Text = dt.Rows[0]["email"].ToString();
            }

            dt = null;
        }

        private void btnEdit_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(this.txtName.Text))
            {
                MessageBox.Show("Please input (Name)");
                this.txtName.Focus();
                return;
            }

            if (string.IsNullOrEmpty(this.txtEmail.Text))
            {
                MessageBox.Show("Please input (Email)");
                this.txtEmail.Focus();
                return;
            }

            SqlCeConnection myConnection = default(SqlCeConnection);
            myConnection = new SqlCeConnection("Data Source =" + (System.IO.Path.GetDirectoryName( System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase ) + "\\AppDatabase1.sdf;"));
            myConnection.Open();
            SqlCeCommand myCommand = myConnection.CreateCommand();
            myCommand.CommandText = "UPDATE [mytable] SET " + " [name] = '" + this.txtName.Text + "', [email] = '" + this.txtEmail.Text + "'  " + " WHERE id = '" + strID + "' ";
            myCommand.CommandType = CommandType.Text;
            myCommand.ExecuteNonQuery();
            myConnection.Close();

            MessageBox.Show("Update Successfully");

            frmHome f = new frmHome();
            f.Show();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            frmHome f = new frmHome();
            f.Show();
        }

        private void txtEmail_GotFocus(object sender, EventArgs e)
        {
            this.inputPanel1.Enabled = true;
        }

        private void txtEmail_LostFocus(object sender, EventArgs e)
        {
            this.inputPanel1.Enabled = true;
        }

        private void txtName_GotFocus(object sender, EventArgs e)
        {
            this.inputPanel1.Enabled = false;
        }

        private void txtName_LostFocus(object sender, EventArgs e)
        {
            this.inputPanel1.Enabled = false;
        }

    }
}