C#连接sql的两种方法

数据库连接

1. 方法1

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;  //表的命名空间
using System.Data.SqlClient; //SQL相关的命名空间


namespace connectsql
{
    internal class Program
    {
        static void Main(string[] args)
        {
            //方法一 
            //声明一个SqlConnectionStringBuilder对象
            SqlConnectionStringBuilder search = new SqlConnectionStringBuilder();
            search.DataSource = ""; //设置数据源服务器
            search.UserID = "";//设置用户名
            search.Password = "";//密码
            search.InitialCatalog = "";//设置需要访问的数据库名
            SqlConnection SqlCon = new SqlConnection(search.ToString()); //创建连接
            SqlCon.Open();//打开数据库
           if(SqlCon.State == ConnectionState.Open)
            {
                Console.WriteLine("The sql is open!");
            }
            Console.WriteLine();
            Console.ReadLine();
        }
    }
}

2. 方法2

string ConStr = "Data Source =服务器地址;Initial Catalog =表名;User Id =用户名;Password =密码";
            SqlConnection SqlCon = new SqlConnection(ConStr);
            SqlCon.Open();
            Console.WriteLine("The sql is open!");