Using ASP.NET to Insert Data into a Database

Question

I have a form on my web page that I want posting to my database in the background upon submitting the form. Here is my code:

if (Validation.IsValid()) 
{
    // Insert a new user into the database
    var db = Database.Open("StarterSite");

    // Check if user already exists
    var user = db.QuerySingle("SELECT Email FROM UserProfile WHERE LOWER(Email) = LOWER(@0)", email);
    if (user == null) {
        // Insert email into the profile table
        db.Execute("INSERT INTO UserProfile (Email) VALUES (@0)", email);
    }
}

This is sample code and I'm trying to interpret it. What's baffling me is that is says VALUES (@0). However, when the form on this page is submitted, it still manages to post the inputted email address though the value says (@0) ?

Any clarity would be greatly appreciated!

Regards,

Josh

(P.S, I'm new to ASP.NET)

By tagging sql you can simply check if the user exist or not by applying unique constraint. Have a look at the link which gives you detailed information about how to insert records into the database . onlinebuff.com/… — HEEN
– HEEN, Commented Aug 22, 2016 at 10:48

Milney · Accepted Answer · 2016-08-22 11:08:27Z

1

@0 refers to the first parameter. In your case it is the variable email as so;

db.Execute("INSERT INTO UserProfile (Email) VALUES (@0)", email);

You can insert more than one ordered parameter like this;

db.Execute("INSERT INTO UserProfile (Email, SecondParam) VALUES (@0, @1)", @0, @1);

answered Aug 22, 2016 at 11:08

Milney

6,4472 gold badges21 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Using ASP.NET to Insert Data into a Database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related