Use C to determine whether the SQL server is started

You can take a look at this paragraph**, I believe it should be useful. Judge before connecting, close the connection and then reopen it if it is open, and open it directly if it is not.

private static sqlconnection connection;

public static sqlconnection connection

getstring connectionstring = @"";Database connection statements.

if (connection == null)

connection = new sqlconnection(connectionstring);

else if ( ==

else if ( ==

return connection;

This one seems to only throw an exception.

There is no specific way to determine whether there is a database started or not.

Implement it with the following **Implementation,**.

public static bool testrun(string cmd, ref string str)

process p = new process();

false;

true;true;

true;true;

If it is connected, it means that it is started, but it is not connected when an error is reported.

using system;

using ;

using ;

using ;

using ;

namespace baiduexample) != null)

is a database instance", servername, isloalip ? "Local" : "Remotely"));Output the result.

This question can be considered in this way. Because c itself runs on the server side, which means that the program is on the server no matter how it is judged. Relative to it is local.

From the server's perspective, SQL is local. From the client's point of view, it's remote. How do you say?

Hehe, the above is my understanding. Errors are also understood.

Look at the IP address.

If it's local or it's local.

If it's not two, it's remote.

1l Don't mislead. It's just a loopback address. If you fill in the actual IP of the machine, or the name of the machine, do you still judge it like this?

I don't know why you need it, though. If you want to achieve something, it's best to think differently.

private sqlconnection conn;

public sqlconnection conngetstring stringconn = data source=.;initial catalog=lhhdb;persist security info=true;user id=sa;password=fubing";

if (conn ==null) if the connection is empty. Just create one.

conn = new sqlconnection(stringconn);

else if ( == If the connection is corrupted, close it in the On {;

else if ( == ON if it is off.

return conn;

I don't know if the landlord means that.

You seem to be making a secondary menu. The first level is the database name, and the second level is all the tables in the corresponding database.

Query the database name.

In the master database, select name from all tables in a certain database, and query select * from in this database, if you want to check others, you can i in where type=?

select [name] from [sysdatabases] order by [name]

By the way, I'll send you one to see all the tables.

select [id], name] from [sysobjects] where [type] = 'u' order by [name]

Upstairs is right, it can be loaded with SQL statements.

sqlconnection conn = new sqlconnection(constr);

If. Plagiarism is plagiarism off the state.

if ( ==