The real trick is to use the IBM.Data.DB2 assembly to get a decent DB2
client - instead of having to marshal through ODBC and it's obtuse
stored proc syntax. You still need to install the DB2 Runtime client[1],
but referencing IBM.Data.DB2 will then get your IBM.Data.DB2Command,
DB2Parameter, etc. - just like a real ADO.NET provider. From there, it's
pretty simple and similar to any other ADO.NET call.

We have a (VB.NET) class that wraps up 7 or 8 of the stored procs that
we use from the Directory (including ObtainPersonLoaf) - but it also
includes some associated enums, exception types, etc. Not really an easy
copy/paste. If you'd like the whole bit, though, ping me off list.

--MB

-----Original Message-----
From: UF Web types [mailto:[log in to unmask]] On Behalf Of
Jeffrey Schmidt
Sent: Tuesday, April 07, 2009 3:42 PM
To: [log in to unmask]
Subject: ASP .NET Example For OBTAIN PERSON LOAF

Good Afternoon:

 

Currently we are trying to rework our classic ASP programs into ASP .NET
C# applications. One of the areas that I am trying to build is a
GatorLink class that manages all functions for student information (such
as the OBTAIN PERSON LOAF operations, etc.).

 

I checked the IT website and the only example that they have is for
classic ASP
(http://www.it.ufl.edu/projects/directory/programming/ex-asp.shtml).
Does anyone have an example on how to do these type of operations using
ASP.NET (it doesn't have to be C#, I can convert that, but at least have
an .NET example).

 

Thanks to all!

 

Jeffrey Schmidt

Application Developer

J. Wayne Reitz Union / Student Government

 

Phone: 352-273-0318

[log in to unmask]

 

"Imagination is more important than knowledge." - Albert Einstein