Query in LINQ TO SQL not inserting

Question

I've created a simple query in adding users in the database but there error is that the data is not showing. here's my code

private void button1_Click(object sender, EventArgs e)
        {
            using (DataClasses1DataContext myDbContext = new DataClasses1DataContext(dbPath))
            {

                //Instantiate a new Hasher Object
                var hasher = new Hasher();

                hasher.SaltSize = 16;

                //Encrypts The password
                var encryptedPassword = hasher.Encrypt(txtPass.Text);

                Account newUser = new Account();

                newUser.accnt_User = txtUser.Text;
                newUser.accnt_Position = txtPosition.Text;


                // Replace AccountTableName with the actual table
                // name found in your dbml's context
                myDbContext.Accounts.InsertOnSubmit(newUser);
                myDbContext.SubmitChanges();
                MessageBox.Show("XD");
            }
        }

And My Table data shows only this

enter image description here

just asking, have you closed the dialog which shows the table data and refreshed the page and checked again? — Jayanga
– Jayanga, Commented Feb 24, 2012 at 18:25
You're setting the Position twice. The second should probably be the password. Typo? — Mark Peters
– Mark Peters, Commented Feb 24, 2012 at 18:25
How do I insert the encrypted password? it gave me an error that it cannot be converted to a string — user962206
– user962206, Commented Feb 24, 2012 at 18:34

Community · Accepted Answer · 2017-05-23 12:33:44Z

3

You need to set the InsertOnSubmit directly on the context:

Edit: Using statement added. Reminder courtesy of @David Khaykin

using (DataClasses1DataContext myDbContext = new DataClasses1DataContext(dbPath))
{

    //Instantiate a new Hasher Object
    var hasher = new Hasher();

    hasher.SaltSize = 16;

    //Encrypts The password
    var encryptedPassword = hasher.Encrypt(txtPass.Text);

    Account newUser = new Account();

    newUser.accnt_User = txtUser.Text;
    newUser.accnt_Position = txtPosition.Text;
    newUser.accnt_Position = encryptedPassword;

    // Replace AccountTableName with the actual table
    // name found in your dbml's context
    myDbContext.AccountTableName.InsertOnSubmit(newUser);
    myDbContext.SubmitChanges();
}

edited May 23, 2017 at 12:33

CommunityBot

11 silver badge

answered Feb 24, 2012 at 18:27

Joel Etherton

37.5k10 gold badges92 silver badges106 bronze badges

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

10 Comments

Dmitriy Khaykin Over a year ago

Exactly correct - and @user962206, I would recommend wrapping the whole thing in a using {} statement; i.e., using (DataClasses1DataContext myDbContext = new DataClasses1DataContext(dbPath)) { // your code }

user962206 Over a year ago

@David Khaykin it gave me this error Error 2 'PAS.DataClasses1DataContext' does not contain a definition for 'Context' and no extension method 'Context' accepting a first argument of type 'PAS.DataClasses1DataContext' could be found (are you missing a using directive or an assembly reference?) C:\Users\John\Documents\Visual Studio 2010\Projects\PAS\PAS\AddUserWindow.cs 51 25 PAS

Dmitriy Khaykin Over a year ago

@user962206: Check the DBML file and make sure the "accounts" table is included; if it is not found in the context, it means the DBML file doesn't contain that table.

Dmitriy Khaykin Over a year ago

@user962206 that is correct, DataClasses1DataContext does not contain a property called context; the "context" is the name of the variable that represents your DataClasses1DataContext, in your example, it is "myDbContext"; so if the table name is accounts, and your variable is called myDbContext, then you write myDbContext.accounts.InsertOnSubmit(newUser); myDbContext.SubmitChanges() - just like shown in this answer.

Joel Etherton Over a year ago

@David Khaykin: +1 on the using statment. In fact I'm going to edit to incorporate.

|

Collectives™ on Stack Overflow

Query in LINQ TO SQL not inserting

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related