How to Reset a DataGridView?

Question

RTK 0 Newbie Poster

14 Years Ago

Hi everyone,

I've created an application that runs queries against a SQL server (via Data Adaptors) in VB.NET 08 and returns the results to a DataGridView. It works great and returns my data, but when I switch to a different query that returns different columns, the DataGridView keeps the old columns from the previous query and adds the new columns from the new query to the end (far right) of the DataGridView. Is there a way to counter this? I don't want those previous unused columns showing up in my results.

I tried setting the DataGridView DataSource and DataMember to Nothing and that didn't fix it.

Here is my code...in case that helps

Connection.ConnectionString = "Provider=SQLOLEDB;Data Source=;Initial Catalog=;Integrated Security=SSPI;"
            Connection.Open()
            DataAdaptorVDN = New OleDb.OleDbDataAdapter(SQL, Connection)
            DataAdaptorVDN.Fill(DataSetVDN, "VDNResults")


            dgVDNResults.DataSource = DataSetVDN.DefaultViewManager
            dgVDNResults.DataMember = "VDNResults"
            dgVDNResults.AutoResizeColumns()
            dgVDNResults.AutoResizeRows()

Next time the button is clicked this is ran before refilling the datagridview

dgVDNResults.Columns.Clear()
            dgVDNResults.DataBindings.Clear()
            DataSetVDN.Clear()
            dgVDNResults.DataSource = Nothing
            dgVDNResults.DataMember = Nothing

vb.net

2 Contributors
2 Replies
7K Views
7 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by RTK

kvprajapati 1,826 Posting Genius

14 Years Ago

>I tried setting the DataGridView DataSource and DataMember to Nothing and that didn't fix it.

dgVDNResults.Columns.Clear()
dgVDNResults.DataSource = Nothing

Show us event handler code.

Edited 14 Years Ago by kvprajapati because: n/a

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

RTK 0 Newbie Poster · Answer 1 · 2010-01-28T22:35:26+00:00

>I tried setting the DataGridView DataSource and DataMember to Nothing and that didn't fix it.
dgVDNResults.Columns.Clear()
dgVDNResults.DataSource = Nothing
Show us event handler code.

Private Sub btnGetReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetReport.Click

I even tried another way of filling the DataGridView using a table/binding...Same exact issue