/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

-1 vote332 views1 answer
How to make a beep in c#
C#
5 votes344 views1 answer
Write text files with C#
C#
0 vote366 views1 answer
Classe padre figlio c#
C#
2 votes307 views7 answers
Covid
C#
0 vote383 views2 answers
Remove all non alphabetic characters from string c#
C#
0 vote348 views1 answer
Unity generate random offset position around a gameobject
C#Unity
0 vote360 views1 answer
Unity exenerate
C#Unity
6 votes337 views3 answers
C# return switch
C#
0 vote329 views2 answers
How to use K2 games Games parallax background
C#
2 votes318 views1 answer
C# to binary
C#