C# how to fill a datatable

public DataTable GetData()
{
    SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["BarManConnectionString"].ConnectionString);
    conn.Open();
    string query = "SELECT * FROM [EventOne]";
    SqlCommand cmd = new SqlCommand(query, conn);

    DataTable dt = new DataTable();
    dt.Load(cmd.ExecuteReader());
    conn.Close();
    return dt;
}

Source: stackoverflow.com

Similar codes

0 vote230 views1 answer
C# enum key value
C#
6 votes239 views1 answer
Asp.net core entity framework database first
C#
0 vote296 views1 answer
C# check if pdf is protected without password
C#
0 vote248 views1 answer
C# random hash
C#
-1 vote236 views1 answer
Find first occurrence of character in string
C#
0 vote270 views1 answer
Unity disable the display of the camera frustrum
C#Unity
1 vote253 views1 answer
C# array remove first element
C#
1 vote233 views2 answers
How to make a game
C#
14 votes258 views1 answer
Unity set position
C#Unity
0 vote235 views1 answer
Unity generate random offset position around a gameobject
C#