Unable to Edit or Delete Category in TimeTracker

Last post 06-25-2009 10:56 PM by chetan.sarode. 23 replies.

Sort Posts:

  • Unable to Edit or Delete Category in TimeTracker

    09-27-2007, 12:28 PM
    • Member
      4 point Member
    • avhzn
    • Member since 09-27-2007, 3:59 PM
    • Posts 9
    Hello there, everythings works fine, till I try to update or delete a category record. I receive the message:
    Server Error in '/ProjectManagement' Application.
    --------------------------------------------------------------------------------

    ObjectDataSource 'CategoryData' could not find a non-generic method 'UpdateCategory' that has parameters: Abbreviation, EstimateDuration, Name, Id.

    And for Deleting Category:
    ObjectDataSource 'CategoryData' could not find a non-generic method 'DeleteCategory' that has parameters: Id.

    The Add method is no problem.
    I have only one Admin user and I have all 3 roles enabled.

    I hope somebody knows the answer.
    Thanks in advance.
    Arjan

  • Re: Unable to Edit or Delete Category in TimeTracker

    09-27-2007, 11:45 PM

    This seems You do not have 'UpdateCategory' and 'DeleteCategory' methos in your application.

    Check your application once again. Try to check ObjectDataSource 'CategoryData'  and find in that whether these

    two method are available in that or not

    Let me know if this helpful to you

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: Unable to Edit or Delete Category in TimeTracker

    09-28-2007, 5:44 PM
    • Member
      4 point Member
    • avhzn
    • Member since 09-27-2007, 3:59 PM
    • Posts 9

    Hello, thanks for the fast reply. I built again the website in a new location and now it works. Only I discovered a new problem. When I start the application the 2nd time then it doesn't recognize my login credentials anymore.

    I did:

    - Started the application the first time and stopped. Now it made files in the App_data folder
    - Via Visual Studio I made a new admin user and gave the 3 roles to it.
    - Started the application via CTRL+F5 and it worked fine
    - Closed the webpage and started again via VS2005 and then it doesn't recognize me anymore. Also when I type directly the url in the webbrowser. When I look in de MDF file I see one admin user.

    - Create user link gives me also an error:

    Failed to update database "C:\INETPUB\WWWROOT\TIMETRACKER1\APP_DATA\TIMETRACKER.MDF" because the database is read-only.

    2nd question. Why I have to make an application from the Virtual folder in IIS when I don't start the website via Visual Studio? How VS does this when I see the same url?

    I hope you can still help me.
    I think I make some mistakes, but I don't know what.

    Thanks in advance.

    AJ.

     

  • Re: Unable to Edit or Delete Category in TimeTracker

    09-30-2007, 11:46 PM

    Check in web.config for connectionString, configure it according to your server name, password etc.

    In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..

    You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt

    aspnet_regsql, it will open one window, where you  have to configure DB.

    Hope it will help you, let me know.

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: Unable to Edit or Delete Category in TimeTracker

    10-01-2007, 4:03 AM
    • Member
      4 point Member
    • avhzn
    • Member since 09-27-2007, 3:59 PM
    • Posts 9

    Hello Chetan, thanks for your reply. I appreciate it, but unfortunately I don't understand what you mean.

    I found the aspnet_reqsql util under the folder: C:\Windows\Microsoft.NET\...etc. but when I open then I see my SQL server, but not the database. This is because it is located under the folder: TimeTracker1\App_data.
    Where can I find the VS command prompt? I have VS2005 Pro edition.

    But in the web.config it points to the MDF file under the App_data folder, so that is not enough then? I have to attach this MDF to my SQL server Express first via the SQL studio manager? And then change the connection string? I thought that it could work like now in the App_data. Please help me.
    This 2nd key 'LocalSqlServer' is causing the problem I think?

    Web.config
    <connectionStrings>

    <add name="aspnet_staterKits_TimeTracker" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />

    <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />

    </connectionStrings>

    Thanks in advance.

    AJ.

     

  • Re: Unable to Edit or Delete Category in TimeTracker

    10-02-2007, 11:45 PM

    Failed to update database "C:\INETPUB\WWWROOT\TIMETRACKER1\APP_DATA\TIMETRACKER.MDF" because the database is read-only means

    Check the permissions for App_Data folder it has not proper permission that why it giving the errror

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: Unable to Edit or Delete Category in TimeTracker

    10-03-2007, 9:49 AM
    • Member
      4 point Member
    • avhzn
    • Member since 09-27-2007, 3:59 PM
    • Posts 9

    Thank you for your reply.

    I have IIS5.1 under Windows XP and when I check the Directory Security Tab then I see the IUSR_PC under the Anonymous Access. Do I have to change this to ASPNET user? (=simular to Network Services in IIS6 and higher) and do I have to create an application of this App_Data folder in IIS?

    I have full permissions for this folder. Read and Write are checked in IIS under the 'Directory' tab form.

    Thanks in advance.

    AJ.

  • Re: Unable to Edit or Delete Category in TimeTracker

    10-03-2007, 11:31 PM

    Just right click on App_Data folder and on security tab

    Check which users are aloowed to access this folder add ASPNET and Network Services user their

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: Unable to Edit or Delete Category in TimeTracker

    10-04-2007, 5:07 AM
    • Member
      4 point Member
    • avhzn
    • Member since 09-27-2007, 3:59 PM
    • Posts 9

    Hello, with the security I managed and I can start and login now via IE and via Visual Studio CTRL+F5 methods. I had to do set this security via Windows Explorer and not in IIS... By adding the ASPNET and Network Services it worked.

    But now I'm only back to my 1st problem. The update and delete category. I still receive the message

    ObjectDataSource 'CategoryData' could not find a non-generic method 'UpdateCategory' that has parameters: Abbreviation, originalId, EstimateDuration, Name, ProjectId.

    When I configure in VS2005 the DataSource 'CategoryData' -> BusinessObject: Category: I see that the Update and Delete DropDown lists are empty. I can choose:

    UpdateCategory(String Abbreviation, Int32 originalId, Decimal EstimateDuration, String Name), returns Boolean

    as the UpdateMethod. But in this I still miss the ProjectID and I still receive the message when I try to update or delete. I have to built these methods? But why are those methods missing?

    Thanks.

    AJ.

     

  • Re: Unable to Edit or Delete Category in TimeTracker

    10-04-2007, 11:42 PM

    Try to reinstall TTS again and configure it properly

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: Unable to Edit or Delete Category in TimeTracker

    10-05-2007, 7:48 AM
    • Member
      4 point Member
    • avhzn
    • Member since 09-27-2007, 3:59 PM
    • Posts 9

    When I read the help file, it should work already with CTRL+F5 in Visual Studio. And that's a bit true, because it works fine till I want to delete or update a category. When I check the datasource then the Update and Delete drop down list is already empty in the new unmodified project.

    I don't understand it anymore why it worked for a moment in VS2005 and then not anymore. And now with a new project it's again the same.

    Can you otherwise exactly describe what you did before hitting CTRL+F5 the first time in the project?
    Thanks in advance.

     

  • Re: Unable to Edit or Delete Category in TimeTracker

    10-07-2007, 11:33 PM

    Perssing CTRL+F5 means you are running application without debug mode

    Have you re-install the TTS and checked properly

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: Unable to Edit or Delete Category in TimeTracker

    10-08-2007, 4:15 AM
    • Member
      4 point Member
    • avhzn
    • Member since 09-27-2007, 3:59 PM
    • Posts 9

    Hello Chetan, Yes I re-installed the TTS a few times and I still have the same error during Edit or Deleting a Category. Adding is no problem. When I check/configure the DataSource then the dropdownlist shows many methods. The Add Method is connected to his method, but the Delete and Edit are not. When I choose the Update and Delete method from the DDlist then it resets my datagrid. I can manual add the linkbuttons again. But I still have the same problem after re-building the website.

    When I start in debug mode, then I see really no mistakes. 'Build succeeded and 0 errors'.

    Maybe you all guys run the C# version, I have the VB version. The only thing what I cannot understand is that, when 1300 people saw this thread already and nobody, exept you Chetan, tries to help me, that everybody has a perfect application without mistakes!? When it's already not good 'out of box', then I think that the problem doesn't occur only on my pc!

    But can you please describe what you see when you start this app for the first time? And what you did, or it worked ok for you after hitting only the CTRL+F5?

    Thanks again for your patient.

    Ps. are you the programmer behind this code? Or the developer doesn't answer in this forum... ;-)

    Grtz.

    AJ

  • Re: Unable to Edit or Delete Category in TimeTracker

    10-09-2007, 11:34 PM

    I have already install TTS in my m/c and it wroks well.

    As you said you are using VB version, my suggestion is try to install C# version then see what happened

    Chetan Sarode
    Software Engineer,
    Approva Systems Pvt Ltd,
    Pune, India.
  • Re: Unable to Edit or Delete Category in TimeTracker

    10-22-2007, 9:06 AM
    • Member
      16 point Member
    • row118
    • Member since 07-02-2007, 7:05 AM
    • Posts 34
    I get the same error. 

    The "CategoryData" datasource has Update and Delete Parameter commands. That datasource is connected to "ListAllCategories" GridView. I haven't used .NET 2.0 Gridview to be able to determine whether the Update Command has the correct parameter name  that are needed. The business logic method/function looks as if it being called also. Project is not a priority for me to do the research but would like to know what you find.

    The OBject datasource does in fact have 4 params but I'm not sure where the parameters are actually defined for the DB call.
Page 1 of 2 (24 items) 1 2 Next >