Monday, March 19, 2012

calling a stored procedure, returns empty

hi, im new to this site so i don't know if i'm posting in the correct forum. anyway, this is my code:
--
Dim dbMac As DBLibrary = Nothing

dbMac = New DBLibrary(General.GetMACConnectionString)
dbMac.OpenConnection("SPR_STAFFMAIN_GETEMPLOYEERECORDS")
dbMac.CreateParameter("@.USERENTITYID", GetUserEntityID(), Data.SqlDbType.Int)
drpEmpNumbers.DataSource = dbMac.GetDataView("StaffMaintenance")
gridStaffMaintenance.DataSource = dbMac.GetDataView("StaffMaintenance")
gridStaffMaintenance.DataBind()
--
DBLibrary is a class that opens a connection to the SQL server. i'm getting an empty grid even though the stored procedure returns a row when i test it in the analyzer. is there to debug or test this code? thanks!

Have you determined for sure if GetUserEntityID() is returning the value you are expecting?

No comments:

Post a Comment