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 vote162 views1 answer
Is odd c# stackoverflow
C#
1 vote177 views1 answer
Group by ef core
C#
0 vote157 views2 answers
C# if combobox selected index
C#
0 vote160 views4 answers
What are delegates and how to use them c#
C#
0 vote165 views1 answer
C# how to get connection string from app config
C#
0 vote206 views1 answer
C# sprint key
C#
2 votes167 views2 answers
C# filter list
C#
4 votes163 views1 answer
C# change label forecolor code
C#
0 vote118 views1 answer
Partial view with model in multiple views
C#
1 vote222 views1 answer
Unity add addressables
C#Unity