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

8 votes129 views3 answers
Save byte array to file c#
C#
0 vote162 views1 answer
How to prevent or terminate time's up screen from windows family safety windows service c#
C#
28 votes143 views2 answers
Unity check if gameobject is active
C#
3 votes131 views2 answers
C# bytes to image
C#
3 votes142 views1 answer
How to move your character in unity 2d game
C#
0 vote130 views1 answer
Firepower 4125 License update
C#
0 vote96 views1 answer
Startup c# class winform
C#
0 vote139 views1 answer
C# consuming post rest service
C#
0 vote144 views1 answer
Converting alpha1 into int unity
C#
3 votes164 views1 answer
Unity transformer double en float
C#