sap bone / sap connect di api using c# - Software - Spiceworks Community

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

Step 1: Create new project

create a new project console or forms i will base my turtorial on a forms method.

Step 2: Add app.config

create a new app.config.xml file and add this contents.

adjust the required parameters to your setup

Step 3: create a new class file

this class file wil be the connection to the server add a new class file and call this name : ServerConnections.cs

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DIAPI_Froms
class ServerConnection
private SAPbobsCOM.Company company = new SAPbobsCOM.Company();
private int connectionResult;
private int errorCode = 0;
private string errorMessage = “”;

    public int Connect()
        company.Server = ConfigurationManager.AppSettings["server"].ToString();
        company.CompanyDB = ConfigurationManager.AppSettings["companydb"].ToString();
        company.DbUserName = ConfigurationManager.AppSettings["dbuser"].ToString();
        company.DbPassword = ConfigurationManager.AppSettings["dbpassword"].ToString();
        company.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2012;
        company.UserName = ConfigurationManager.AppSettings["user"].ToString();
        company.Password = ConfigurationManager.AppSettings["password"].ToString();
        company.language = SAPbobsCOM.BoSuppLangs.ln_Dutch;
        company.UseTrusted = false;
        company.LicenseServer = ConfigurationManager.AppSettings["licenseServer"].ToString();
        connectionResult = company.Connect();
        if (connectionResult != 0)
            company.GetLastError(out errorCode, out errorMessage);
        return connectionResult;
    public SAPbobsCOM.Company GetCompany()
        return this.company;
    public int GetErrorCode()
        return this.errorCode;
    public String GetErrorMessage()
        return this.errorMessage;
Step 4: add references

add system.configuration to the references and SAPBOBSCOM this you can locate at :“C:\Program Files (x86)\SAP\SAP Business One DI API\DI API 90\SAPbobsCOM90.dll”
Step 5: edit form

add 2 fields to your main form ItemCode and ItemName
and give them a good name like:

txt_itemcode

txt_itemname
add a button to the main screen and double click on it. now we will add code in the next step.
to test the output you need to query your sql server eg:
select ItemCode,ItemName FROM OITM Where ItemCode = ‘YOUR_ITEM_HERE’
if the data is changed you have succefully connected to the api.
if you want more info about software dev in sap you need to download SAP SDK this will install the documentation in the following location:
C:\Program Files (x86)\SAP\SAP Business One SDK\Help

推荐文章

一身肌肉的酱肘子 · Loading forever when trying to connect esp32-c3 · Issue #64 · arduino/lab-micropython-editor · GitHu

4 周前

痛苦的柑橘 · Results - OpenURL Connection - EBSCO

4 周前

知识渊博的豆芽 · Results - OpenURL Connection - EBSCO

2 周前

仗义的电脑桌 · Python WiFi Example · GitHub

2 周前

痴情的啄木鸟 · Q & A / PostgreSQL / Connect PostgreSQL with Visual Studio 2015 - ConnectionStrings.com

1 周前

聪明的风衣 · OpenCV4.5+Visual Studio 2017开发环境配置 - 技术教程 - 苟七教程网

2 月前

精明的手术刀 · 开学季神机合集，哪一轻薄本是你心中的首选？-太平洋科技

3 月前

深沉的松树 · 中国十大歌手演唱会人气排行榜，排名第一的周杰伦达159万_阿根廷_新闻_华人头条

3 月前

慷慨大方的乌龙茶 · autodocstrings · PyPI

4 月前

满身肌肉的八宝粥 · Playing HTML Video Element In Layers API In Camera Mode Webview - Zoom Apps - Zoom Developer Forum

5 月前