Question

string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" + "SERVER=localhost;" + "DATABASE=new_db;" + "UID=root;" + "PASSWORD=password;" + "OPTION=3";

OdbcConnection MyConnection = new OdbcConnection(MyConString);

OdbcCommand cmd = new OdbcCommand("UPDATE awm_create SET referral_email=?  WHERE email=? " , MyConnection);

//cmd.Parameters.Add("@tb_refemail", OdbcType.VarChar, 255).Value = tb_refemail.Text.Trim();
//cmd.Parameters.Add("@tb_email", OdbcType.VarChar, 255).Value = tb_email.Text.Trim();

MyConnection.Open();

cmd.ExecuteNonQuery();

How to provide the referral_email and email using forms?

评注法典是否以任何方式发挥作用?

Please correct the above code

Answer 1

删除你指挥案文中的单一字句:

OdbcCommand cmd = new OdbcCommand("UPDATE awm_create 
   SET referral_email=? WHERE email=?" , MyConnection);

友情链接