how to run query that makes table in access throw C#

Question

hi

i need to run query that i have in access and makes table - called "MyQuery"

how to run this query in C# code ?

thank's in advance

Answer 1

Have a look at this thread on vbCity, which seems to be exactly about your problem.

Your code might then look similar to this:

using System.Data;
using System.Data.

using (IDbConnection conn = new OleDbConnection(...)) // <- add connection string
{
    conn.Open();
    try
    {
        IDbCommand command = conn.CreateCommand();

        // option 1:
        command.CommandText = "SELECT ... FROM MyQuery";

        // option 2:
        command.CommandType = CommandType.TableDirect;
        command.CommandText = "MyQuery";

        // option 3:
        command.CommandType = CommandType.StoredProcedure;
        command.CommandText = "MyQuery";

        using (IDataReader reader = command.ExecuteReader())
        {
            // do something with the result set returned by reader...
        }
    }
    finally
    {
        conn.Close();
    }
}