Limiting the DataGridView Rows!!!

[gautamshaw]

I had a DataGridView in which i want to fetch the data from the access database,so i did this code:

 Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Etech.mdb"

        Dim myConnection As OleDbConnection = New OleDbConnection

        myConnection.ConnectionString = connString

        Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select LAcNo,IssuerName,Creditor,Amount,ROI,EMIAmount,BankAcNo,CreditCardNo,Notes from MLoan", myConnection)

        Dim ds As DataSet = New DataSet

        DataGridView1.Columns(0).DataPropertyName = "LAcNo"

        DataGridView1.Columns(1).DataPropertyName = "IssuerName"

        DataGridView1.Columns(2).DataPropertyName = "Creditor"

        DataGridView1.Columns(3).DataPropertyName = "Amount"

        DataGridView1.Columns(4).DataPropertyName = "ROI"

        DataGridView1.Columns(5).DataPropertyName = "EMIAmount"

        DataGridView1.Columns(6).DataPropertyName = "BankAcNo"

        DataGridView1.Columns(7).DataPropertyName = "CreditCardNo"

        DataGridView1.Columns(8).DataPropertyName = "Notes"

        da.Fill(ds, "MLoan")

        Dim dt As New DataTable

        da.Fill(dt)
        
        DataGridView1.DataSource = dt

Now after fetching the data from the database to the DataGridView,i want to remove those columns of the DataGridView where the columns does not contain any value;
i.e,the columns with no contents......
Initially my design form looks like this:
Attachment 73025
After the load button click it looks like this:
Attachment 73026
In the above snapshot,after fetching the data from the access database to the DataGridView,i want to remove the PplicyHolderName,PremiumAmount and a few other columns since these are the columns which do not contain any data....
How to do this?
Thank you