<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
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.<br />
<br />
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:<br />
<br />
adodc1.recordsource = &quot;select * from table where condition = x&quot;<br />
adodc1.refresh<br />
<br />
and bam!<br />
<br />
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.<br />
<br />
Can someone point me in the right direction?
</div>
</div>


Hello Experts,

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"
adodc1.refresh

and bam!

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?

VB2010 ODBC SQL Query to DataGridView

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.