VB.Net - Query to get Sales Invoices

158 Views

Hi,

I am programming an application that displays all information of "Sales Invoices" in a web page done in ASP.Net.

I can connect to SAP Business One 9.0 but I don't know how to send the request to it (the query).

This is the code I have.

Dim oCompany As SAPbobsCOM.Company

Dim lRetCode, lErrorCode As Long

Dim sErrMsg As String

'Instantiate a Company object

oCompany = New SAPbobsCOM.Company

'oCompany.Server = "(local)"

oCompany.Server = "WINSERVER"

oCompany.Server = "SAP"

'oCompany.CompanyDB = "SBODemo_US"

oCompany.CompanyDB = "SBODemoUS"

oCompany.UserName = "manager"

oCompany.Password = "manager"

oCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2008

oCompany.DbUserName = "sa"

oCompany.DbPassword = "Alfa321"

oCompany.Connect()

'Conecction result

If lRetCode <> 0 Then

oCompany.GetLastError(lErrorCode, sErrMsg)

Else

Label1.Text = "Connected!"

End If