public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { Response.Clear(); Response.ContentType = "text/xml"; Response.Charset = "UTF-8"; string db = 「データソース=LENOVO-85DD1539;初期カタログ=Emne;ユーザーID=sa;パスワード=ehs123456」; string sql = "select * from Emne"; SqlConnection conn = new SqlConnection(db); conn.Open(); SqlCommand comm = new SqlCommand(sql, conn); SqlDataReader sdr = comm.ExecuteReader(); Class1 c = new Class1(); while (sdr.Read()) { c.Id = Convert.ToInt32(sdr["Id"]); c.Temperature = Convert.ToInt32(sdr["Temperature"]); c.Humidity = Convert.ToInt32(sdr["Humidity"]); c.Airquality = Convert.ToInt32(sdr["Airquality"]); c.Fan = Convert.ToInt32(sdr["Fan"]); c.Button1 = Convert.ToInt32(sdr["Button1"]); c.Button2 = Convert.ToInt32(sdr["Button2"]); c.Button3 = Convert.ToInt32(sdr["Button3"]); c.Button4 = Convert.ToInt32(sdr["Button4"]); c.Button5 = Convert.ToInt32(sdr["Button5"]); c.Button6 = Convert.ToInt32(sdr["Button6"]); } XmlWriter ライター = null; 試してみてください { XmlSerializer シリアライザー = new XmlSerializer(c.GetType()); //string l = AppDomain.CurrentDomain.BaseDirectory; //StreamWriter myWriter = new StreamWriter(l + "/myFileName.xml"); //mySerializer.Serialize(myWriter, c); ライター = 新しい XmlTextWriter(Response.OutputStream, Encoding.UTF8); serializer.Serialize(writer, c); } 最後に { if (writer != null) { writer.Close(); } if (Request.QueryString["bu"] != null) { 試してみる { string id = Request.QueryString["bu"].ToString(); if (id.Equals("Button1")) { if (c.Button1 == 0) { sql = "update Emne set Button1=1 where Id=" + c.Id; . sql = "update Emne set Button1=0 where Id=" + c.Id;
conn.Close(); conn.Open(); comm = new SqlCommand(sql, conn); comm.ExecuteReader(); conn.Close(); } if (id.Equals("Button2")) { if (c.Button1 == 0) { sql = "update Emne set Button2=1 where Id=" + c.Id; { else sql = 「update Emne set Button2=0 where Id= + c.Id;
conn.Close(); conn.Open(); comm = new SqlCommand(sql, conn); comm.ExecuteReader(); conn.Close(); } if (id.Equals("Button3")) { if (c.Button1 == 0) { sql = "update Emne set Button3=1 where Id=" + c.Id; . sql = 「update Emne set Button3=0 where Id= + c.Id;
conn.Close(); conn.Open(); comm = new SqlCommand(sql, conn); comm.ExecuteReader(); conn.Close(); } if (id.Equals("Button4")) { if (c.Button1 == 0) { sql = "update Emne set Button4=1 where Id=" + c.Id; . sql = 「update Emne set Button4=0 where Id= + c.Id;
conn.Close(); conn.Open(); comm = new SqlCommand(sql, conn); comm.ExecuteReader(); conn.Close(); } if (id.Equals("Button5")) { if (c.Button1 == 0) { sql = 「update Emne set Button5=1 where Id= + c.Id; { else sql = "update Emne set Button5=0 where Id=" + c.Id;
conn.Close(); conn.Open(); comm = new SqlCommand(sql, conn); comm.ExecuteReader(); conn.Close(); } if (id.Equals("Button6")) { if (c.Button1 == 0) { sql = "update Emne set Button6=1 where Id=" + c.Id; . sql = 「update Emne set Button6=0 where Id= + c.Id;