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

2 votes412 views1 answer
Unity ray from mouse position
C#Unity
0 vote352 views1 answer
Nuget Microsoft.EntityFrameworkCore.InMemory": "1.0.0"
C#
0 vote365 views1 answer
C# treeview keep selected node highlight
C#
5 votes393 views1 answer
Load prefab in script unity
C#
1 vote347 views1 answer
C# i lose 0 when converting int to string
C#
35 votes350 views4 answers
String from byte array c#
C#
3 votes342 views1 answer
C# save pdf stream to file
C#
7 votes360 views6 answers
C# empty array
C#
10 votes397 views3 answers
Unity C# instantiate prefab
C#Unity
3 votes329 views1 answer
Unity desactivate collider
C#