static void Main(string[] args) { var table = new BuildTable(); var data = new ReturnData(); var Elements = table.GetElements(); var GetData = new ReturnData(); var list = GetData.Init(); var htmlStr = table.HtmlDisplayBuilder(Elements, list); string docPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); using (StreamWriter outputFile = new StreamWriter(Path.Combine(docPath, "HTMLBuilt.html"))) { outputFile.WriteLine(htmlStr); } }
public new List <string> Init() { MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder(); connBuilder.Add("Database", database); connBuilder.Add("Data Source", "localhost"); connBuilder.Add("User Id", "root"); connBuilder.Add("Password", "Rhino1515"); MySqlConnection connection = new MySqlConnection(connBuilder.ConnectionString); MySqlCommand cmd = connection.CreateCommand(); connection.Open(); cmd.CommandText = "SELECT * FROM fish"; cmd.CommandType = CommandType.Text; MySqlDataReader reader = cmd.ExecuteReader(); var elegetter = new BuildTable(); var Elements = elegetter.GetElements(); var list = new List <string>(); while (reader.Read()) { var temp = new StringBuilder(); for (int i = 0; i < 25; i++) { temp.Append(reader[Elements[i]]).Append(","); } list.Add(temp.ToString()); } connection.Close(); return(list); }