VS2022连接sqlserver数据库教程

using System.Data.SqlClient;

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
 
 
public static class data_Control
{
 
    public static void TestConSQL()
    {
        //测试连接数据库
        string connStr = "Data Source=LAPTOP-82MUPKTO;Initial Catalog=考试系统数据库测试版;Integrated Security=True";//自己替换一下服务器名字和数据库名字
        SqlConnection conn = new SqlConnection(connStr);//这里如果报错，请退回去检查你的NUget包
        //打开数据库
        conn.Open();
        Console.WriteLine("打开数据库连接");
        //关闭数据库
        conn.Close();
        Console.WriteLine("关闭数据库连接");
    }
}

data_Control.TestConSQL();

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
 
 
public static class data_Control
{
    public static void addtable(string tablename)
    {
 
    }
 
 
 
 
    public static void TestConSQL()
    {
        //测试连接数据库
        string connStr = "Data Source=服务器名;Initial Catalog=数据库名;User ID = 账号;PassWord=密码";
        SqlConnection conn = new SqlConnection(connStr);//报错请检查NuGET包
        //打开数据库
        conn.Open();
        Console.WriteLine("打开数据库连接");
        //关闭数据库
        conn.Close();
        Console.WriteLine("关闭数据库连接");
    }
}