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

33 votes174 views2 answers
How to parse a string to an integer c#
C#
1 vote199 views1 answer
.net core check if user is logged in
C#
0 vote234 views4 answers
How to turn a string in a char list c#
C#
1 vote218 views1 answer
Rotation facing mouse unity
C#Unity
0 vote127 views1 answer
C# razor add disabled to button if
C#
0 vote172 views1 answer
C# textbox kodu
C#
0 vote180 views1 answer
Non null array length
C#
0 vote166 views1 answer
C# random sleep
C#
1 vote163 views1 answer
Urlreferrer in asp.net core
C#
10 votes206 views2 answers
C# string enum
C#