I have a SQL Server stored proc that returns a single row of data with 28 columns. I would like to use that data to fill up an Employee object I created. I pass an EmployeeID to the stored proc and it returns all values for that employee.
I attempted to fill a DataTable but I couldn't figure out how to access the row values.
Is there a best practice that is recommended for this? Seems like it's very common but I've never done it before, so any help would be greatly appreciated.