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

2 votes202 views2 answers
How to deactivate objects through scripts in unity
C#Unity
0 vote159 views1 answer
Calculator using single readline c#
C#
0 vote161 views1 answer
List.SkipWhile in c#
C#
1 vote169 views1 answer
Request.ServerVariables["HTTP_X_FORWARDED_FOR"] get only one ipaddress
C#
0 vote179 views1 answer
Timespan to integer c#
C#
2 votes200 views2 answers
Unity how get random color to material
C#Unity
0 vote163 views1 answer
SAVE FLOAT UNITY
C#
1 vote183 views1 answer
Unity how to move an object to another object
C#
4 votes155 views3 answers
Email regex c#
C#
1 vote216 views1 answer
Unity how to end a game with esc
C#Unity