Link to home
Start Free TrialLog in
Avatar of mathieu_cupryk
mathieu_cuprykFlag for Canada

asked on

GetStoredProcCommand not declared

cmd =GetStoredProcCommand("PARAM_TWD.dbo.usp_GetDivisions")


C:\SourceControl_mcupryk\InHouseDev\APPS\MKT0003 - CustomerList\src\CustomerList\App_Code\BOL\Division.vb(260,0): error BC30456: 'GetStoredProcCommand' is not a member of 'CustomerList.DAL.DBAccess'.

Error      8      Name 'GetStoredProcCommand' is not declared.      C:\SourceControl_mcupryk\InHouseDev\APPS\MKT0003 - CustomerList\src\CustomerList\App_Code\BOL\Division.vb      260      23      http://localhost/CustomerList/


ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mathieu_cupryk

ASKER



Error      7      Expression is not a method.      C:\SourceControl_mcupryk\InHouseDev\APPS\MKT0003 - CustomerList\src\CustomerList\App_Code\BOL\Division.vb      261      17      http://localhost/CustomerList/


Error      9      Name 'db' is not declared.      C:\SourceControl_mcupryk\InHouseDev\APPS\MKT0003 - CustomerList\src\CustomerList\App_Code\BOL\Division.vb      262      23      http://localhost/CustomerList/


 Dim Database As DAL.DBAccess = New DAL.DBAccess
 'We get the divisions
                Database(db = DatabaseFactory.CreateDatabase())
                cmd = db.GetStoredProcCommand("PARAM_TWD.dbo.usp_GetDivisions")

                'Temporarilly put the results in a dataset so we can check for valid data
                tmpds = db.ExecuteDataSet(cmd)
         
Glad I could help.
as you did not post which programming language you worked with, I wrongly assumed C# and not vb.net, although I should have seen that from the error message :-(