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

来源：互联网发布：长期服用知柏地黄丸编辑：程序博客网时间：2024/04/30 07:31

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();