Only one record is Shown in Datagridview Loading from excel
<p>I need your help. I have two excel files and I want to show them into datagridview. I found a problem that datagridview just shows one of my data not all. I want to show data like these :</p>

<p>These are my data from [Sheet1$]</p>

<pre><code>WSID          Lokasi      Saldo
1234          A           200
5678          B           300
</code></pre>

<p>And these are my data from [Data$]</p>

<pre><code>WSID       Tipe Mesin   Lokasi      
1234         MF           A          
5678         MF           B          
9876         CRM          C          
</code></pre>

<p>If I press radiobutton MF, data which will be shown is data that has Tipe Mesin value of MF. Actually it should be shown 1234 and 5678 but it just show 5678. Can anyone help me ?</p>

<pre><code>private void TampilDataSaldo()
        {
            RadioButton[] radiobtn = new RadioButton[] { MFRB, CRMRB };



         string dir = LokasiSaldo.Text;
            konek.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + dir + ";Extended Properties='Excel 12.0 xml;HDR=YES;IMEX=1'";



koneksi.ConnectionString = string koneksi = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Dokumen\Alfon\Kerja\BCA\Program\Program-Pengisian-Uang-ATM-BCA-SOY\Program-Pengisian-Uang-ATM-BCA-SOY\bin\x86\Debug\ATM SLA SURABAYA.xlsx;Extended Properties='Excel 12.0 xml;HDR=YES';";

        int saldo;
        Int32.TryParse(SaldoTB.Text, out saldo);
        int thresholdcas;
        Int32.TryParse(SaldoTB.Text, out thresholdcas); //baca angka yang diinput di NominalBox dan ubah jadi integer

        OleDbConnection kon = new OleDbConnection(koneksi);
        OleDbCommand command = kon.CreateCommand();
        OleDbCommand command1 = kon.CreateCommand();

        if(radiobtn[0].Checked)
        {
            kon.Open();
            command.CommandText = "select * from [Data$] where [Tipe Mesin] = '" + radiobtn[0].Text + "'";
            OleDbDataReader reader = command.ExecuteReader();

            while(reader.Read())
            {
                konek.Open();
                System.Data.DataTable aksesdatatabel;
                aksesdatatabel = konek.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
                konek.Close();

                OleDbCommand command2 = new OleDbCommand
                (
                    "select WSID, Lokasi, Saldo from [Sheet1$] where WSID = '" + reader["WSID"].ToString() + "'", konek
                );

                DataSet coba = new DataSet();
                OleDbDataAdapter adapter = new OleDbDataAdapter(command2);
                adapter.Fill(coba);

                var table = coba.Tables[0];
                var view = new DataView(table);

                view.RowFilter = string.Format("Saldo &lt; '{0}'", thresholdcas);
                ViewDataSaldoGV.DataSource = view;

            }
            kon.Close();
            }
}
</code></pre>