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

17 votes221 views4 answers
C# remove spaces from string
C#
0 vote189 views1 answer
C# func vs action
C#
2 votes240 views2 answers
Convert DateTime Format 04-08-2021 00:00:00 to string '08/04/2021' in C# c#
C#
0 vote213 views1 answer
Process run teamviewer address parametr c#
C#
0 vote228 views1 answer
Fix autofill issue asp.net mvc
C#
15 votes212 views2 answers
Replace space with underscore in c#
C#
0 vote206 views1 answer
String is int f#
C#
1 vote287 views1 answer
Generate random name c#
C#
0 vote280 views1 answer
Visual studio pre build event not working
C#
0 vote204 views1 answer
Visual studio console clear
C#