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 vote149 views1 answer
C# press ctrl and alt
C#
36 votes140 views5 answers
Unity key pressed
C#
4 votes241 views1 answer
Unity new vector3
C#Unity
0 vote187 views1 answer
Unity get velocity at point
C#Unity
0 vote203 views1 answer
Mysql restore backup from multiple files
C#
0 vote184 views1 answer
What is a model in C#
C#
0 vote139 views1 answer
Write last line txt file c#
C#
11 votes148 views3 answers
How to remove all whitespace from a string in c#
C#
0 vote129 views1 answer
Connection string of bulk insert with csv in c#
C#
6 votes128 views2 answers
Index list c#
C#