Help translating couple of lines of code...

[mike55]

Hi,

 

Have been given code to look through and to convert to SQL Server 2000. The project is currently linked to Access. The problem is with the following method...

 

Friend Function FillAbsentDataset(byval strAbs as string, byval strDSAbs as string, strSqlCC as string) as dataset

Dim daDataAdapter as oledbDataAdapter

dim dbconConnection as System.data.idbConnection = new oledbconnection(strConnectionString) 'strConnectionString is defined earlier

dim dsDataset as dataset

dsDataset = new dataset

daDataAdapter = new OledbDataAdapter(strSqlAbs, dbconConnection)

dbConnection.close()

End Function

 

Would i be correct in saying that the line

daDataAdapter = new OledbDataAdapter(strSqlAbs, dbConnection)

is basically saying that strSqlAbs is my select statement, and that the line is a quick way of executing the sql statement???

 

I usually execute a sql select statement by doing the following...

connect() 'My connection string

conSQL.open

commSQL.connection = conSQL

commSQL.commandType = CommandType.Text

commSQL.commandText = The select statement

daDataAdapter.selectcommand = commSQL

conSQL.close

 

Would appreciate any comments, on either piece of code.

 

Mike55

[Nerseus]

In both cases you're not actually doing the Fill.

 

After you have "daDataAdapter = new OledbDataAdapter(strSqlAbs, dbconConnection)" you need to use daDataAdapter.Fill to fill a dataset based on your SELECT (or exec of a proc, etc.).

 

-ner