C# Access 读取数据问题

2025-03-19 09:38:44
推荐回答(1个)
回答1:

 using (OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=user.mdb;Persist Security Info=False;Jet OLEDB:Database Password="))
            {
                string query = "select * from youTableName";
                using (OleDbCommand cmd = new OleDbCommand(query, con))
                {
                    con.Open();
                    OleDbDataReader reader = cmd.ExecuteReader();
                    while (reader.Read())
                    {
                        reader[0].ToString();
                        reader[1].ToString();
                        reader[2].ToString();
                        reader[3].ToString();
                        reader[4].ToString();
                        reader[5].ToString();
                        reader[6].ToString();
                        reader[7].ToString();
                        reader[8].ToString();
                    }
                }
            }