C#ÈçºÎÏòaccessÊý¾Ý¿âÖÐдÈëÒ»ÐÐÊý¾Ý£¿

Ò²¾ÍÊÇÏòÊý¾Ý¿âÖÐÌí¼ÓÒ»Ìõ¼Ç¼¡£ÇëÖ¸½Ì£¬Ð»Ð»¡£

---

DataSet Ds = new DataSet();
            using (SqlConnection Conn = new SqlConnection("server=.;uid=sa;pwd=1234;database=dbtemp"))
            {
                SqlCommand Cmd = new SqlCommand();
                Cmd.CommandText = "sql Óï¾ä";
                Cmd.Connection = Conn;
                Conn.Open();
                Cmd.ExecuteNonQuery();
            }

---

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\bin\LocalAccess40.mdb");
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "SQL Óï¾ä";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

---

[c

ÒýÓÃ

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\bin\LocalAccess40.mdb");
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "SQL Óï¾ä";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();