Does not update a record in MVC using Linq to SQL.

Question

0.00/5 (No votes)

See more:

Hi friends i am new in MVC,

I'm working on an MVC application with LINQ TO SQL ORM.While update operation it show the error-

C#

Object reference not set to an instance of an object.

Below is the Action to Update

public ActionResult disUpdate(Employee eid)
        {
            if (ModelState.IsValid)
            {
                
                
                 Empmaster ed1 = db.Empmasters.Where(u => u.Emp_Id == eid.EmployeeID).SingleOrDefault();
                //Empmaster ed1 = db.Empmasters.Where(e => e.Emp_Id == eid.EmployeeID).FirstOrDefault();
                 
                ed1.Category = eid.Category;
                 ed1.Emp_Name = eid.ename;
                 ed1.Father_Husband_Name = eid.fname;
                 ed1.departmet = eid.dept;
                 ed1.designation = eid.des;
                 ed1.doj = eid.doj;
                 ed1.dob = eid.dob;
                 ed1.sex = eid.sex;
                 ed1.mstatus = eid.mstatus;
                 ed1.address = eid.address;
                 ed1.status = Convert.ToChar(eid.status);
                db.SubmitChanges();
                return View("Index");
            }
            else
            {

                return View();
            }
        
        }

Posted 7-Jan-16 22:33pm

Ujjval Shukla

Add a Solution

Comments

Herman<T>.Instance 8-Jan-16 4:43am

at which line the exception occurs?

Ujjval Shukla 8-Jan-16 5:06am

At this Line-

ed1.Category = eid.Category;

Herman<T>.Instance 8-Jan-16 5:16am

Have you debugged your code and checked if eid = null?

Ujjval Shukla 8-Jan-16 5:28am

Ye eid=null.

Herman<T>.Instance 8-Jan-16 6:03am

and that explains:
Object reference not set to an instance of an object.

Ujjval Shukla 8-Jan-16 6:16am

I know eid=null thats why it shows error Object reference not set to an instance of an object.But how can i resolved it.I tried it but not got the solution.Why model's EmployeeId shows=0 instead of actual id like 1,2..etc.Is there any data binding problem or something else.Similarly when i used Employeename instead of EmployeeID in where condition it works properly and Updata data.

Herman<T>.Instance 8-Jan-16 6:27am

I don't know the calling objects. That should have a valid Employee object.

Richard Deeming 8-Jan-16 8:28am

Are you sure it's eid which is null? If that was the case, I'd expect to see the error thrown on the previous line:
.Where(u => u.Emp_Id == eid.EmployeeID)

I suspect it's more likely that ed1 is null, meaning that there's no record in the Empmasters table with the specified employee ID.

Ujjval Shukla 9-Jan-16 3:04am

Thanks Richards for Reply,

Records are Ok in table.I have resolved the problem.Actually i did not use Employeeid field in select query on which where condition working in HttpGet Action.Now it's working for me.

Thanks again.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)