cedata.cs

WINCE数据库sqlce 通讯stock 代码

using System;
using System.Drawing;
using System.Collections;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlServerCe;
using System.Text;
using System.IO;

namespace Wholesale
{
	/// <summary>
	/// CEData 的摘要说明。
	/// </summary>
	public class CEData
	{
		public SqlCeEngine engine=null;
		public SqlCeConnection conn=null;
		public SqlCeCommand cmd=null;
		private string LConnection="Data Source =glab.sdf";
		public CEData()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
			try
			{
				if(File.Exists("glab.sdf")==false)
				{
					SqlCeEngine engine=new SqlCeEngine(LConnection);
					engine.CreateDatabase();
					engine.Dispose();

					//MessageBox.Show("数据库初始化成功","提示");
				}
				conn=new SqlCeConnection(LConnection);
				conn.Open();
			}
			catch(Exception ee)
			{
				MessageBox.Show("初始化失败("+ee.Message+"),可能无法正常操作","提示");
				return;
			}
			
		}
		public void ExeSQLNO(string sql)
		{   
			cmd=new SqlCeCommand(sql,conn);
			cmd.ExecuteNonQuery();
		}
		public SqlCeDataReader ExeSQL(string sql)
		{
			SqlCeDataReader myReader=null;
			try
			{
				cmd=new SqlCeCommand(sql,conn);
				myReader=cmd.ExecuteReader();
			}
			catch
			{
				return null;
			}
			return myReader;
		}
		/// <summary>
		/// 获取Sql语句第一个字段的值
		/// </summary>
		/// <param name="sSql"></param>
		/// <returns></returns>
		public object GetFirstFieldValue(string sSql)
		{
			SqlCeDataReader dataReader = ExeSQL(sSql);
			if (dataReader == null) return null;
			return dataReader.GetValue(0);

		}
	}
}