c# - 在数据库中显示为空的行 - asp.net c#

Question

我正在尝试使表单将信息发送到数据库。我的按钮代码如下。它似乎连接到数据库，但是添加的所有值都是空值。我错过了什么吗？我重新检查了表单中字段的 ID(TextBoxUN、TextBoxEmail..)，它们都匹配。

谢谢。

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());
        }
    }

Answer 1

从参数中删除“,”字符