using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Default2 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { var dataview = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); foreach (DataRowView dataviewrow in dataview) { lblradreturn_GT1.Text = dataviewrow["rad_return"].ToString(); lblradforward_GT4.Text = dataviewrow["rad_forward"].ToString(); lblbrinein.Text = dataviewrow["brine_in"].ToString(); lblbrineout.Text = dataviewrow["brine out"].ToString(); lblcompgas.Text = dataviewrow["Hot_gas_Compr"].ToString(); lblheatcarrierin.Text = dataviewrow["heatcarrier_return"].ToString(); lblheatcarrierout.Text = dataviewrow["heatcarrier_forward"].ToString(); lblhotwater.Text = dataviewrow["Hot_water_1_Top"].ToString(); lbloutside.Text = dataviewrow["outdoor"].ToString(); lblinside.Text = dataviewrow["indoor"].ToString(); if (dataviewrow["Compressor_is"].ToString() != "0") { compon.Visible = true; compoff.Visible = false; } else { compon.Visible = false; compoff.Visible = true; } if (dataviewrow["Pump_Radiator"].ToString() != "0") { cirkpumpon.Visible = true; circpumpoff.Visible = false; } else { cirkpumpon.Visible = false; circpumpoff.Visible = true; } if (dataviewrow["Switch_Valve"].ToString() == "0") { valveon.Visible = true; valveoff.Visible = false; } else { valveon.Visible = false; valveoff.Visible = true; } if (dataviewrow["Pump_Cold_circuit"].ToString() != "0") { kbpumpon.Visible = true; kbpumpoff.Visible = false; } else { kbpumpon.Visible = false; kbpumpoff.Visible = true; } if (dataviewrow["Pump_Heat_circuit"].ToString() != "0") { hcpumpon.Visible = true; hcpumpoff.Visible = false; } else { hcpumpon.Visible = false; hcpumpoff.Visible = true; } if (dataviewrow["Add_Heat_1"].ToString() != "0") { elheater1on.Visible = true; elheater1off.Visible = false; } else { elheater1on.Visible = false; elheater1off.Visible = true; } if (dataviewrow["Add_Heat_2"].ToString() != "0") { elheater2on.Visible = true; elheater2off.Visible = false; } else { elheater2on.Visible = false; elheater2off.Visible = true; } } } }