 |
|
|
 首页 |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
using System;//引用系统命名空间 using System.Data.OleDb;//引用ADO.net命名空间 using System.Data;//引用数据空间 using System.Runtime.InteropServices;//为了调用GUID using System.EnterpriseServices;//引用COM+名命空间 using System.Runtime.CompilerServices;//运行时编译服务器 using System.Reflection;//用些全局属性取得强名属性 using System.Data.SqlClient; [assembly: ApplicationName("COMLibrary")] //强名文件名和文件属性。用sn.exe生成,用法 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=/"yanlixin//scgl/";p" + "ersist security info=True;initial catalog=scgl;password=scgl"; // myConnection = new SqlConnection( connection ); myConnection.Open(); myCommand = new SqlCommand(); myCommand.Connection = myConnection; return; } /// <summary> /// Execute one insert statement and insert one record into the table /// </summary> /// <param name=”connection”>database config infomation /// formatting : datasource=..;user id=..;password=... /// </param> /// <returns></returns> public int CommandExcute(string commandstring) { int returnValue = 0; myCommand.CommandText = commandstring; returnValue = myCommand.ExecuteNonQuery(); return returnValue; } /// <summary> /// Commit the com+ transaction /// </summary> public void Commit() { ContextUtil.SetComplete(); if(myConnection!=null) myConnection.Close(); } /// <summary> /// Roolback the com+ transaction /// </summary> public void Abort() { ContextUtil.SetAbort(); if(myConnection!=null) myConnection.Close(); } } } 返回类别: 教程 上一教程: .NET之ASP Web Form迅速入门(4) 下一教程: 在.net使用代理浏览网页 您可以阅读与".net分布式事务例子"相关的教程: · 基于.Net Framework的N层分布式应用开发 · .NET Remoting 实现分布式数据库查询 · 基于.Net Framework的N层分布式应用开发 · .NET Remoting 实现分布式数据库查询 · 创建分布式应用程序学习心得 |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
