数据库更新

  #region----将信息存入数据库store the information to the SQL-------
        int userId = Convert.ToInt32(Session["UserId"]);
        string strcn = System.Configuration.ConfigurationManager.AppSettings["Main.ConnectionString"].Trim() + " ; Provider=SQLOLEDB;";
        OleDbConnection cn = new OleDbConnection(strcn);
        string sqlcmd = "update JackDonkey_User set Tag1='" + txt_tag1.Text + "', Tag2='" + txt_tag2.Text + "', Tag3='" + txt_tag3.Text + "', Tag4='" + txt_tag4.Text + "', Media='" + media + "', Options='" + options + "' where UserId=" + userId;
        cn.Open();
        OleDbCommand scmd = new OleDbCommand(sqlcmd, cn);
        scmd.ExecuteNonQuery();
        cn.Close();
        #endregion