(C#) .NET Smart Device เขียนโปรแกรมบน Smartphone, Pocket PC , Windows CE , Window Mobile 5-6, Hand Held,...
.NET Smart Device Project เป็น Application ใช้สำหรับเขียนโปรแกรมเพื่อทำงานบน Smartphone, Pocket PC , Windows CE , Window Mobile 5-6, Hand Held, ... ใน Visual Studio สามารถสร้าง Application ของ Smart Device นั้น สามารถทำได้อย่างง่ายได้ รูปแบบการเขียนหรือแม้แต่ Event ต่าง ๆ ก็ไม่ต่างอะไรกับ Windows Form Applciation และทั้งยังสามารถพัฒนาใช้งานได้กับหลาย ๆ Target platform เช่นFramework : 1,2,3,4Pocket PC 2003 Windows CE Windows Mobile 5.0 Pockget PC SDK Windows Mobile 5.0 Smartphone PC SDK Smart Device สามารถทำการเชื่อมต่อกับอุปกรณ์ จริง หรือจะทำการใช้ตัว Emulator Microsoft ActiveSync Windows Mobile Device Center Language Code : VB.NET || C# Visual Studio 2008 บน .NET Framework 3.5 Windows Mobile 5.0 Pockget PC SDK Project -> Add -> New Item.... Application.Run(new frmMain()); USA Windows Mobile 5.0 Pocket PC R2 Emulator หรือ กรณีที่ได้เชื่อมต่อแล้วก็ให้เลือก Windows Mobile 5.0 Packet PC Device R2 ได้เลยEmulator ในตัวอย่างนี้มีการเรียกใช้งาน Database ของ SqlServerCe ด้วย frmMain 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);
}
}
}
}
frmHome 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();
}
}
}
frmAdd 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;
}
}
}
frmEdit 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;
}
}
}
Start Debugging บทความที่เกี่ยวข้อง Go to : Shared Folder or Map Drive in Emulator Smart Device Mobile Application Go to : Smart Device Mobile Application Read and Write Text File
By :
TC Admin
Score Rating : -
Create Date : 2010-09-02 21:19:09
Download :
-->
C#
Load balance : Server 04
