C#连接Access和SQL Server数据库

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Data.OleDb;using System.Windows.Forms;using System.Data.SqlClient;namespace Str{ public partial class Form1 : Form { public Form1() { InitializeComponent(); /* * connect to Sql Server */ string strConnection = "Data Source=ZRQ-PC;"; strConnection+="Initial Catalog=master;Integrated Security=True"; SqlConnection objConnection = new SqlConnection(strConnection); objConnection.Open(); objConnection.Close(); /**************************************************************/ /* * connect to access table */ //string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;"; //strConnection += @"Data Source=C:/Users/ZRQ/Documents/STU.accdb"; //OleDbConnection objConnection = new OleDbConnection(strConnection); //objConnection.Open(); //objConnection.Close(); /**************************************************************/ /* *as for connect to Oracle or MySql 等我学了再说吧……(*^__^*) */ } }}

 

其中的简易办法：

 

在“服务器资源管理器”中选择要连接的数据，then看它的属性中Name，copy to strConnection 即可~