请注意,本站并不支持低于IE8的浏览器,为了获得最佳效果,请下载最新的浏览器,推荐下载 Chrome浏览器
欢迎光临IT大师技术资料资讯网。软件开发交流群:60831381

使用TransactionScope做分布式事务协调

 chenxizhang  2008/07/29  77

; conn2.Open(); SqlCommand cmd2 = conn2.CreateCommand(); cmd2.CommandText = "DROP TABLE Table1"; ...
阅读全文 77

使用多结果集读取数据减少服务器往返,提高性能

 chenxizhang  2008/07/29  75

;MultipleActiveResultSets=true")){ SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT CustomerID FROM Customers;S...
阅读全文 75

基于sqlce的数据操作

 weixing  2011/07/08  159

39;cn.Open() sqlstr = "select * from CorporationInfo cmd = cn.CreateCommand cmd.CommandText = sqlstr Dim da As New SqlCeDataAdapter(cmd) da.Fi...
阅读全文 159

.NET : 存取BLOB数据(Oracle)

 chenxizhang  2009/07/09  182

{ using (OracleCommand cmd = conn.CreateCommand()) { cmd.Comman...
阅读全文 182

读取数据库中的图片(ASP.NET)

 chenxizhang  2010/04/14  133

ted security=true;")){conn.Open();using (SqlCommand cmd = conn.CreateCommand()){cmd.CommandText = "SELECT Photo FROM Employees WHERE Employ...
阅读全文 133

自定义TraceListener的例子

 chenxizhang  2010/03/20  176

ase;Integrated security=true;")) {using (SqlCommand cmd = conn.CreateCommand()) {cmd.CommandText = "INSERT INTO Logs(Message) VALUES(@messa...
阅读全文 176

.NET : 如何将大文件写入到数据库中

 chenxizhang  2009/07/28  150

ity=true")) { using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "SE...
阅读全文 150

SQL Server、Oracle、db2所提供的简装版(Express)比较

 chenxizhang  2011/11/26  196

r;Server=localhost;password=password01!");//创建命令var cmd = conn.CreateCommand();cmd.CommandText = "SELECT * FROM Employee";//打开连接conn.O...
阅读全文 196

Using ARITHABORT with LLBLGen

 JamesLi  2013/03/23  1740

car_5
n();var connection = GetActiveConnection();var command = connection.CreateCommand();command.CommandText = "SET ARITHABORT ON";var arithAbor...
阅读全文 1740

使用For XML与XSL(XSLT)配套快速输出查询结果到Web页面

 chenxizhang  2008/06/22  125

ion(connectionString)){conn.Open();using (SqlCommand cmd = conn.CreateCommand()){cmd.CommandText = "SELECT ProductID,ProductName FROM P...
阅读全文 125