Solved

Datagridview column problem

Posted on 2014-02-06
1
313 Views
Last Modified: 2014-02-06
I have a listbox with names of tables in a SQL server database. The user selects a table in the list, and the datagridview below populates with that table. However, every time the user selects a different table in the list, the columns from the previous table remain in the DGV, and the new ones are added, so with every click in the listbox I have an ever expanding set of columns in the DGV.
0
Comment
Question by:TimHudspith
1 Comment
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
ID: 39840798
dataGridView1.CancelEdit() 'In the case that the user is currently editing a cell
dataGridView1.Columns.Clear()
dataGridView1.DataSource = Nothing

Then call back the code that fills the grid
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help with consolidating excel files using VB.net 2 36
Generate Numbers in JQuery file 11 72
FInd Image Control Gridview 3 38
vb.net dbnull syntax 1 15
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question