Hi everyone, the following code is meant to grab some data from my sql server database and return it in a dataset from the function, at the moment though, it fails highlightint the fill line with the following:
vb(37): Value of type '1-dimensional array of System.Data.DataSet' cannot be converted to 'String'.
VB Code:
Public Function ViewAllFlightDetails() As Data.DataSet() Dim strSQL As String Dim objDAFlightInfo As SqlClient.SqlDataAdapter strSQL = "SELECT * FROM aTable" objDAFlightInfo = New SqlClient.SqlDataAdapter(strSQL, gstrDEVSQLSERVERCONN) If Not (objDAFlightInfo Is Nothing) Then objDAFlightInfo.Fill(New Data.DataSet(ViewAllFlightDetails)) End If End Function
Can anyone shed some light on what could be behind this problem? Thanks!




Reply With Quote