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 vote147 views1 answer
System.InvalidOperationException: 'Transaction has already been rolled back or is not pending'
C#
7 votes140 views6 answers
C# empty array
C#
-1 vote178 views1 answer
How to add a componet to a gameobject throgh code unity
C#Unity
11 votes141 views3 answers
Enum get all values C#
C#
0 vote147 views2 answers
Formula calculating distance coordinates latitude longitude c#
C#
29 votes127 views3 answers
Unity c# delay function
C#
1 vote138 views1 answer
Audiomixer get float
C#
0 vote150 views1 answer
In model add to give drop down message
C#
0 vote163 views1 answer
Get time part from datetime as timestamp in c#
C#
3 votes198 views1 answer
How to make an object invisible unity
C#Unity