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 vote186 views1 answer
Button next for picturebox c#
C#
0 vote191 views1 answer
C# double without exponential notation
C#
0 vote194 views1 answer
C# substring until character single
C#
0 vote228 views1 answer
Csharp attributes as generics constraints
C#
37 votes183 views2 answers
C# string split with string
C#
1 vote152 views2 answers
C# assigning image location
C#
0 vote182 views3 answers
Netmath hack
C#
0 vote183 views1 answer
C# network traffic
C#
20 votes324 views2 answers
Fill dictionary c#
C#
5 votes194 views2 answers
C# get files of type in directory
C#