当字段为一个变量时，如何更新它的值？

[不正经的小姑娘]

我想找到名为nowlevel的字段，并更新它的数值，nowlevel是一个变量，该怎么做呢？
public void savetDatalevelstars(int id, string nowlevel,int starsnum)
{
string connStr = "Database=angrybird;datasource=127.0.0.1;port=3306;user=root;pwd=root;";
conn = new MySqlConnection(connStr);
conn.Open();
MySqlCommand cmd = new MySqlCommand("update scores set nowlevel = '" + @nowlevel + "' where userid ='" + id + "'", conn);
cmd.Parameters.AddWithValue("stars", starsnum);
cmd.ExecuteNonQuery();
conn.Close();
}

[Hello World,]

public void savetDatalevelstars(int id, string nowlevel,int starsnum)
    {
         string connStr = "Database=angrybird;datasource=127.0.0.1;port=3306;user=root;pwd=root;";
         conn = new MySqlConnection(connStr);
         conn.Open();
         MySqlCommand cmd = new MySqlCommand("update scores set " + nowlevel + "=@stars where userid ='" + id + "'", conn);
        cmd.Parameters.AddWithValue("stars", starsnum);
        cmd.ExecuteNonQuery();
         conn.Close();
}

[独木成林_]

public void savetDatalevelstars(int id, string nowlevel,int starsnum) { nowlevel = "Test"; string connStr = "Database=angrybird;datasource=127.0.0.1;port=3306;user=root;pwd=root;"; conn = new MySqlConnection(connStr); conn.Open(); MySqlCommand cmd = new MySqlCommand("update scores set nowlevel = '" + @nowlevel + "' where userid ='" + id + "'", conn); cmd.Parameters.AddWithValue("stars", starsnum); cmd.ExecuteNonQuery(); conn.Close(); }

[不正经的小姑娘]

引用 1 楼 独木成林_ 的回复:

public void savetDatalevelstars(int id, string nowlevel,int starsnum)
{

nowlevel = "Test";
string connStr = "Database=angrybird;datasource=127.0.0.1;port=3306;user=root;pwd=root;";
conn = new MySqlConnection(connStr);
conn.Open();
MySqlCommand cmd = new MySqlCommand("update scores set nowlevel = '" + @nowlevel + "' where userid ='" + id + "'", conn);
cmd.Parameters.AddWithValue("stars", starsnum);
cmd.ExecuteNonQuery();
conn.Close();
}

可是字段名为test的值并没有被更新啊？要如何更新它的值呢，比如它现在值为0，将它更新为1