Perhaps I should expand on this a little. In our application we have a class file (cCommonReports.vb) that contains all the functions for filling our dataset based on the value that is passed to it. In vs 2003 we had a dataset (xsd file) called dsCommonReports, that dataset contained all the views and tables for specific functions in our app. (we have many other class files and datasets for other functions that are structured the same)
Since converting to vs 2005 our datasets can no longer been see by the application and say that the dataset is not defined. We are at a loss as to how to proceed with the upgrade. Below is a function from the cCommonReports.vb class file:
Public Function GetParcelReport(ByVal strParcelIDs As String) As dsCommonReports
Dim da As New SqlDataAdapter
Dim cmd As New SqlCommand
Dim ds As New dsCommonReports
With cmd
.Connection = modData.GetInternalCN()
.CommandText = "select * from ParcelReport where PID in (" + strParcelIDs + ") order by PID"
End With
da.SelectCommand = cmd
da.Fill(ds, ds.ParcelReport.TableName)
GetParcelReport = ds
da.Dispose()
ds.Dispose()
End Function
The above code is an example of how we filled our ds results based on an ID that was passed to the sql string. The dsCommonReports is the name of our dataset. (dsCommonReports.xsd) The above funtion no longer works, anything to do with the SqlDataAdapter, SqlCommand, and dsCommonReports now fail.
So my question still remains; what do we do with our vs 2003 xsd files, and how do we interact with the datasets in the above code but in vs 2005?
Thanks