C#数据库更新问题!

Question

思路是这样的，给出代码大家看看

Answer 1

string username = user_name.Text;
        string userfullname = user_fullname.Text;
        string usersex;
        if (user_sex0.Checked == true)
        {
            usersex = "先生";
        }
        else
        {
            usersex = "女士";
        }
        string usermail = user_mail.Text;
        string usercompany = user_commany.Text;
        string useraddr = user_addr.Text;
        string usershr = user_shr.Text;
        string userpostcode = user_postcode.Text;
        string usertel = user_tel.Text;
        string userfax = user_fax.Text;
        string usermobile = user_mobile.Text;
        DateTime userlasttime = DateTime.Now;
        string userlastip = Request.ServerVariables.GetValues("REMOTE_ADDR")[0];
        Response.Write(usermail);
    
        OleDbConnection ocon = new OleDbConnection(ConfigurationManager.ConnectionStrings["mylink"].ConnectionString);
        ocon.Open();
        string sql1 = "UPDATE [meuser] SET [user_mail]='"+usermail+"',[user_addr]='"+useraddr+"',[user_tel]='"+usertel+"', [user_lasttime]='"+userlasttime+"', [user_lastip]='"+userlastip+"', [user_postcode]='"+userpostcode+"', [user_shr]='"+usershr+"', [user_company]='"+usercompany+"', [user_fax]='"+userfax+"', [user_mobile]='"+usermobile+"', [user_fullname]='"+userfullname+"',[user_sex]='" + usersex + "' WHERE user_name='" + username + "'";
        OleDbCommand ocmm1 = new OleDbCommand(sql1, ocon);
                if (ocmm1.ExecuteNonQuery() > 0)
                {
                    Panel2.Visible = false;
                    Panel3.Visible = true;                }
                         
            ocon.Close();