ADO.net 中数据库连接方式(微软提供)

 

ADO.net 中数据库连接方式(微软提供)

微软提供了以下四种数据库连接方式：
System.Data.OleDb.OleDbConnection
System.Data.SqlClient.SqlConnection
System.Data.Odbc.OdbcConnection
System.Data.OracleClient.OracleConnection

 

private void Form1_Load(object sender, System.EventArgs e)
  {
   string source="server=127.0.0.1;"+"uid=sa;pwd=sa;"+"database=DatabaseName";
   string select ="select * from TableName";
   SqlConnection conn = new SqlConnection(source);
   SqlDataAdapter da= new SqlDataAdapter(select,conn);
   DataSet ds= new DataSet();
   da.Fill(ds,"TableName");
   dataGrid1.SetDataBinding(ds,"TableName"); 
    }