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
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
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
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:
connect(); $arr = mssql_fetch_assoc(mssql_query(\"SELECT Applications.ProductName, Applications.ProductVersion, Applications.ProductSize,
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
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?
i would like to know if there\'s something wrong in this asp.net code: mydatareader = mycmd.executeReader()
I noticed This question, but my question is a bit more specific. Is there any advantage to using using (SqlConnection conn = new SqlConnection(conStr))
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