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

3 votes259 views4 answers
How to make infinite loop in c#
C#
0 vote297 views1 answer
Jaro–winkler distance c#
C#
9 votes248 views1 answer
You have the following c# code. stringbuilder sb = new stringbuilder(really long string);
C#
0 vote205 views2 answers
As keyword c#
C#
2 votes253 views1 answer
Newtonsoft.Json.JsonSerializationException: 'Self referencing loop detected for property
C#
5 votes311 views1 answer
Unity create scriptableobject asset
C#Unity
0 vote302 views1 answer
Unity stop all audio
C#Unity
0 vote267 views1 answer
Get access to all controls with a specific tag in C#
C#
0 vote237 views1 answer
Entityframework command to build model from database
C#
0 vote254 views1 answer
Opération inter-threads non valide
C#