public DockSchedule() { InitializeComponent(); if (SQL_search.HasConnection("db_Harbor")) { //TODO CONTINUE PAGE LOAD } else { //TODO SHOW DB ERROR //TODO HOW TO USE IN PAGE ON REFRESH //TODO MAYBE MOVE TO HEADER } }
public MachineOperations_VM() { if (!SQL_search.HasConnection("db_Harbor")) { return; } SQL_search.RunQuery("db_Harbor", "SELECT * FROM [@profiles] WHERE COMPUTER = '" + Environment.MachineName + "'"); if (SQL_search.RecordCount <= 0) { return; } //MachineData.Number = SQL_search.Ds.Tables[0].Rows[0]["NUMBER"].ToString(); MachineData.Number = SQL_search.Ds.Tables[0].Rows[0]["ID"].ToString(); }
//VERIFY CONNECTION------------------------- public bool VerifyDatabaseConnection() { return(SQL_search.HasConnection("db_Harbor")); }