VB2010 ODBC SQL Query to DataGridView
Posted on 2014-08-05
I am coming over from VB6 to VB2010 and I am am having a hell of time getting the results of a basic query to display on a datagrid.
In VB6 I would only need 2 components: DataGridView and an ADODC object. I would link the DataGridView's DataSoucre to the ADODC object, put my ODBC info into the ADODC object, then write 2 lines of code:
adodc1.recordsource = "select * from table where condition = x"
I am completely lost in VB.net. I dont understand the Fill, BindingSource, TableAdapter, etc. and how they work with each other or why they are even needed.
Can someone point me in the right direction?