1,105,644 Community Members

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

Member Avatar
Junior Poster in Training
60 posts since Aug 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 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())
                StaffData addstaff = new StaffData();

                addstaff.StaffName = txtUserName;
                addstaff.Sex = gender;
                addstaff.DateCreated = DateTime.Now;
                addstaff.Profession = txtProfession;
                addstaff.PhoneNumber = txtMobilePhone;
                addstaff.Address = txtAddress;
            catch (Exception exp)
                throw new Exception("ERROR: Unable to Add Staff - " + exp.Message.ToString(), exp);
            return true;
Member Avatar
Practically a Master Poster
625 posts since Feb 2011
Reputation Points: 120 [?]
Q&As Helped to Solve: 69 [?]
Skill Endorsements: 15 [?]

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

Member Avatar
Posting Whiz in Training
204 posts since Jul 2009
Reputation Points: 16 [?]
Q&As Helped to Solve: 22 [?]
Skill Endorsements: 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 :)

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