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

4 votes140 views4 answers
Convert foreach to linq c#
C#
0 vote166 views1 answer
Reference a class by string unity
C#Unity
0 vote123 views1 answer
VSIX Project Context Menu
C#
0 vote125 views1 answer
Blazor swagger setup
C#
0 vote175 views1 answer
How to play a random sound at the position that you want in unity
C#Unity
0 vote123 views1 answer
How to tell visual studio that you're using unity
C#
1 vote131 views1 answer
Unity getcomponent not working on ui
C#
1 vote134 views1 answer
String in int c#
C#
0 vote164 views1 answer
Unity dotween sequence
C#Unity
0 vote114 views1 answer
Vector2 with switch statement
C#