学步园

1)首先在bin中引用Sybase.Data.AseClient.dll

2)web.config中添加数据库连接

<add name="AirTransConnectionString" connectionString="Data Source=192.168.2.230;Port=5000;UID=sa;PWD=;Database=dahang;"/>

3）单元中引用using Sybase.Data.AseClient;

public void UpdateAirChargeDetail(AirChargeDetail airChargeDetail)<br /> ...{<br /> public void UpdateAirChargeDetail(AirChargeDetail airChargeDetail)<br /> ...{<br /> using ...(AseConnection aseconnection = new AseConnection(DateAccess.sConnectionstring))<br /> ...{<br /> aseconnection.Open();<br /> AseTransaction trans = aseconnection.BeginTransaction(IsolationLevel.RepeatableRead);<br /> try<br /> ...{ </p> <p> AirChargeDetailDAL dal = new AirChargeDetailDAL();<br /> dal.ModifyAirChargeDetail(aseconnection,trans,airChargeDetail);<br /> trans.Commit();<br /> aseconnection.Close();<br /> }<br /> catch (Exception ex)<br /> ...{ </p> <p> DOMUtility.WriteLogFile(ex.Message);<br /> trans.Rollback();<br /> aseconnection.Close();<br /> }<br /> }<br /> }