2,743
edits
Programmer:Simple program to test connection to AutoCount Accounting v2: Difference between revisions
Programmer:Simple program to test connection to AutoCount Accounting v2 (view source)
Revision as of 10:30, 8 April 2019
, 5 years agono edit summary
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
Line 8:
STEP 1. Create UserSession & DBSetting
STEP 2. Call (Create) SubProjectStartup
STEP 3. Login to AutoCount Accounting 2.0
{{SourceDownload|link=https://drive.google.com/open?id=10Au8sEjrY3UeDykSCcjx-cVqSgWQPzAS|remark=(Visual Studio 2017)|Download Sample Project|Sample project to test connection to AutoCount Accounting 2.0.}}
Line 14:
<br />
==UserSession and DBSetting==
'''
Even when writing scripting for report script
UserSession and DBSetting
Moreover, it provides methods such as GetDataTable(...), ExecuteScalar(...), ExecuteNonQuery(...) and more for programmer to
During its creation, two pieces of information is important, they are the '''server name''' and '''database name'''.
Namespace:
===Create DBSetting with AutoCount default configuration===
Line 27:
Below example code shows the DBSetting is created with new operator.
<syntaxhighlight lang="csharp">
</syntaxhighlight>
* DBServerType which is the First parameter is always DBServerType.SQL2000, regardless of which Microsoft SQL Server version is being applied.
* To obtain available '''Server Name''' and '''Database Name''':
** Programatically, you may refer to "[[Programmer:Create
** Manually, at the login screen of AutoCount Accounting.
<br />
===Create DBSetting while
<syntaxhighlight lang="csharp">
</syntaxhighlight>
* sa login password can be omitted when the password is using AutoCount default sa login password.
Line 47 ⟶ 46:
<br />
<!--
==SubProjectStartupWithLogin==
*When using '''SubProjectStartupWithLogin''' it does the following tasks:
Line 135:
}
</syntaxhighlight>
-->
<br/>
==See Also==
*[[Programmer:Simple program to test connection to AutoCount Accounting v2|A simple program to test connection to AutoCount Accounting 2.0]]
*[[Programmer:
*[[Programmer:Create BCE.Data.DBSetting with Database Info|Create BCE.Data.DBSetting with Database Info in AutoCount Accounting 1.8/1.9]]
*[[Invalid LCPDecryptFileException was unhandled]]
<br />
| |||