public MatchSelection(Match objController) { InitializeComponent(); _objController = objController; _objUDT = objController.Udt; DataSet dt = _objController.Udt.CurrentDataSet; var t = dt.Tables[10]; listBox1.DataSource = t; listBox1.DisplayMember = "Name"; listBox1.ValueMember = "ID"; DataRow[] dr = _objUDT.CurrentDataSet.Tables[10].Select("Active=true"); if (dr.Count() > 0) { int index = listBox1.FindString(dr[0]["Name"].ToString()); if (index != -1) { listBox1.SetSelected(index, true); UdtFilter filter = new UdtFilter(); filter.FilterColumn = "Name"; filter.FilterValue = listBox1.Text; filter.TableIndex = 10; if (!_objController.Udt.UdtFilters.ContainsKey("Active Match")) { _objController.Udt.UdtFilters.Add("Active Match", filter); } else { _objController.Udt.UdtFilters["Active Match"] = filter; } _objController.Udt.Notify("Active Match"); } } }
public Team(UDTProvider.UDTProvider UDTProvider) { _objUDTProvider = UDTProvider; var activeMatch = _objUDTProvider.UdtFilters["Active Match"]; DataRow[] dr = _objUDTProvider.CurrentDataSet.Tables[10].Select("Name = '" + activeMatch.FilterValue + "'"); var HomeTeam = dr[0]["HomeTeam"].ToString(); var AwayTeam = dr[0]["AwayTeam"].ToString(); DataRow[] drPlayers; if (TeamType == "home") { drPlayers = _objUDTProvider.CurrentDataSet.Tables[7].Select("Team = '" + HomeTeam + "'"); } else { drPlayers = _objUDTProvider.CurrentDataSet.Tables[7].Select("Team = '" + AwayTeam + "'"); } for (int i = 0; i < drPlayers.Count(); i++) { DataGridViewRow dgv = new DataGridViewRow(); dgv.Cells[0].Value = drPlayers[0]["JerseyNo"].ToString(); dgv.Cells[1].Value = drPlayers[0]["Name"].ToString(); dgv.Cells[2].Value = drPlayers[0]["Name"].ToString(); dataGridView1.Rows.Add(dgv); } }