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 vote352 views1 answer
C# devexpress get foucused dataRow of child gridView
C#
2 votes293 views1 answer
Rigidbody2d freeze position
C#
0 vote333 views1 answer
The terminal process failed to launch: Path to shell executable "dotnet" is not a file or a symlink.
C#
2 votes264 views1 answer
How to add reference to rigidbody 2d
C#
1 vote351 views1 answer
Unity2d click on gameobject
C#Unity
0 vote297 views1 answer
C# pull request
C#
0 vote372 views1 answer
Reflection assemblies gettypes
C#
0 vote315 views2 answers
Get sha1 of file c#
C#
1 vote347 views1 answer
How To Copy a text C# unity
C#Unity
4 votes320 views2 answers
Byte array to hex c#
C#