以前一直做PB,現在准備將公司的PB系統更新成C#,研究c#一段時間發現開發速度相對PB來說真的太慢了,需要全部操作都用存儲過程來操作數據,於是又研究了一下datawindow.net,以實現快速開發,以下是datawindow.net在c#中連接sqlserver的代碼:
Sybase.DataWindow.Transaction Trans = new Sybase.DataWindow.Transaction();
Trans.Dbms = Sybase.DataWindow.DbmsType.OleDb;
Trans.Password = "password";
Trans.UserId = "sa";
Trans.DbParameter = "PROVIDER='SQLOLEDB',DATASOURCE='10.0.0.182',PROVIDERSTRING='database=kerno'";
Trans.Connect();
dw.LibraryList = "untitled.pbl";
dw.DataWindowObject = "ccyy";
dw.SetTransaction(Trans);
dw.Retrieve();
測試了很久才寫出上面的代碼,不像c#直接連接sqlserver那麼簡單,還有個DbParameter要設定,而且不能錯,真搞不懂與拆開寫有什麼區別,拆開寫的意思是以下代碼,就是想不寫DbParameter
Sybase.DataWindow.Transaction Trans = new Sybase.DataWindow.Transaction();
Trans.Dbms = Sybase.DataWindow.DbmsType.OleDb;
Trans.ServerName = "10.0.0.182";
Trans.Database="kerno"
Trans.Password = "password";
Trans.UserId = "sa";
Trans.AutoCommit = false;