Using System; // reference the System namespace
Using System. Data. OleDb; // reference the ADO.net namespace
Using System. Data; // reference the Data space
Using System. Runtime. InteropServices; // to call the GUID
Using System. EnterpriseServices; // reference the COM + namespace
Using System. Runtime. CompilerServices; // compile the server at Runtime
Using System. Reflection; // use some global attributes to obtain the strong name attribute.
Using System. Data. SqlClient;
[Assembly: ApplicationName ("COMLibrary")]
// Strong name file name and file attributes. Generated with sn.exe, using sn-k clsStock. snk
// [Assembly: AssemblyKeyFileAttribute ("clsStock. snk")]
// [Assembly: AssemblyKeyName ("clsStock. snk")]
[Assembly: AssemblyKeyFileAttribute ("... clsStock. snk")]
[Assembly: AssemblyKeyName ("... clsStock. snk")]
Namespace COMLibrary
{
[Transaction (TransactionOption. Required)]
Public class DBOperation: ServicedComponent
{
Private SqlConnection myConnection;
Private SqlCommand myCommand;
/// <Summary>
/// Connect database
/// </Summary>
/// <Param name = "connection"> database config infomation
/// Formatting: datasource =...; user id =...; password =...
/// </Param>
/// <Returns> </returns>
Public void Connect ()
{
String connection = "workstation id = YANLIXIN; packet size = 4096; user id = sa; data source =" yanlixinscgl "; p" +
"Ersist security info = True; initial catalog = scgl; password = scgl ";
//
MyConnection = new SqlConnection (connection );
