C#鏈接數據庫技巧

連接sql數據庫：
  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");
    }

************************************************************

連接access

原文轉自：http://www.anti-gravitydesign.com