IDataClient GetDataClient(string ClientType) { if (ClientType == "SQL") { if (sqlClient != null) { return(sqlClient); } sqlClient = new SqlAdapter(); return(sqlClient); } else if (ClientType == "ORACLE") { if (oraClient != null) { return(oraClient); } oraClient = new OracleAdapter(); return(oraClient); } else if (ClientType == "SQLite") { if (sqliteClient != null) { return(sqliteClient); } sqliteClient = new SQLiteAdapter(); return(sqliteClient); } else if (ClientType == "OleDb") { if (oleDbClient != null) { return(oleDbClient); } oleDbClient = new OleDbAdapter(); return(oleDbClient); } else if (ClientType == "Postgre") { if (postgreClient != null) { return(postgreClient); } postgreClient = new PostgreAdapter(); return(postgreClient); } return(null); }
// This function retrieves all data from tblPersonnel table public static dsPersonnel GetPersonnel(string Database, string strSearch) { dsPersonnel DS; OleDbConnection SqlConn; OleDbAdapter sqlDA; //Opens OleDbConnection sqlConn = new OleDBConnection("PROVIDER=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + Database); //Employee Search (procured from video, add in later? if (strSearch == null || strSearch == "") { sqlDA = new OleDbDataAdapter("Select * from tblPersonnel", sqlConn); } else { sqlDA = new OleDbAdapter("Select '' from tblPersonnel where LastName = '" + strSearch + "'", sqlConn); } //Sets Value of DS DS = new dsPersonnel(); //Fills Table with Data sqlDA_Fill(DS.tblPersonnel); //Return value return(DS); }