• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 691
  • Last Modified:

VB2010 ODBC SQL Query to DataGridView

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?
0
triphen
Asked:
triphen
1 Solution
 
triphenAuthor Commented:
I got it !!!!!!!!!

     
Dim str As String = "DSN=NAME;uid=USER;pwd=PASSWORD;"
        Dim con As New OdbcConnection(str)
        Dim com As String = "Select prodnum, descript, pricea from dba.product where descript like '%" & TextBox1.Text & "%'"
        Dim Adpt As New OdbcDataAdapter(com, con)
        Dim ds As New DataSet()
        Adpt.Fill(ds)
        DataGridView1.DataSource = ds.Tables(0)

Open in new window

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now