Saving Changes Is Not Permitted On SQL Server 2008 Management Studio.

Saving Changes Is Not Permitted On SQL Server 2008 Management Studio. 

Saving changes is not permitted occurs when doing alter table (table structure is changed):

Change data type on existing columns

Or change allow nulls on existing columns

 

To allow you to save changes after you alter table, do disable prevent changes:

 

1.Open Microsoft SQL Server Management Studio 2008

2.Click Tools, then click Options

3.Click Designers

4.Uncheck prevent saving changes that require table re-creation

5.Click OK

6. Try to alter your table

OOPS Object Oriented Programming FAQ

OOPS  -  Object Oriented Programming  FAQ

Four main principles of OOPS
1. Encapsulation
2. Inheritance
3. Polymorphism
4. Abstraction

1. Encapsulation
- Encapsulation is the process of hiding the irrelevant information and showing only relevant information to                  the user.
- Encapsulation is the process of wrapping up of data and member in a class.

Example:
- Only specific method or properties can access the private member of class.
- Data Hiding through the private class access specifier.

Uses:
-Increase the maintainability of the code by showing only relevant information to the User.


2. Abstraction
- Abstraction is the process of hiding the details and exposing only the essential feature of particular concept or object.

Real time example:
Refrigerator:
The process of showing the general information related to the refrigerator is called Abstraction and hiding the complex information from the user is Encapsulation.


3.Inheritance
- Inheritance is the process through which a child class obtain the feature defined its parent class.
- Used for reuse of code and eliminate redundant code.

Types:
- Single, Multilevel, Multiple and Hierarchical.

4.Polymorphism
- One Interface multiple methods
- With the help of Polymorphism we can use one procedure in many ways based on our requirement.

Method Overloading:
-Method according to number and types of parameter.

Operator Overloading:
-Change the functionality of operator.

Runtime Polymorphism
Overriding
-Overriding is the feature that allows derived class to provide a specific implementation of a method that is already provided its base class.

C# Mock Interview - Video Tutorial

C# Mock Interview  - Video Tutorial

MVC Video Tutorial Collection

MVC Video Tutorial Collection

Pros and Cons of  ASP.NET MVC

MVC Beginner to Expert

Setting the Default Page or Route in MVC application

Setting the Default Page or Route in MVC application


For convenience, we are going to tell MVC that requests to the / URL for our application should be

directed to the Index action method of the Product controller. To do this, open the Global.asax file and 

find the RegisterRoutes method. In this method, there is a call to routes.MapRoute. Change the value 

assigned to the controller property from Default to Product,

Setting the Controller for the Default Route
routes.MapRoute(
"Default", // Route name
"{controller}/{action}/{id}", // URL with parameters
new { controller = "Product", action = "Index", id = UrlParameter.Optional }
)

Assign System.DBNull.Value in SqlParam value instead of 0 using Ternary operator

Assign System.DBNull.Value in SqlParam value instead of 0 using Ternary operator

  int i = 0;
           
  SqlParameter[] SqlParam = null;
  SqlParam = new SqlParameter[1];
  SqlCommand SqlCmd = new SqlCommand();

 SqlParam[0] = new SqlParameter("@SectionCode", SqlDbType.VarChar, 50);
 SqlParam[0].Value = i == 0 ? (object)System.DBNull.Value : i;

Javascript Confirm button ok and cancel

Javascript Confirm button ok and cancel

var r=confirm("Press a button");
if (r==true)
  {
  x="You pressed OK!";
  }
else
  {
  x="You pressed Cancel!";
  }