I do it myself, but in .NET you don't have to open and close the
connection manually when using the fill method. The fill methos
does it for you.
If you need an accurate date the workstation won't do so getting it
from the database would be better, but the loop isn't that great (I did
it myself once, but I was still learning :-)).
In Oracle I used the TO_CHAR method so you could give it back in a nice
format (if you only have to display why use a DateTime :-))
A DataReader or a ExecuteScalar would be better, but he could have used a DataSet out of habit.
He seems to be missing a dal component. He creates a new Command,
Adapter and DataSet to get a date? A lot of overkill if you ask
me, what about O-O and incapsulation? Incapsulate your Adapter,
connections, ... and re-use it...
V
V11
@V11
0
Reputation
1
Posts
38
Profile views
0
Followers
0
Following
Best posts made by V11
This user hasn't posted anything yet.
Latest posts made by V11
-
RE: Trouble Finding a Date