#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
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