/C#/Connect to a database and loop over a recordset in C#

Connect to a database and loop over a recordset in C#

using System.Data.OleDb;
...

using (OleDbConnection conn = new OleDbConnection())
{
    conn.ConnectionString = "Provider=sqloledb;Data Source=yourServername\\yourInstance;Initial Catalog=databaseName;Integrated Security=SSPI;";

    using (OleDbCommand cmd = new OleDbCommand())
    {
        conn.Open();
        cmd.Connection = conn;
        cmd.CommandText = "Select * from yourTable";

        using (OleDbDataReader dr = cmd.ExecuteReader())
        {
            while (dr.Read())
            {
                Console.WriteLine(dr["columnName"]);
            }
        }
    }
}

Source: stackoverflow.com

Similar codes

0 vote155 views1 answer
C# object list contains object returns incorrect boolean
C#
17 votes111 views1 answer
Check if dictionary contains value c#
C#
1 vote159 views2 answers
C# integer part of float
C#
0 vote142 views1 answer
How to download things c#
C#
0 vote113 views1 answer
Copy-the-entire-contents-of-a-directory-in-c-sharp
C#
0 vote188 views2 answers
How to pass value to anothe form c# winform
C#
0 vote141 views1 answer
An existing connection was forcibly closed by the remote host. .net core
C#
0 vote152 views1 answer
Flatten a list of lists in C#
C#
3 votes147 views2 answers
C# console header
C#
19 votes189 views2 answers
How to install pyaurogui on windows
C#