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]);
}
}
}
