Not sure which category to put this question in, so I will put it in here.
Just to give you an idea of the layout of my solution, I have the main project, along with 2 class libraries, BLL and DAL. (Business Logic Layer and Data Access Layer)
The BLL refers to the DAL and the main project refers to the BLL.
I had a test website and the code worked fine, but the same code will not work on the real project. The only difference is that in the test project, the code was on an aspx code behind, whereas in the real project, it is an ascx code behind (Web User Control )
The code is:
Dim connectionString As String = ConfigurationManager.ConnectionStrings("ASPNETDBConnectionString").ConnectionString
Dim recordEntry As New UserRecord(connectionString)
recordEntry.UserName = "TestName"
recordEntry.BMI = bMI
recordEntry.BMR = bMR
recordEntry.FTM = fTM
recordEntry.TDEE = tDEE
recordEntry.TodayDate = dateForToday
recordEntry.InsertRecord()
Dim connectionString As String = ConfigurationManager.ConnectionStrings("ASPNETDBConnectionString").ConnectionString
View Complete Post