我想找到名為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();
}
uj5u.com熱心網友回復：
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();
}
uj5u.com熱心網友回復：
可是欄位名為test的值并沒有被更新啊？要如何更新它的值呢，比如它現在值為0，將它更新為1
uj5u.com熱心網友回復：
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();
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/29622.html
標籤：基礎類
下一篇：軟考中級