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 vote131 views1 answer
Center an image horizontally and vertically
C#
4 votes124 views4 answers
How to use distinct in linq query in c#
C#
0 vote119 views1 answer
C# get all the column names from datagridview
C#
6 votes118 views1 answer
Unity how to see what scen you are in
C#
0 vote124 views2 answers
Linear search algorithm c#
C#
0 vote134 views1 answer
Datareader get field names
C#
3 votes86 views1 answer
Aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
C#
0 vote142 views1 answer
Aquarette
C#
3 votes134 views1 answer
Create a directory if it doesnt exist c#
C#
0 vote146 views2 answers
C# convert random numbers in textBox to currency
C#