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

6 votes97 views2 answers
C# float to string with 2 decimals
C#
1 vote101 views1 answer
Why vue cli do not refresh auto in local host
C#
1 vote100 views1 answer
C# list remove duplicate items
C#
0 vote94 views1 answer
C# windows forms how to get controls in gropu box
C#
7 votes106 views2 answers
C# how to check string is number
C#
0 vote116 views1 answer
Unity color by rgb
C#
0 vote96 views1 answer
Unity set mouse
C#
0 vote139 views1 answer
Vb.net wait 1 second
C#
8 votes103 views2 answers
.net core identity get user id
C#
0 vote124 views2 answers
Change object material unity
C#Unity