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

14 votes206 views3 answers
String to int c# unity
C#
0 vote218 views1 answer
C# method summary new line
C#
1 vote194 views1 answer
Unity agent bake not derecting mesh
C#Unity
-2 votes211 views1 answer
Ref in f#
C#
2 votes188 views1 answer
Write string multiple times c#
C#
0 vote212 views3 answers
.net return manual status code
C#
0 vote207 views1 answer
Uwp roaming data sample
C#
0 vote204 views1 answer
How to resize a panel unity
C#
0 vote184 views1 answer
Linq query to fetch parent child data from same table in c#
C#
24 votes203 views7 answers
Qwertyuiopasdfghjklzxcvbnm
C#