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 vote323 views1 answer
How to system func bool unity
C#
0 vote305 views3 answers
Query string not ending with with vowels
C#
1 vote309 views1 answer
Bower azure repository tag
C#
0 vote310 views1 answer
How to draw a dot in c#
C#
3 votes336 views3 answers
Loop in c#
C#
13 votes317 views3 answers
C# list get last element
C#
1 vote306 views1 answer
Unity knowing when 0 input is pressed
C#
0 vote339 views1 answer
Max value data annotation c#
C#
0 vote291 views1 answer
Check property type of collection c#
C#
0 vote315 views1 answer
Find gameobject by name in root
C#