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 vote118 views1 answer
Il c#
C#
35 votes116 views4 answers
C# list length
C#
0 vote116 views1 answer
Unity change fixed timestep in code
C#
2 votes112 views2 answers
Validate data exist in database lara vel
C#
-1 vote112 views1 answer
C# list object to json
C#
0 vote108 views1 answer
C# check if object can be cast to type
C#
10 votes143 views6 answers
Unity mouse click
C#Unity
1 vote110 views3 answers
C# string to hex
C#
1 vote115 views1 answer
Urlreferrer in asp.net core
C#
0 vote119 views1 answer
How do you search for how many times a character appears in user input on c sharp
C#