数据库连接
- 方法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
string ConStr = "Data Source =服务器地址;Initial Catalog =表名;User Id =用户名;Password =密码";
SqlConnection SqlCon = new SqlConnection(ConStr);
SqlCon.Open();
Console.WriteLine("The sql is open!");