Conn.open and Conn.close

Question

1.00/5 (1 vote)

See more:

SQL

Hi,

Where want to use Conn.open and Conn.close in sql server. Whats the use of it.

Thanks in Advance.

Posted 9-Feb-12 23:15pm

Shanthoshshanmugam

Add a Solution

Comments

thatraja 10-Feb-12 5:39am

Probably you have to take a look at ADO.NET. Go to MSDN

Shanthoshshanmugam 10-Feb-12 5:41am

Ok Thanks!!

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Accepted Answer · 2012-02-09T23:23:00

If you don't know the use of it, your "want to use" makes no sense.

And this is not "Conn". There are few classes derived from System.Data.Common.DbConnection, see:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx[^],
http://msdn.microsoft.com/en-us/library/system.data.common.dbconnection.open.aspx[^],
http://msdn.microsoft.com/en-us/library/system.data.common.dbconnection.close.aspx[^].

A quick answer should be enough: you want to use it because otherwise nothing can work.

—SA

Member 8178233 · Accepted Answer · 2012-02-09T23:27:00

Solution 3

conn.open()is used to connecting to database

conn.close()is used to disconnecting from database

Posted 9-Feb-12 23:27pm

Member 8178233

Comments

Shanthoshshanmugam 10-Feb-12 5:30am

ok without using open and close connection if we executes the query means what will happen?

Thanks in Advance

Nilesh Patil Kolhapur 10-Feb-12 5:46am

without open connection u cant execute any single query on database

Shanthoshshanmugam 10-Feb-12 5:32am

Without using it, all the operation is working correctly whats the difference between that?

Nilesh Patil Kolhapur 10-Feb-12 6:49am

how its working let me know?

Espen Harlinn 11-Feb-12 5:13am

5'ed!

Nilesh Patil Kolhapur · Accepted Answer · 2012-02-09T23:48:00

Solution 4

Hi,
First of all understand the connected and disconnected architecture it will help u lot

Posted 9-Feb-12 23:48pm

Nilesh Patil Kolhapur

Member 8178233 · Accepted Answer · 2012-02-09T23:48:00

Solution 5

yes, without using con.open() u can not fire a single query to database