一些数据连接：What I have done in the past year:my old code "DataSet"

1 Save Changes into DataBase 

 

 string strDSN = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D://pxf.accdb";
        string strSQL = "SELECT * FROM Table1";
                           OleDbConnection myConn = new OleDbConnection(strDSN);
            OleDbDataAdapter myCmd = new OleDbDataAdapter(strSQL, myConn);
            DataSet dtSet = new DataSet();
            myConn.Open();
            myCmd.Fill(dtSet, "Table1");
            DataTable dTable = dtSet.Tables[0];
            DataRow dr = dTable.NewRow();
            dr["name"] = textBox1.Text;
            dTable.Rows.Add(dr);
            OleDbCommandBuilder myb = new OleDbCommandBuilder(myCmd);
            myCmd.Update(dtSet, "Table1");
            myConn.Close();
2 DataGridView and DataSet

 

  string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D://mctest.mdb";

            OleDbConnection myConnection = new OleDbConnection();
            myConnection.ConnectionString = connString;

            OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM Developer", myConnection);

            DataSet ds = new DataSet();

            da.Fill(ds, "Developer");

            dataGridView1.DataSource = ds.Tables[0];

3 Touch OleDb

 

string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D://mcTest.MDB";
            OleDbConnection myConn = new OleDbConnection(strDSN);

 

            string strSQL = "SELECT * FROM Developer";          
            OleDbCommand myCmd = new OleDbCommand(strSQL, myConn);
            OleDbDataReader datareader = null;        
                myConn.Open();
                datareader = myCmd.ExecuteReader();
                while (datareader.Read())
                {
                    Console.WriteLine("Developer Name:{0}, Address:{1},Salary:{2}", datareader["Name"], datareader["Address"],datareader["Salary"]);
                }           
                myConn.Close();