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

57 votes326 views6 answers
Unity find objects with tag
C#
1 vote183 views1 answer
How to disable click listener in android
C#
7 votes207 views1 answer
For loop unity
C#
1 vote176 views1 answer
It's gonna be me lyrics
C#
0 vote183 views1 answer
Count Rows of table using Linq
C#
0 vote178 views1 answer
Unity callback
C#
0 vote192 views1 answer
Unity camera.main.screentoworldpoint(input.mouseposition) not working
C#
1 vote190 views2 answers
C# check if element is last in list
C#
1 vote192 views2 answers
Dynamic arrays in c#
C#
2 votes188 views2 answers
Missingpluginexception (missingpluginexception(no implementation found for method firebase#initializecore on channel plugins.flutter.io/firebase_core)
C#