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