odbc connectivity

Question

Hi All,

 

I went through  code of a project and i observe that a odbc adapter fill dataset sucessfully but connection is closed or only connection string provided.

 

I am confuse how it work , I think connection should be open other wise exception should be throw.

 

Kindly clear my confusion.

Below are the code: -  

 

Dim dbconn As Odbc.OdbcConnection

dbconn = New Odbc.OdbcConnection(connectionstring)

If dbconn.State <> ConnectionState.Open Then

dbconn.Open()

End If

dbconn.Close()

Dim dbAdapter As Odbc.OdbcDataAdapter

dbAdapter = New Odbc.OdbcDataAdapter("select * from studdent where id=5", dbconn)

Dim ds As New DataSet

dbAdapter.Fill(ds)