.net连接sqlserver

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace testSqlServerConnection
{
class Program
{

static string connString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=Test;Integrated Security=TRUE";//连接字符串
static string sql = "select * from dbo.user1";
public static SqlConnection conn;

 

static void Main(string[] args)
{

conn = new SqlConnection(connString);
int a = -1;

try
{
conn.Open(); //打开数据库
SqlCommand cmd = new SqlCommand(sql, conn);
a = cmd.ExecuteNonQuery();
System.Diagnostics.Debug.WriteLine("###########" + "连接成功");
}

catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("###########" + e.Message);

}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close(); //关闭数据库  
}
}

 

}

 

 

}
}

 

 

参考网站：

https://blog.csdn.net/qq_41877039/article/details/89810341