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

8 votes139 views3 answers
C# check if string is directory
C#
0 vote137 views1 answer
Unity iap
C#
1 vote145 views3 answers
C# object is in object list
C#
51 votes166 views5 answers
Array declaration in c#
C#
5 votes145 views1 answer
C# or command
C#
0 vote149 views1 answer
C# webbrowser upload file
C#
1 vote152 views1 answer
C# add time to datetime
C#
0 vote142 views1 answer
How to set a tag in asp net razor view stackoverflow
C#
0 vote152 views1 answer
Asp.net store list in web.config
C#
0 vote133 views1 answer
How to execute a code only once in update function in unity (cursed method)
C#