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

1 vote246 views1 answer
Unity check if other object is colliding
C#Unity
5 votes232 views2 answers
C# download file
C#
0 vote212 views1 answer
Csharp test for null
C#
1 vote231 views1 answer
How to display an image url in c# picturebox
C#
1 vote258 views1 answer
C# datagridview search filter
C#
1 vote244 views1 answer
C# separate string by a new line
C#
0 vote241 views1 answer
C# delegate
C#
0 vote225 views1 answer
C# transparent label
C#
0 vote218 views1 answer
If checkbox checked in c#
C#
0 vote209 views1 answer
How to clip out ui element if they are not inside an element unity
C#Unity