//returns the all "rows" found in database public Dictionary <string, SpecialCharacterRow> GetSpecialCharacterAllRows() { string sqlString = GetSpecialCharacter_SQLString_NoWhere(); Dictionary <string, SpecialCharacterRow> myOut = new Dictionary <string, SpecialCharacterRow>(); DataSet ds = mSqlCommand.ExecuteSelect(sqlString, null); DataRowCollection myRows = ds.Tables[0].Rows; if (myRows.Count < 1) { throw new PCAxis.Sql.Exceptions.DbException(44, "SpecialCharacter", "SPECIALCHARACTER"); } foreach (DataRow sqlRow in myRows) { SpecialCharacterRow outRow = new SpecialCharacterRow(sqlRow, DB, mLanguageCodes); myOut.Add(outRow.CharacterType, outRow); } return(myOut); }
//returns the single "row" found when all PKs are spesified public SpecialCharacterRow GetSpecialCharacterRow(string aCharacterType) { //SqlDbConfig dbconf = DB; string sqlString = GetSpecialCharacter_SQLString_NoWhere(); sqlString += " WHERE " + DB.SpecialCharacter.CharacterTypeCol.Is(mSqlCommand.GetParameterRef("aCharacterType")); // creating the parameters System.Data.Common.DbParameter[] parameters = new System.Data.Common.DbParameter[1]; parameters[0] = mSqlCommand.GetStringParameter("aCharacterType", aCharacterType); DataSet ds = mSqlCommand.ExecuteSelect(sqlString, parameters); DataRowCollection myRows = ds.Tables[0].Rows; if (myRows.Count != 1) { throw new PCAxis.Sql.Exceptions.DbException(36, " CharacterType = " + aCharacterType); } SpecialCharacterRow myOut = new SpecialCharacterRow(myRows[0], DB, mLanguageCodes); return(myOut); }