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

2 votes328 views5 answers
Enum c#
C#
1 vote306 views1 answer
Disable button in android studio
C#
19 votes394 views2 answers
Unity RemoveComponent
C#Unity
0 vote327 views1 answer
Multidimensional meaning
C#
-1 vote325 views1 answer
How to update model when database change in entity framework core
C#
1 vote323 views1 answer
The CodeDom provider type "Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" could not be located.
C#
0 vote354 views1 answer
More than one migrations configuration type was found in the assembly 'EFCodeFirst'. Specify the name of the one to use
C#
0 vote337 views1 answer
C# creating a hash table linked list
C#
0 vote329 views1 answer
C# Get type with namespace
C#
0 vote342 views1 answer
Wpf get screen size
C#