private void LoadPlayerIntoDatabase(string playerName) { playerName = scripts.PlayerNameFirstLastFromLastFirst(playerName).ToUpper(); //first we have to load the roster page var playerId = GetNHLPlayerIdFromName(playerName); var HTML = GetPageHTML(String.Format("http://avalanche.nhl.com/club/player.htm?id={0}", playerId)); //since these pages are not well formatted XML, we are going to have to do this the hard way var position = GetHTMLInnerDiv(HTML, "plyrTmbPositionTeam\">"); position = position.Substring(0, position.IndexOf("-")); var weight = GetHTMLInnerDiv(HTML, "plyrTmbStatCaption\">Weight:</span>"); var height = GetHTMLInnerDiv(HTML, "plyrTmbStatCaption\">Height:</span>"); var heightInt = scripts.ConvertHeightToInches(height); var dob = GetHTMLInnerDiv(HTML, "plyrTmbStatCaption\">Born:</span>"); dob = dob.Substring(0, dob.IndexOf("(Age")); var insertPlayerName = GetHTMLInnerDiv(HTML, "plyrTmbPlayerName\">"); var birthplace = GetHTMLInnerDiv(HTML, "plyrTmbStatCaption\">Birthplace:</span>"); var birthplaceArr = birthplace.Split(','); birthplace = birthplaceArr.Last(); var helper = new PlayerHelper(); helper.AddPlayerToMSSQL(insertPlayerName, position, dob, birthplace, heightInt, Convert.ToInt32(weight)); }