dot.net常用数据库连接

string connectionString = "Data Source=(local)//SQLEXPRESS;Initial Catalog=db_09;User ID=sa;Password=gecheng"; //SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=gecheng;database=db_09"); SqlConnection con = new SqlConnection(connectionString); con.Open(); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter("select * from tb_01", con); da.Fill(ds); this.dataGridView1.DataSource = ds.Tables[0].DefaultView;

 

 

  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Operation Access 'Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=" + Application.StartupPath + "/Student.mdb" 'Dim sqlString = "SELECT * FROM tbClass" 'Operation Oracle 'Dim connectionString As String = "Provider=MSDAORA;Data Source=orcl;User ID=hr;Password=gecheng;" 'Dim sqlString = "SELECT * FROM COUNTRIES" 'Operation SQLEXPRESS ERR Dim connectionString As String = "Provider=SQLOLEDB;Data Source=(local)/SQLEXPRESS;Initial Catalog=db_09;User ID=sa;Password=gecheng" 'Dim connectionString As String = "Provider=SQLOLEDB;Data Source=(local)/SQLEXPRESS;Initial Catalog=db_09;Integrated Security=SSPI;" Dim sqlString = "SELECT * FROM tb_01" Dim conn As New OleDb.OleDbConnection(connectionString) Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand(sqlString, conn) cmd.CommandType = CommandType.Text Dim ObjectdsDataSet As New DataSet() Dim adapter As New OleDb.OleDbDataAdapter() adapter.TableMappings.Add("Table", "TEMP") adapter.SelectCommand = cmd If conn.State <> ConnectionState.Open Then conn.Open() '打开数据库连接 End If cmd.ExecuteNonQuery() '执行SQL语句 If conn.State <> ConnectionState.Closed Then conn.Close() '关闭数据库连接 End If adapter.Fill(ObjectdsDataSet) '填充数据集 Me.DataGridView1.DataSource = ObjectdsDataSet.Tables(0).DefaultView End Sub

 

使用OLE DB方式连接常用数据库的连接字符串的设置

SQL Server 使用 OLE DB 所设置的连接字符串:

标准连接方式 Provider=sqloledb;Data Source=datasource;Initial Catalog=DbName;User Id=username;Password=pwd; 信任连接方式: Provider=sqloledb;Data Source=datasource;Initial Catalog=DbName;Integrated Security=true;

------------------------------------------------------------------------------------------

Access使用 OLE DB 所设置的连接字符串: 标准连接方式:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/Path/Db.mdb;User Id=username;Password=pwd;

工作组方式: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/Path/Db.mdb;Jet OLEDB:System Database=system.mdw; 包含密码方式: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/Path/Db.mdb;Jet OLEDB:Database Password=pwd;

 ------------------------------------------------------------------------------------------

Oracle 使用 OLE DB 所设置的连接字符串:

微软提供的标准安全连接方式: Provider=msdaora;Data Source=datasource;User Id=username;Password=PWD;

Oracle 提供的标准安全连接方式: Provider=OraOLEDB;Data Source=MyOracleDB;User Id=username;Password=PWD;

信任连接方式: Provider=OraOLEDB.Oracle;Data Source=datasource;OSAuthent=1;

 ------------------------------------------------------------------------------------------

Excel 使用 OLE DB 所设置的连接字符串

标准连接方式: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/MyEcxel.xls;Extended Properties=" ";

------------------------------------------------------------------------------------------

Informix 使用 OLE DB 所设置的连接字符串

IBM Informix OLE DB Provider: Provider=Ifxoledbc.2;UserID=username;Password=PWD;DataSource=dbName@serverName;Persist Security Info=true;