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