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

3 votes275 views1 answer
C# dictionary first
C#
1 vote279 views1 answer
C# find element by condition
C#
0 vote267 views1 answer
Prime number Upto n
C#
7 votes294 views3 answers
How to change scenes on collision unity
C#
0 vote276 views1 answer
C# online code editor
C#
3 votes308 views2 answers
C# is not marked as serializable
C#
0 vote279 views1 answer
Change textbox text color c#
C#
46 votes424 views6 answers
Instantiate prefab unity
C#Unity
0 vote327 views1 answer
Data types of document in asp dot net frame work
C#
2 votes278 views2 answers
Save file tar.gz c#
C#