Monday, May 21, 2012

ASP.NET MVC 3 (w/ C#): Student Information System


This is a simple Student Information System I created using ASP.NET MVC 3 and C#.

You can download the zip file here.


Because I'm new to ASP.NET MVC, I will list some interesting things for beginners that I used in this project:
  1. Adding attributes to entity classes generated by Entity Framework
  2. Creating AJAX search form
  3. Using Html.DropDownListFor() helper
  4. Using jQuery UI Datepicker

Saturday, May 19, 2012

Simple Student Information System Using .NET WinForms & DataSet



This is a simple Student Information System I created using the .NET Framework
 - Windows Forms for the GUI and DataSet for data access.
 - .NET language used: VB.NET

You can download this on Google Docs

You don't need to install the database used in this project because the Visual Studio Solution is configured to copy the database in the "Debug" folder and the application is configured to look for the database in the directory where the executable is located.

Username: admin
Password: admin

Happy coding!!!

Tuesday, May 15, 2012

ASP.NET MVC ERROR: Store update, insert, or delete statement affected an unexpected number of rows (0).

Server Error in '/' Application. 

Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. Refresh ObjectStateManager entries.


Possible Problem:
You placed a ReadOnlyAttribute in you entity key's metadata, which causes its value to become zero

     [DisplayName("Student ID")]
     [ReadOnly(true)]
     public int StudentID { get; set; }


Solution:
Remove the ReadOnlyAttribute

     [DisplayName("Student ID")]
     public int StudentID { get; set; }


For other possible causes for this problem and possible solutions, please refer to this link http://stackoverflow.com/questions/1836173/entity-framework-store-update-insert-or-delete-statement-affected-an-unexpec



  
Free Lessons for Chruch Pianists:
Free lessons, tips and downloads for church pianists

DVD Courses (Reharmonization, Play by Ear!, Arranging, Accompanying, Theory for Church Pianists, etc.):
Over 30 hours of DVD instruction for church pianists
 


Visit Vitabase for Quality Health Supplements