I've got trivial problem and have no time to re-read manuals. I need to construct a function in SQL2005 which selects from DB and returns datatable. Something like this:
create function GetAllStudents() returns Table as begin ( select StudentID,StudentName,StudentFamilyName,Birthday,HisClass from Students ) return DataTable
I need it to bind then to bind to DataView Control on my ASP.Net 2.0 page.
Any help and advice?