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 vote135 views1 answer
Length of array c# unity
C#Unity
0 vote116 views1 answer
Unity color mix
C#
1 vote122 views2 answers
Newtonsoft json conditionally ignore property
C#
19 votes163 views2 answers
Unity RemoveComponent
C#Unity
0 vote114 views1 answer
C# how to start an application and detect if started
C#
4 votes99 views1 answer
Unity get animator
C#Unity
0 vote107 views1 answer
C# get or create firewall inbound rule ports
C#
1 vote107 views1 answer
How to pause in unity for debug
C#
0 vote110 views1 answer
C# foreach char in string
C#
35 votes118 views2 answers
How to delete from a list c#
C#