Question

C#中连接数据库的语句？

Answer 1

SQL是 SqlConnection con = new SqlConnection("database=***;Server=.;User ID=sa;Password=;Persist Security Info=True");access是 string connst = "Provider=Microsoft.Jet.OleDb.4.0;"; connst += @"Data Source=" + Application.StartupPath + "/***.mdb"; OleDbConnection con = new OleDbConnection(connst);

Answer 2

c#数据库连接代码///系统引用using System.Data;
using System.Data.OleDb;//Access数据库需要
using System.Data.SqlClient;//SQL数据库需要 c#本地MDB数据库连接
private void menuItem2_Click(object sender, System.EventArgs e)
{
//创建一个 OleDbConnection对象
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = ../../database/MDB数据库名称.mdb" ;
OleDbConnection myConn = new OleDbConnection ( strCon ) ; }#本地SQL数据库连接
private void menuItem3_Click(object sender, System.EventArgs e)
{
//创建一个 SqlConnection对象
string strCon = "Integrated Security=SSPI;Initial Catalog='数据库名称';Data Source='本地计算机名';User ID='登录用户名';Password='登录用户密码';Connect Timeout=30";
SqlConnection myConn = new SqlConnection ( strCon ) ; }