static void Main(string[] args) { ado ado = new ado(); ado.ConnectToDB(); //ado.SQLToFile("select * from courses","C:/Users/Brian/Documents/datasets/courses.txt"); NetData train = new NetData(); NetData test = new NetData(); NNet nnet = new NNet(); string sqltrain; string sqltest; sqltrain = SQLNetData.TrainHeader() + SQLNetData.MainInput() + SQLNetData.TrainWhere(); sqltest = SQLNetData.TestHeader() + SQLNetData.MainInput() + SQLNetData.TestWhere(); train.SQLtoTrainData(sqltrain,ado.Conn); test.SQLtoTestData(sqltest, ado.Conn); //Utils.DataTableToFile(train.DataTable,"E:/Users/Brian/datasets/encogtrain.txt"); ////Utils.DataTableToFile(test.DataTable, "E:/Users/Brian/datasets/encogtest.txt"); //train.DataTable = Utils.DataTableFromFile("E:/Users/Brian/datasets/encogtrain.txt"); //Utils.DataTableToFile(train.DataTable, "E:/Users/Brian/datasets/encogtrain2.txt"); //train.DataTable = Utils.DataTableFromFile("E:/Users/Brian/datasets/encogtrain2.txt"); //Utils.DataTableToFile(train.DataTable, "E:/Users/Brian/datasets/encogtrain3.txt"); while (true) { for (int nodes = 16; nodes < 42; nodes = nodes + 2) { nnet.Create(train.ColCount - 2, nodes); nnet.Train(train, test); } } Console.Write("\n\nPress ENTER to continue."); Console.ReadLine(); }
public void SaveTest(string netfile) { string sqlinsert; string tsql1; string tsql2; string netsql; netsql = ""; if ( netsql.Length > 4000) { tsql1 = netsql.Substring(0, 4000); tsql2 = netsql.Substring(4000); } else { tsql1 = netsql; tsql2 = ""; } tsql1.Replace("'","''"); tsql2.Replace("'","''"); sqlinsert = "insert into nnets (NFILEPATH,NDESC,PROFIT,WINS,LOSSES,RUNS,TOVER,SRATE,MINRES,MAXRES,TWHERE,TSQL1,TSQL2,COURSEID,DIST,epochs,hnodes,resultfield,dateadded)"; sqlinsert = sqlinsert + " values ('" + netfile + "','" + testresultdesc + "'," + profit + "," + wins + ",0,'0'," + turnover + ","; sqlinsert = sqlinsert + strikerate + ",0,0,'','" + tsql1 + "','" + tsql2; sqlinsert = sqlinsert + "','0',''," + epochs + "," + hiddennodes + ",'" + resultfield + "',getdate())"; ado ado = new ado(); ado.ConnectToDB(); ado.Exectue(sqlinsert); }