分类： SQL

if (!ExixtsTable(“PointValue”)) { ExecuteSql(@”CREATE TABLE PointValue( Id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, PointAddress TEXT NOT NULL, Time TEXT NOT NULL, Value NUMERIC NOT NULL )”); ExecuteSql(“CREATE INDEX PointAddress ON PointValue(PointAddress COLLATE BINARY ASC)”); ExecuteSql(“CREATE INDEX Time ON PointValue(Time COLLATE BINARY ASC)”); } https://www.cnblogs.com/lrzy/p/18096299

继续阅读

  /// <summary> /// 数据库连接字符串 /// </summary> private static string sConn = “server=.\\SQLEXPRESS;uid=sa;pwd=sa;database=csgl”; /// <summary> /// 数据库连接对象 /// </summary> private static SqlConnection conn = new SqlConnection(sConn); /// <summary> /// 打开数据库连接 /// </summary> public static void Open() { //判断数据库连接是否关闭 if (conn.State == ConnectionState.Closed) { conn.Open(); } } /// <summary> /// 关闭数据库连接 /// </summary> public static void Close() { //判断数据库连接是否打开 if (conn.State == ConnectionState.Open) { conn.Close(); } } /// <summary> /// 执行Command对象的ExecuteScalar方法 /// </summary> /// <param name=”sSql”>要执行的SQL语句</param> /// <returns></returns> public static object ExecuteScalar(string sSql) { object obj = null;

继续阅读