sqlconnection Questions
4
Solved
I have implemented SqlTransaction in c# to begin, commit and rollback transaction. Everything is going right, but I've got some problem while accessing those tables which are in connection during t...
Legitimize asked 29/2, 2012 at 8:33
4
Solved
when developing windows applications:
How I secure the user name and password in the connection string?
Organizations like banks, would they give out the user name and password of their DB to app...
Yod asked 24/1, 2014 at 7:40
2
Solved
On my application I need to connect at client database(SqlServer) only to see if we can connect.
These are my connection strings from web.config(the values are not that way, I´ve changed the ip, us...
Cling asked 17/12, 2013 at 11:15
1
Solved
I'm referring to a post that was put on Stack Overflow a long, long time ago.
Does End Using close an open SQL Connection
I have a problem however. I found that using does not close the connection...
Recommendation asked 25/11, 2013 at 20:55
2
Solved
For SQL connection pool, why do we need to set up a min pool size? As connections will be saved in the connection pool and reused, why do we need to keep live connections specified by the min pool ...
Giannagianni asked 7/10, 2013 at 9:52
2
Solved
I have this code down which I tried to make it Test SQL string connectivity, but I dont know how to handle the part with connection.Open = true would you please help me to solve this out? Thank you...
Cioffi asked 25/7, 2013 at 8:56
5
Solved
I've a connection string saved to Properties.Settings.Default, i need to use an sql connection in all classes without having to declare it everytime, so how should it be declared?
Contrast asked 2/3, 2013 at 12:43
4
I've been trying to connect to my database (which is on the same computer as my code) through my C# code. The problem is I keep getting the "Login failed for user " "" error... I admit that my know...
Runner asked 28/1, 2013 at 17:43
5
Solved
I have the following code
try
{
using (var connection = new SqlConnection(Utils.ConnectionString))
{
connection.Open();
using (var cmd = new SqlCommand("StoredProcedure", connection))
{
c...
Pavior asked 26/9, 2011 at 8:12
1
In my Datasnap client application I use 1 TSQLConnection for my methods and ProviderConnection.
The problems arise when the connection is lost. Both TSQLConnection.Connected and TSQLConnection.Conn...
Pasta asked 12/12, 2012 at 16:30
6
Solved
Possible Duplicate:
SQL Server query to find all current database names
I am trying to figure out how to list the databases after connecting to the servers without specifying a databa...
Colleen asked 12/10, 2012 at 15:42
1
Solved
Whilst investigating a very dull and exponetially security flawful 2005 project, I debugged into a connection hang.
Inspecting the object, to find the server name, I've encountered this three littl...
Misplace asked 10/10, 2012 at 14:7
2
Solved
when ever I make connection it gives an error
Unrecognized escape sequence.
NEPOLEON\ADMN HERE ON THIS SLASH. NEPOLEON\ADMN IS MY SQL SERVER NAME.
SqlConnection con = new SqlConnection("Serv...
Gean asked 25/9, 2012 at 15:22
1
Solved
my problem: Earlier this week, I got the task to speed up a task in our program. I looked at it and immediately got the idea of using a parallel foreach loop for a function in that task.
I impleme...
Hugely asked 18/8, 2012 at 17:36
1
Solved
I'm working with a DAL object that is written in a layout similar to the following code. I simplified a lot of the code code just to show the setup.
public class UserDatabase : IDisposable
{
priv...
Schoonmaker asked 27/6, 2012 at 23:31
3
I have multiple threads accessing the same database (with same connection string). Each thread:
creates it's own SqlConnection instance using the same connection string
uses code below to open it...
Doublepark asked 20/3, 2012 at 23:30
2
Solved
If methods/functions I'm going to call involve the need of an open SqlConnection, I will open this up in the method which is calling the function. For example:
protected static void btnSubmit(){
...
Misbegotten asked 21/3, 2012 at 15:4
1
Solved
I've a question about EntityFramework with CodeFirst approach. Based on EntityConnection source code and documentation I can't create it with already opened SqlConnection. It requires that is shoul...
Glennglenna asked 19/3, 2012 at 15:49
8
Solved
I have an sqlConnection manager class like so:
public class SQLConn {
public string connStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
private SqlConnection s...
Carmelinacarmelita asked 27/5, 2009 at 10:31
1
How does one pin a certificate when using s SqlConnection? From SqlConnection Connection String Parameter Keywords & Values, I know I can set Encrypted to true to force (encourage?) use of SSL/...
Davita asked 1/1, 2012 at 5:20
3
Solved
Ok, I asked about this very error earlier this week and had some very helpful answers and without doubt things have drastically improved since I started following the suggestions.
However, now I a...
Soldiery asked 8/5, 2009 at 9:30
5
Solved
The title pretty much says it all. I want to create a SqlConnection and then check that connection without opening a database, cause at that point I don't know yet where will I connect to. Is it po...
Renown asked 30/9, 2008 at 19:8
3
Solved
I am querying the db in a separate thread.
If I close the application while the query is being executed, will the SqlConnection automatically close or will it remain open?
Animated asked 23/9, 2011 at 21:8
2
Solved
Does SqlDataAdapter close the SqlConnection after the Fill() function or do I need close it myself?
string cnStr = @"Data Source=TEST;Initial Catalog=Suite;Persist Security Info=True;User ID=app;P...
Merissameristem asked 12/9, 2011 at 13:33
2
Solved
What is the difference between the SQL Connection and OLEDB Connection? Is that OLEDB is common to all (also SQL Server)? To which are all Servers, OLEDB is using?
Farnsworth asked 20/8, 2011 at 7:6
© 2022 - 2024 — McMap. All rights reserved.