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 vote294 views1 answer
Decrease image size C#
C#
0 vote316 views1 answer
Wpf how to focus on element
C#
18 votes328 views4 answers
C# iterate enum
C#
10 votes290 views3 answers
C# input
C#
0 vote308 views1 answer
Dapper Get List
C#
10 votes303 views2 answers
Last two characters of string c#
C#
30 votes306 views3 answers
C# wait seconds
C#
0 vote297 views1 answer
How can datetimepicker accept hour as well
C#
18 votes330 views2 answers
Unity remove all child
C#Unity
0 vote238 views1 answer
How to set an expiry date on a program
C#