/// <summary> /// Build file list function that is used to /// grab all current files from the database and store them for use later /// </summary> private void buildFileList() { string[] fileColumns = { "id", "game_id", "title", "description", "filename" }; //what Columns I am wanting from the table string[] fileInfo = SQLUltility.SelectSQL("files", cs, fileColumns).Split('_'); //getting the requested columns from the table foreach (string info in fileInfo) //for every item returned by selectsql { if (info.Length > 0) //as long as it is not blank { String[] splitInfo = info.Split('|'); //split the data from the SQL database up for easy parsing FileElement newElement = new FileElement(splitInfo[1], splitInfo[2], splitInfo[3], splitInfo[4], splitInfo[5]); //make a new element with requested info fileList.Add(newElement); //add it to filelist for later use } } //This section makes sure the dropdown list for the files is in line with the selected game on update if (GameDropDown.SelectedIndex != -1) //as long the drop down is not null { string text = GameDropDown.SelectedItem.ToString(); //grab the selected item into text string ID = Regex.Match(text, @"\d+").Value; //Grab the ID out of the string ClipDropDown.Items.Clear(); //clear the file dropdown list foreach (FileElement info in fileList) //check all the files { if (info.GameID.Equals(ID)) //if they match the current ID { ClipDropDown.Items.Add(info.Title); //add it to the drop down list } } } }
/// <summary> /// Build game list function that is used to /// grab all current games from the database and store them for use later /// </summary> private void buildGameList() { string[] gameColumns = { "id", "title" }; //what Columns I am wanting from the table string[] gameInfo = SQLUltility.SelectSQL("games", cs, gameColumns).Split('_'); //parsing the data from the SQL data base into a string array foreach (string info in gameInfo) //for every item returned by selectsql { if (info.Length > 0) //as long as it is not blank { String[] splitInfo = info.Split('|'); //Split the data up between the ID and Name GameElement newElement = new GameElement(splitInfo[1], splitInfo[2]); //make a new element with the ID and name gameList.Add(newElement); //add it to the game list } } foreach (GameElement info in gameList) //for every game loaded from the database { GameDropDown.Items.Add("ID: " + info.ID + " " + info.Title); //add it to the dropdown list } }