public void SQLtoTrainData(string sql)
{
//Read from the database
SqlCommand cmd = new SqlCommand(sql, conn);
DataTable dataTable = new DataTable();
// create data adapter
SqlDataAdapter da = new SqlDataAdapter(cmd);
// this will query your database and return the result to your datatable
da.Fill(dataTable);
conn.Close();
rowcount = dataTable.Rows.Count;
colcount = dataTable.Columns.Count;
data = new double[rowcount][];
ids = new int[rowcount];
targets = new double[rowcount];
testResults = new Hashtable();
TestDetail test;
int i = 0;
for (; i < rowcount; i++)
{
targets[i] = Convert.ToDouble(dataTable.Rows[i][colcount -1]);
ids[i] = Convert.ToInt32(dataTable.Rows[i][0]);
data[i] = new double [colcount];
test = new TestDetail(ids[i], Convert.ToInt32(dataTable.Rows[i][1]), Convert.ToInt32(dataTable.Rows[i][2]), Convert.ToDouble(dataTable.Rows[i][3]));
testResults.Add(test.RId, test);
for (int j = 0; j < colcount; j++)
{
data[i][j] = Convert.ToDouble (dataTable.Rows[i][j]);
}
}
}
public void DataTabletoTestData(DataTable dataTable)
{
rowcount = dataTable.Rows.Count;
colcount = dataTable.Columns.Count;
TestDetail test;
data = new double[rowcount][];
ids = new int[rowcount];
targets = new double[rowcount][];
testResults = new Hashtable();
for (int i = 0; i < rowcount; i++)
{
targets[i] = new double[1] { Convert.ToDouble(dataTable.Rows[i][colcount - 1]) };
ids[i] = Convert.ToInt32(dataTable.Rows[i][0]);
data[i] = new double[colcount - 5];
test = new TestDetail(ids[i], Convert.ToInt32(dataTable.Rows[i][1]), Convert.ToInt32(dataTable.Rows[i][2]), Convert.ToDouble(dataTable.Rows[i][3]));
testResults.Add(test.PId, test);
for (int j = 0; j < colcount - 5; j++)
{
data[i][j] = Convert.ToDouble((Convert.IsDBNull(dataTable.Rows[i][j + 4]) ? 0 : dataTable.Rows[i][j + 4]));
}
}
}
