private void cmdImport_Click(object sender, EventArgs e) { StreamReader sr = new StreamReader(File.OpenRead("Gens_SavestateData.csv")); List <string> lStats = new List <string>(); while (!sr.EndOfStream) { lStats.Add(sr.ReadLine()); } // finished importing stats //first is team name string[] sTemp; sTemp = lStats[0].Split(','); lblAwayName.Text = sTemp[1]; lblHomeName.Text = sTemp[2]; try { // choose table to query against, using design time statement with parameter // return from query stored in this object nhl94DataSet.tblTeamsDataTable tbl = new nhl94DataSet.tblTeamsDataTable(); // get adapter class object to run query nhl94DataSetTableAdapters.tblTeamsTableAdapter tAdapter = new nhl94DataSetTableAdapters.tblTeamsTableAdapter(); // first param is object to store query results // second is what to search for in predefined statement tAdapter.FillByAbbrev(tbl, sTemp[1]); // can use object.rows as an array if (tbl.Rows.Count > 0) { foreach (DataRow row in tbl.Rows) { MessageBox.Show("The full name is " + row[1] + " " + row[3]); } } } catch (Exception err) { MessageBox.Show(err.Message); } }
private void settings_Load(object sender, EventArgs e) { // choose table to query against, using design time statement with parameter // return from query stored in this object nhl94DataSet.tblTeamsDataTable tbl = new nhl94DataSet.tblTeamsDataTable(); // get adapter class object to run query nhl94DataSetTableAdapters.tblTeamsTableAdapter tAdapter = new nhl94DataSetTableAdapters.tblTeamsTableAdapter(); // first param is object to store query results // second is what to search for in predefined statement tAdapter.FillJustTeamAbbrev(tbl); // can use object.rows as an array if (tbl.Rows.Count > 0) { cmbTeams.Items.Add(""); cmbTeams.DataSource = tbl; cmbTeams.DisplayMember = "sName"; cmbTeams.ValueMember = "sAbbrev"; } }