void ReadData() { string query = "SELECT * FROM ReceivedData"; OleDbCommand command = new OleDbCommand(query, connection); OleDbDataAdapter AdapterTabela = new OleDbDataAdapter(command); DataSet data = new DataSet(); AdapterTabela.Fill(data); lista = new List <BWSStruct>(); for (int i = 0; i < data.Tables[0].Rows.Count; i++) { BWSStruct node = new BWSStruct(); int tables = int.Parse(data.Tables[0].Rows[i]["Table"].ToString()); node.table = tables; node.ns = int.Parse(data.Tables[0].Rows[i]["PairNS"].ToString()); node.ew = int.Parse(data.Tables[0].Rows[i]["PairEW"].ToString()); node.round = int.Parse(data.Tables[0].Rows[i]["Round"].ToString()); node.section = int.Parse(data.Tables[0].Rows[i]["Section"].ToString()); node.boardNr = int.Parse(data.Tables[0].Rows[i]["Board"].ToString()); //contract string contr_ = data.Tables[0].Rows[i]["Contract"].ToString().Replace(" ", ""); contr_ = contr_.Replace("T", ""); string declarer_ = data.Tables[0].Rows[i]["NS/EW"].ToString(); try { string contract_ = contr_.Insert(2, declarer_) + data.Tables[0].Rows[i]["Result"].ToString(); node.contract = new Contract(contract_); lista.Add(node); } catch { } } }
public BWS(string filename, int round_) { round = round_; dane = new BWSStruct[100]; for (int i = 0; i < 100; i++) { dane[i] = new BWSStruct(); } string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=r4.bws"; connection = new OleDbConnection(connString); connection.Open(); ReadNumbers(); ReadBidding(); connection.Close(); lista = new List <BWSStruct>(); for (int i = 0; i < 100; i++) { if (dane[i].ns != 0) { lista.Add(dane[i]); } } }