View Full Version : Displaying MS SQL database rows on an ASP.NET C# page

03-04-2011, 04:32 PM
I'm wondering how I can use ASP.NET/C# to read and display a table (result of SELECT statement) in my MS SQL database? I have experience with C# and SQL as well as PHP so I understand the basic idea, however I don't know what classes to use.

My DB connection settings are stored in connections.config so I have to be able to reference those settings (and not hardcode them). How would I approach this?

Also, I'm confused by the following code:

DataTable dt = GenericDataAccess.ExecuteSelectCommand(sql, "ConnectionNameFromConnectionsConfigFile");
What is GenericDataAccess and how do I use it?