This question is locked. New answers and comments are not allowed.
Hi,
I currently have a webservice that my applications talk to, to get data from the database. See below.
How would I implement this using open access? I have already created a class library that reversed mapped my database and added that as a reference to my webservice. I have also enabled open access on my webservice and have a ObjectScopeProvider1 class.
How would I get this data and still return as dataset.VB or C# example would ok.
I currently have a webservice that my applications talk to, to get data from the database. See below.
How would I implement this using open access? I have already created a class library that reversed mapped my database and added that as a reference to my webservice. I have also enabled open access on my webservice and have a ObjectScopeProvider1 class.
How would I get this data and still return as dataset.VB or C# example would ok.
Public Function Get_Application_FolderPath() As DataSet
Dim ds As New DataSet
Using conn As New MySqlConnection(MySQLDBString)
' conn.ConnectionString =
Dim cmd As New MySqlCommand("Select * from applicationFolderPath", conn)
cmd.CommandType = CommandType.Text
'cmd.Parameters.Add("UserName", UserName)
Dim da As New MySqlDataAdapter(cmd)
conn.Open()
ds.Namespace =
"FolderPath"
ds.Prefix =
"Folders"
da.Fill(ds,
"Folders")
conn.Close()
End Using
Return ds
End Function