1.11M Members

My C# window application cannot insert new record to sql database both in A

 
0
 

Good day people! I have a problem with my C# window application.
I can't insert new record to database. I have sought for many tutorial in ADO.net and Entity Framework.
I have been tackling it in Entity Framework because that is my preference.
My piece of Entity Framework code would run successfully to insert new record.
When i go back-end to see the result; none is found.I am using Visual studio 2010.
And i developed the database through visual studio (the normal way of adding new item).
I have this piece of code:

public bool CreateStaff(string txtUserName, string gender, string txtProfession, string txtMobilePhone, string txtAddress)
        {
            //using (MyHospDataEntities db = new MyHospDataEntities())
            //{
            try
            {
                StaffData addstaff = new StaffData();

                addstaff.StaffName = txtUserName;
                addstaff.Sex = gender;
                addstaff.DateCreated = DateTime.Now;
                addstaff.Profession = txtProfession;
                addstaff.PhoneNumber = txtMobilePhone;
                addstaff.Address = txtAddress;
                mms.StaffDatas.AddObject(addstaff);
                mms.SaveChanges();
            }
            catch (Exception exp)
            {
                throw new Exception("ERROR: Unable to Add Staff - " + exp.Message.ToString(), exp);
            }
            //}
            return true;
        }
 
0
 

Post the SaveChanges() method. What error did you get?

 
0
 

also post the 'AddObject(addstaff)' method, may be there is a problem with connection establishing and record saving or may be you open the connection in savechanges().
Not a serious issue, we can help :)

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: