sqlconnection
SqlConnection error Named Pipes Provider
A little background: I have a Windows .NET application that is in use by approximately 40 field employees across North America.This program allows the users to enter data while in the field (away for[详细]
2023-01-06 01:30 分类:问答Global SqlConnection
I have a Web Service that requires an SqlConnection. There are 5 web methods that use this SqlConnection, but presently they are declared (locally) in each of the methods. Would it be acceptable to ma[详细]
2023-01-05 23:27 分类:问答Detecting if the garbage collector was invoked (.Net)
When using SqlConnection, it\'s important to always close it when used - either by .Clos开发者_Python百科e() or placing the SqlConnection in a \"using\". Unfurtunately, people, including myself, tend[详细]
2023-01-05 16:04 分类:问答Remote connection to SQL Server Express fails
I have two computers that share the same Internet IP address. Using one of the computers, I can remotely connect to a SQL Server database on the other. Here is my connection string:[详细]
2023-01-03 06:52 分类:问答Why is my SQL Server query failing?
connect(); $arr = mssql_fetch_assoc(mssql_query(\"SELECT Applications.ProductName, Applications.ProductVersion, Applications.ProductSize,[详细]
2023-01-02 04:43 分类:问答Passing around a SqlConnection
I have created a TransactionScope and within the scope various items are created and updated in the datab开发者_如何学JAVAase. During this process I make a lot of calls to the database. Originally I o[详细]
2022-12-31 17:27 分类:问答Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
What does it mean for an SqlConnection to be \"enlisted\" in a transaction?Does it simply mean that commands I execute on the connection will participate in the transaction?[详细]
2022-12-31 11:50 分类:问答how to close a sqlconnection in asp.net
i would like to know if there\'s something wrong in this asp.net code: mydatareader = mycmd.executeReader()[详细]
2022-12-30 08:09 分类:问答Is closing/disposing an SqlDataReader needed if you are already closing the SqlConnection?
I noticed This question, but my question is a bit more specific. Is there any advantage to using using (SqlConnection conn = new SqlConnection(conStr))[详细]
2022-12-27 09:39 分类:问答If we cannot retrieve output parameters until SqlDataReader is closed, then why...?
1) While the SqlDataReader is being used, the associated SqlConnection is busy serving the SqlDataReader, and no other operations can be performed on the SqlConnection other than closing it. This is[详细]
2022-12-27 06:37 分类:问答