Retrieve data from database in MYSQL without empty records [closed]

Welcome to Stack Overflow!

1. I'm not too familiar with C# winforms, but this post can help you establish a connection to your MySQL database where you can query for specific data.

Code taken from that post:

string myConnectionString = "server=localhost;database=testDB;uid=root;pwd=abc123;";
private void button1_Click(object sender, EventArgs e)
{
    MySqlConnection cnn = new MySqlConnection(myConnectionString);
    try
    {
        cnn.Open();
        MessageBox.Show ("Connection Open!");
        cnn.Close();
    }
    catch (Exception ex)
    {
        MessageBox.Show("Cannot open connection!");
    }
}

Data is retrieved from a MySQL database using a specific SQL (or "Structured Query Language"). In order to learn the basic MySQL syntax for queries, I would recommend a turorial like this.

3. To send a SQL query to your database (via your established connection in Step 1) I would recommend looking at this post that gives an example on how to send a query via C# winforms

Code taken from that post:

  public void Select(string filename)
    {
        string query = "SELECT * FROM banners WHERE file = '"+filename+"'";

        //open connection
        if (this.OpenConnection() == true)
        {
            //create command and assign the query and connection from the constructor
            MySqlCommand cmd = new MySqlCommand(query, connection);

            //Execute command
            cmd.ExecuteNonQuery();

            //close connection
            this.CloseConnection();
        }
    }

Overall, you're missing a few steps inbetween C# winforms and MySQL. Different languages USUALLY have an external library that facilitates: establishing a MySQL connection and launching MySQL queries. After obtaining the data from a MySQL query return, its up to you on how to display it to the user!

Hope this helps :D