Represents an open connection to a SQL Server database.
How do you check if it is open or closed I was using if (SQLOperator.SQLCONNECTION.State.Equals("Open")) however, …
c# ado.net sqlconnectionAn application that has been working without problem (and has not had any active development done on it in about 6 …
sql-server security sqlconnectionI'm trying to write Connection string to Web.config like this: <connectionStrings> <add name="Dbconnection" connectionString="Server=…
c# asp.net sqlconnectionI am creating a project in which I need to run 2-3 SQL commands in a single SQL connection. Here …
c# sql-server ado.net sqlconnection sqlcommandFirst question: Say I have using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); string storedProc = "GetData"; SqlCommand command = new SqlCommand(…
c# using sqlconnectionI've never used the "appSettings" before. How do you configure this in C# to use with a SqlConnection, this is …
c# asp.net sql sqlconnectionI am trying to override the default SqlConnection timeout of 15 seconds and am getting an error saying that the property …
c# .net sql-server sqlconnectionI have my business-logic implemented in simple static classes with static methods. Each of these methods opens/closes SQL connection …
c# sqlconnectionIs there any difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout in .NET?
.net sqlconnection sqlcommandI've been trying to connect to my database (which is on the same computer as my code) through my C# …
c# sql database sqlconnection