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 vote318 views1 answer
Unity invisible cube
C#
4 votes291 views1 answer
How to make a method wait in unity
C#
1 vote393 views1 answer
C# unity detect any keyboard input but not mouse input
C#Unity
1 vote325 views1 answer
Float and int need help
C#
0 vote339 views1 answer
WixSharp-FirewallException
C#
0 vote309 views2 answers
Write N lines with M numbers each that describe the layout of the second layer in the way shown above
C#
0 vote323 views1 answer
LAST ELEMT OF ARRAY
C#
0 vote314 views7 answers
Python to php converter online
C#
1 vote387 views1 answer
Reference to another script unity
C#Unity
0 vote319 views1 answer
Mvc get base url
C#