using System;
using MySql.Data.MySqlClient;

/// <summary>
/// Summary description for Class1
/// </summary>
/// 
namespace Bubbler{
public class InsertData
{
	public InsertData()
	{
		
	}
    public void InsertFrequencyIntoDatabase(){
        string MyConString = "SERVER=localhost;" +
                    "DATABASE=test;" +
                    "UID=root;" +
                    "PASSWORD=Anna;";
        string board = "Hello";
        string channel = "GoodBye";
        DateTime newDate = new DateTime();
        newDate = DateTime.UtcNow;
        float f_data = 1.23;



        string insertinto = @"Insert into frequencydata (Board,Channel,Date_Time,F_Data)values(board,channel,date_time,f_data)";
        //SqlParameter par1 = new SqlParameter("?board", MySqlDbType.VarChar, 45);
        //SqlParameter par1 = new SqlParameter("?channel", MySqlDbType.VarChar, 45);
        //SqlParameter par1 = new SqlParameter("?date_time", MySqlDbType.Timestamp);
        //SqlParameter par1 = new SqlParameter("?f_data", MySqlDbType.Float);

        MySqlConnection connection = new MySqlConnection(MyConString);
        MySqlCommand command = connection.CreateCommand();
        MySqlDataReader Reader;
        command.CommandText = "Insert into frequencydata";
        connection.Open();
        Reader = command.ExecuteReader();
        while (Reader.Read())
        {
            string thisrow = "";
            for (int i = 0; i < Reader.FieldCount; i++)
                thisrow += Reader.GetValue(i).ToString() + ",";
            listBox1.Items.Add(thisrow);
        }
        connection.Close();
        //SqlParameter myParam = new SqlParameter("@Param1", SqlDbType.VarChar, 11);
        //myParam.Value = "Garden Hose";

        //SqlParameter myParam2 = new SqlParameter("@Param2", SqlDbType.Int, 4);
        //myParam2.Value = 42;

        //SqlParameter myParam3 = new SqlParameter("@Param3", SqlDbType.Text);
        //myParam.Value = "Note that I am not specifying size. " +
        //  "If I did that it would trunicate the text.";
    
    
    
    }
}
}