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 vote180 views1 answer
Git find commits by file path
C#
10 votes171 views2 answers
How to set a color of text in unity 2020 script
C#Unity
4 votes158 views2 answers
C# console beep sounds
C#
1 vote128 views1 answer
Blank background for button wpf
C#
3 votes153 views1 answer
C# loop array back
C#
12 votes181 views1 answer
Get current computer ipv4 C#
C#
4 votes86 views1 answer
C# get month name
C#
7 votes157 views2 answers
Unity how to create a prefab
C#Unity
0 vote137 views1 answer
Unity customize hierarchy window
C#
0 vote133 views1 answer
Test for even Number
C#