adding user to database from textbox in web forms

Question

I am trying to save a username to a database after clicking the Add User button but having trouble this is what i have:

 private void btnAddUser_Click(object sender, EventArgs e)
    {
        using (var db = new DocMgmtDataContext())
        {
            User user = new User()
            {
                FullName = (NewUserName.Text as User).ID
            };
            db.Users.InsertOnSubmit(user);
            db.SubmitChanges();
        }
        UpdateUserLists();
    }

it is not liking the as User part.

MY SOLUTION

FullName = NewUserName.Text, ID = Guid.NewGuid()

Andre Loker · Accepted Answer · 2013-02-14 14:08:34Z

2

NewUserName.Text is probably of type String and you're trying to cast it to a User. This will certainly not work.

Try this:

 FullName = NewUserName.Text

answered Feb 14, 2013 at 14:08

Andre Loker

8,4181 gold badge25 silver badges36 bronze badges

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

3 Comments

BB987 Over a year ago

I noticed that after i made this change - it worked and the user was added successfully but when i went to add another user it gave me an error that i cannot add duplicate user (different names) but as i looked into the database i noticed the user i added has id value of 00000... and i think every user i am adding it is trying to assign 000000... as well.

Andre Loker Over a year ago

If you want to autogenerate an ID for each user, make the ID column of the database table an IDENTITY column, assuming you're using SQL Server.

BB987 Over a year ago

so making the change in the database is the only solution? i just want to make sure because i wasn't the one creating it and want to make sure to ask before making the proper changes

scartag · Accepted Answer · 2013-02-14 14:08:17Z

1

change this

 FullName = (NewUserName.Text as User).ID

To this

 FullName = NewUserName.Text

answered Feb 14, 2013 at 14:08

scartag

17.7k3 gold badges52 silver badges53 bronze badges

Comments

gzaxx · Accepted Answer · 2013-02-14 14:08:49Z

1

I assume that from your NewUserName Textbox you want to get user FullName so change your code to this:

private void btnAddUser_Click(object sender, EventArgs e)
{
    using (var db = new DocMgmtDataContext())
    {
         User user = new User()
         {
                FullName = NewUserName.Text //fix
         };
         db.Users.InsertOnSubmit(user);
         db.SubmitChanges();
    }
}

answered Feb 14, 2013 at 14:08

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

Collectives™ on Stack Overflow

adding user to database from textbox in web forms

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related