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 vote298 views1 answer
Unity making homing missile
C#Unity
0 vote173 views1 answer
Use raycast unity new input system
C#
2 votes234 views1 answer
Unity load current scene
C#Unity
33 votes150 views2 answers
C# string array initialization
C#
0 vote147 views2 answers
Scaffold db
C#
2 votes168 views2 answers
Largest element in array in c#
C#
1 vote144 views1 answer
Fluentassertions force exceptions
C#
0 vote113 views1 answer
Discord bot c# interrupt CollectReactionsAsync
C#
1 vote168 views2 answers
C# calcualte proccess
C#
2 votes160 views3 answers
Asp.net core 3.1 ajax partial view
C#