Rows showing up as null in database - asp.net c#

Question

I am trying to make a form send info to a database. The code for my button is below. It seems to connect to the database, but all the values that are added are null. Am I missing something? I've rechecked the ids for the fields in the form (TextBoxUN,TextBoxEmail..) and they all match.

Thanks.

protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {

            MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["apstestConnectionString"].ConnectionString);//string used in sql datasource
            conn.Open();
            string insertQuery = "insert into asptable (username,email,password,country) values (@Uname,@email,@password,@country)";
            MySqlCommand com = new MySqlCommand(insertQuery, conn);

            com.Parameters.AddWithValue("@Uname,", TextBoxUN.Text);
            com.Parameters.AddWithValue("@email,", TextBoxEmail.Text);
            com.Parameters.AddWithValue("@password,",TextBoxPass.Text);
            com.Parameters.AddWithValue("@country,",DropDownListCountry.SelectedItem.ToString());

            com.ExecuteNonQuery();

            conn.Close(); 
            Response.Redirect("Manager.aspx");

        }
        catch(Exception ex){
            Response.Write("Error:"+ex.ToString());
        }
    }

why is there a comma after every parameter?

Sybren
– Sybren

2015-06-20 22:24:54 +00:00
Commented Jun 20, 2015 at 22:24 — Sybren
– Sybren, Commented Jun 20, 2015 at 22:24
I gave the first answer can you mark as accepted?

Sybren
– Sybren

2015-06-20 22:31:06 +00:00
Commented Jun 20, 2015 at 22:31 — Sybren
– Sybren, Commented Jun 20, 2015 at 22:31

Onur Gazioğlu · Accepted Answer · 2015-06-20 22:25:31Z

2

Remove "," chars from parameters

answered Jun 20, 2015 at 22:25

Onur Gazioğlu

5112 silver badges14 bronze badges

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

Comments

Jure · Accepted Answer · 2015-06-20 22:26:58Z

1

Remove commas from the end of parameter names when calling Parameters.AddWithValue and see if it helps. So instead of

AddWithValue("@Uname,",...)

write

AddWithValue("@Uname",...)

And the same for other parameters.

answered Jun 20, 2015 at 22:26

Jure

1,1765 silver badges19 bronze badges

Comments

Sybren · Accepted Answer · 2015-06-20 22:30:26Z

0

Instead of com.Parameters.AddWithValue("@Uname,", TextBoxUN.Text); remove the , after the parameter name and write com.Parameters.AddWithValue("@Uname", TextBoxUN.Text); without comma. Do this for all parameters.

answered Jun 20, 2015 at 22:30

Sybren

1,0793 gold badges18 silver badges53 bronze badges

Collectives™ on Stack Overflow

Rows showing up as null in database - asp.net c#

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related