区别介绍:
OleDbConnection适合于连接任何类型的数据库(如Oracle,SQL
使用方法:
OleDB:
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=SQLOLEDB;DataSource=PCBDEVELOP01\\SQL2008';InitialCatalog=MyDB_YK;uid=reportAdmin;pwd=reportAdmin#";
try
{
conn.Open();
MessageBox.Show("OK");
conn.Close();
}
catch
{
MessageBox.Show("error");
}
注:
连接字串还可以使用Trusted_Connection=Yes来声明这是一个值得信任的连接字串,而不需要输入用户名和密码,示例代码如下所示。
string str2 =
"Provider=SQLOLEDB;Data Source=(local);Initial Catalog=mytable;Trusted_Connection=Yes";
OleDbConnection con = new OleDbConnection(str2);
SqlConnect:
string strCon = @"server='PCBDEVELOP01\SQL2008';database='MyDB_YK';uid='reportAdmin';pwd='reportAdmin#'";
SqlConnection conn=new SqlConnection(strCon);
try
{
conn.Open();
MessageBox.Show("数据库联接成功");
conn.Close();
}
catch
{
MessageBox.Show("数据库联接失败");
}