用C#编写wince串口通信应用程序

1、using System;using System.IO;using System.Data;namespace SerialPort_SqlCe/ DataAccess 的摘要说明。/public class Class1#region 对数据库的操作private SqlCeConnection conn = null;/ 打开数据库连接/public void OpensqlCeConnection() if(conn = null)conn = new SqlCeConnection();if(conn.State = ConnectionState.Closed) tryconn.O

2、pen();catch(Exception ex)MessageBox.Show(ex.Message);/ 关闭数据库连接/public void ClosesqlCeConnection()if(conn != null)if(conn.State = ConnectionState.Open)conn.Close();/ 创建数据库/public SqlCeEngineCreateSqlCeDatabase()if (File.Exists (ResidentFlashTest.sdf) ) /确定指定的文件是否存在File.Delete (ResidentFlashTest.sdf);

3、 /删除指定的文件。如果指定的文件不存在，则不引发异常。SqlCeEngine engine = new SqlCeEngine (Data Source = ResidentFlashTest.sdf); engine.CreateDatabase ();conn = new SqlCeConnection (Data Source = ResidentFlashTest.sdf); OpensqlCeConnection();ClosesqlCeConnection();return engine;/ 创建表格/public SqlCeCommandCreateTable()conn =

4、new SqlCeConnection (Data Source = ResidentFlashTest.sdf); OpensqlCeConnection(); /打开连接SqlCeCommandsqlCeCommand = conn.CreateCommand ();sqlCeCommand.CommandText =CREATE TABLE TestTbl (col1 INT PRIMARY KEY);sqlCeCommand.ExecuteNonQuery();ClosesqlCeConnection();return sqlCeCommand;/ 向表中插入数据/public Sql

5、CeCommandInsertData(int p1)conn = new SqlCeConnection (Data Source = ResidentFlashTest.sdf); OpensqlCeConnection(); /打开连接SqlCeCommandcmd = conn.CreateCommand ();cmd.CommandText = INSERT INTO TestTbl (col1) VALUES (?);cmd.Prepare();cmd.Parametersp1.Value = p1;cmd.ExecuteNonQuery();MessageBox.Show(Ins

6、ert Data OK!);ClosesqlCeConnection();return cmd;/执行读的命令/public string ReadData()conn = new SqlCeConnection (Data Source = ResidentFlashTest.sdf); OpensqlCeConnection(); /打开连接MessageBox.Show(open read );SqlCeCommandsqlCeCommand = conn.CreateCommand();sqlCeCommand.CommandText =SELECT * FROM TestTbl;sqlCeCommand.ExecuteNonQuery();MessageBox.Show(select * from testtb1);SqlCeDataReaderrdr = sqlCeCommand.ExecuteReader();string aa = null;if(rdr.Read()aa = ( col1 = + rdr.GetInt32(0)/ col2 = + rdr.GetString(1) )