Asp.Net Entity Framework textbox to database

Question

New to this.

I have a database, one table "Logins":

FirstName, LastName, Birthdate, Email

I am using VS2015 and I am using Entity Framework 6 and have my database loaded in through there. I have text boxes and I want the data entered in them to insert into the table "Logins" when submit is clicked.

I've been looking online and watching videos an I just seem to be getting more confused. How do I do this?

This is what I have on the back end code (the front just has the textboxes and submit button):

 protected void btnSubmit_Click(object sender, EventArgs e)
    {

        using (LoginData2Entities lg = new LoginData2Entities())
        {

            DateTime birthdate = DateTime.Parse(tbBirth.Text);

            Logins l = new Logins();
            l.FirstName = tbFirstName.Text;
            l.LastName = tbLastName.Text;
            l.Birthdate = birthdate;
            l.Email= tbEmail.Text;


            lg.SaveChanges();


        }

Nothing is saving to the database. How do I fix this?

missing lg.Logins.Add(l) ?

Sachu
– Sachu

2016-02-18 06:38:39 +00:00
Commented Feb 18, 2016 at 6:38 — Sachu
– Sachu, Commented Feb 18, 2016 at 6:38

Akshay Gupta · Accepted Answer · 2016-02-18 06:41:21Z

1

You are not adding the Login object l with your LoginData2Entities object so there is nothing to save into the database.. add this in your code.

lg.Logins.Add(l);

it will look like this..

using (LoginData2Entities lg = new LoginData2Entities())
        {

            DateTime birthdate = DateTime.Parse(tbBirth.Text);

            Logins l = new Logins();
            l.FirstName = tbFirstName.Text;
            l.LastName = tbLastName.Text;
            l.Birthdate = birthdate;
            l.Email= tbEmail.Text;
            lg.Logins.Add(l);
            lg.SaveChanges();

        }

answered Feb 18, 2016 at 6:41

Akshay Gupta

3612 gold badges6 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

wiredlime2015 Over a year ago

AH, that was it! Thank you!

Sachu · Accepted Answer · 2016-02-18 06:40:35Z

0

you are not adding the object to database before performing savechanges..

 using (LoginData2Entities lg = new LoginData2Entities())
        {

            DateTime birthdate = DateTime.Parse(tbBirth.Text);
            Logins l = new Logins();
            l.FirstName = tbFirstName.Text;
            l.LastName = tbLastName.Text;
            l.Birthdate = birthdate;
            l.Email= tbEmail.Text;
            lg.Logins.Add(l); //add the object 
            lg.SaveChanges();
        }

answered Feb 18, 2016 at 6:40

Sachu

7,7549 gold badges59 silver badges101 bronze badges

Collectives™ on Stack Overflow

Asp.Net Entity Framework textbox to database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related