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

7 votes334 views3 answers
How to change scenes on collision unity
C#Unity
0 vote307 views1 answer
C# how to make object rotate forever
C#
0 vote306 views2 answers
Difference between eager and lazy loading entityframwork
C#
0 vote302 views1 answer
EventSource Web API C#
C#
0 vote305 views1 answer
Rename join table ef core
C#
1 vote285 views1 answer
Unity how to check object position
C#
0 vote290 views1 answer
Itext7 pdfwriter outputstream c#
C#
28 votes299 views3 answers
C# system.io check if file exists
C#
0 vote275 views1 answer
Getstring
C#
2 votes277 views2 answers
C# clear all textboxes
C#