ChiSmile wrote:
dAdapt1.Fill(dSet1, "Patient Profile")
ChiSmile wrote:
dt = dSet1.Tables("Patient_Profile")
Do you see the problem there? Here's a hint - you've got a magic string issue - when you use a string in one place to name something, you've got to use the same name whenever you refer to it.
Now, here's a piece of advice - learn how to debug. If you had set a breakpoint and stepped over your code (pausing to explore the values as you were debugging), you'd have found this issue straightaway.