using System; using System.Data; using System.Data.SqlClient;SqlConnection conn = new SqlConnection(); conn.Connectionstring = ... //参考www.connectionstrings.com,有很多写法的 conn.Open(); conn.Close();
http://www.connectionstrings.com/
C#: using System.Data.SqlClient; SqlConnection oSQLConn = new SqlConnection(); oSQLConn.ConnectionString="my connectionstring"; oSQLConn.Open(); ????????其它的怎么做,我打开工具栏的连接数据库,连SQL为什么连不上,但是ACCESS可以????
我要连的是SQL
using System.Data;
using System.Data.SqlClient;SqlConnection conn = new SqlConnection();
conn.Connectionstring = ... //参考www.connectionstrings.com,有很多写法的
conn.Open();
conn.Close();
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="my connectionstring";
oSQLConn.Open(); ????????其它的怎么做,我打开工具栏的连接数据库,连SQL为什么连不上,但是ACCESS可以????
www.connectionstrings.com 好象说得很详细
SqlConnection con=new SqlConnection(connectstring);
con.Open();
con.close();
确切来说就是
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="Server=你的主机;Database=你的数据库名;UserID=在那个数据库的用户;Password=那个用户的密码 Trusted_Connection=False ";
oSQLConn.Open();
string ConnectionString = "连接字符串";
SqlConnection conn = new SqlConnection(ConnectionString);
try
{
Conn.Open();
}
catch
{
Conn.Close();
}