Question: I try researching this everywhere but it appears when I run my windows form application and display my database. Each it keeps automatically skipping and adding rows.  

Here is a screen shot of my gridview
[![enter image description here](https://i.stack.imgur.com/uSY77.png)](https://i.stack.imgur.com/uSY77.png)

Here is also my code where it displays the database when I click a button:

```
    try
    {
        conn = new MySqlConnection();
        conn.ConnectionString = connstring;

        query = "INSERT INTO schedule(name) VALUES(@namevalue)";
        MySqlCommand cmd = new MySqlCommand(query, conn);
        cmd.Parameters.AddWithValue("@namevalue", this.nameEmp.Text);

        conn.Open();

        cmd.ExecuteNonQuery();

        MessageBox.Show("Connection Success");
        myadapt = new MySqlDataAdapter();
        string sq = "SELECT * FROM schedule";
        myadapt.SelectCommand = new MySqlCommand(sq, conn);
        tb = new DataTable();
        myadapt.Fill(tb);

        BindingSource src = new BindingSource();
        src.DataSource = tb;

        dataGridView1.DataSource = src;

    }
    catch (MySqlException ex)
    {
        MessageBox.Show(ex.Message);
    }
}

```

Answer: 
Do you mean you want to show those rows which name column is not empty?
Gridview can just show the table you query from the DB,so you can change the SQL code to get the right table,
for example:change `SELECT * FROM schedule` to `SELECT * FROM schedule WHERE schedule(name) IS NOT NULL`.
actually, I figured it out. I had in that code above the statement
INSERT twice in my program. I removed it and redid my database on my server and fixed the problem. So sorry for the trouble.