Pulling in Access Database Entry using C#

Question

I'm trying to figure out how to pull specific Entry lines from an Access Database and into a C# Program.

I'm working with a friend to make a sudoku game. We want to pull different levels of difficulty of puzzles from an access database and into a C# program.

Now my question is: Is there a way to have to program pull the specific lines from the database or would we need to load them all into the program and then have them selected from there? These would be put into a two-dimensional array.

What would be the best way to go about this?

What did you try so far? What does your database look like?

z32a7ul
– z32a7ul

2017-04-04 15:19:31 +00:00
Commented Apr 4, 2017 at 15:19 — z32a7ul
– z32a7ul, Commented Apr 4, 2017 at 15:19
Here's one question that might help you on your way.

Phil Cooper
– Phil Cooper

2017-04-04 16:32:42 +00:00
Commented Apr 4, 2017 at 16:32 — Phil Cooper
– Phil Cooper, Commented Apr 4, 2017 at 16:32

ASH · Accepted Answer · 2017-04-04 16:40:16Z

I'm not sure what soduku is, but I'm thinking that you need to query your Access DB. Something like this should get you started.

Class BusLogic
{
 public List<string> ListboxItems = new List<string>();
 public void PopulateListBoxItems(string userName)
 {
  string connString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\redgabanan\Desktop\Gabanan_Red_dbaseCon\Red_Database.accdb";
  using (OleDbConnection connection = new OleDbConnection(connString))
  {
        connection.Open();
        OleDbDataReader reader = null;
        OleDbCommand command = new OleDbCommand("SELECT * from  Users WHERE LastName='@1'", connection);            
        command.Parameters.AddWithValue("@1", userName)
        reader = command.ExecuteReader();    
        while (reader.Read())
        {
            ListboxItems.Add(reader[1].ToString()+","+reader[2].ToString());
        }    
   }
 }    
}

You could use a DataReader as well.

http://www.akadia.com/services/dotnet_data_reader.html

You definitely don't want to pull in all data from a Table; you need to somehow Query the data set.

Collectives™ on Stack Overflow

Pulling in Access Database Entry using C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related