/// <summary> /// �ж����ݿ���bbsmax/idmax��صı���Ѿ����� /// </summary> /// <returns></returns> public static bool IsSqlLiteMaxExists() { int i = 0; SQLiteConnection connection = new SQLiteConnection(Settings.Current.bbsMaxConnectionString); try { if (ConnectionState.Closed == connection.State) { connection.Open(); } SQLiteCommand cmd = new SQLiteCommand("SELECT COUNT(*) FROM bbsMax_Posts;", connection);//System_Max_Settings bbsMax_Posts i = Globals.ToInt32(cmd.ExecuteScalar(), 0); return(1 == i); } catch (Exception ex) { SetupManager.CreateLog("���ݿ��Ƿ����" + ex.Message + Settings.Current.bbsMaxConnectionString); } finally { connection.Close(); } return(false); }
/// <summary> /// �ж����ݿ���bbsmax��صı���Ѿ����� /// </summary> /// <returns></returns> public static bool IsMaxExists() { int i = 0; SqlConnection connection = new SqlConnection(Settings.Current.IConnectionString + "Pooling=false;"); if (ConnectionState.Closed == connection.State) { connection.Open(); } SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandText = "SELECT COUNT(Db_ID('" + Settings.Current.IDatabase + "'));"; if (Globals.ToInt32(cmd.ExecuteScalar()) == 1) { connection.Close(); connection.ConnectionString = Settings.Current.IConnectionString; connection.Open(); cmd.CommandText = "SELECT COUNT(*) FROM sysobjects WHERE id = OBJECT_ID('bbsMax_Posts') OR id = OBJECT_ID('bx_Posts');"; i = Globals.ToInt32(cmd.ExecuteScalar(), 0); } return(i > 0); }