Click here to Skip to main content
15,905,028 members
Home / Discussions / C#
   

C#

 
QuestionPartial Snippet Pin
Mycroft Holmes18-Apr-14 16:30
professionalMycroft Holmes18-Apr-14 16:30 
AnswerRe: Partial Snippet Pin
Richard MacCutchan18-Apr-14 21:59
mveRichard MacCutchan18-Apr-14 21:59 
GeneralRe: Partial Snippet Pin
Mycroft Holmes19-Apr-14 2:38
professionalMycroft Holmes19-Apr-14 2:38 
AnswerRe: Partial Snippet Pin
OriginalGriff19-Apr-14 4:31
mveOriginalGriff19-Apr-14 4:31 
Questiona concept I'm trying to build Pin
solo918-Apr-14 15:07
solo918-Apr-14 15:07 
GeneralRe: a concept I'm trying to build Pin
Richard MacCutchan18-Apr-14 21:57
mveRichard MacCutchan18-Apr-14 21:57 
Questioni want to hyperlink connect with stringquery and also display same hyperlink on other page Pin
Member 1061806718-Apr-14 12:12
Member 1061806718-Apr-14 12:12 
AnswerRe: i want to hyperlink connect with stringquery and also display same hyperlink on other page Pin
Richard Andrew x6418-Apr-14 12:19
professionalRichard Andrew x6418-Apr-14 12:19 
GeneralRe: i want to hyperlink connect with stringquery and also display same hyperlink on other page Pin
Member 1061806718-Apr-14 12:40
Member 1061806718-Apr-14 12:40 
GeneralRe: i want to hyperlink connect with stringquery and also display same hyperlink on other page Pin
Richard Andrew x6418-Apr-14 12:54
professionalRichard Andrew x6418-Apr-14 12:54 
QuestionProperty with "get" only, or a separate method? Pin
Matt U.18-Apr-14 8:09
Matt U.18-Apr-14 8:09 
AnswerRe: Property with "get" only, or a separate method? Pin
OriginalGriff18-Apr-14 8:15
mveOriginalGriff18-Apr-14 8:15 
GeneralRe: Property with "get" only, or a separate method? Pin
Matt U.18-Apr-14 8:16
Matt U.18-Apr-14 8:16 
GeneralRe: Property with "get" only, or a separate method? Pin
OriginalGriff18-Apr-14 8:32
mveOriginalGriff18-Apr-14 8:32 
AnswerRe: Property with "get" only, or a separate method? Pin
Ravi Bhavnani18-Apr-14 8:16
professionalRavi Bhavnani18-Apr-14 8:16 
GeneralRe: Property with "get" only, or a separate method? Pin
Matt U.18-Apr-14 8:19
Matt U.18-Apr-14 8:19 
GeneralRe: Property with "get" only, or a separate method? Pin
Ravi Bhavnani18-Apr-14 8:59
professionalRavi Bhavnani18-Apr-14 8:59 
Questionmarching cubes Pin
Member 1071125918-Apr-14 7:25
Member 1071125918-Apr-14 7:25 
AnswerRe: marching cubes Pin
OriginalGriff18-Apr-14 8:10
mveOriginalGriff18-Apr-14 8:10 
QuestionBackground Substraction and HOG Pin
Member 1042078418-Apr-14 5:42
Member 1042078418-Apr-14 5:42 
QuestionDisplay graph from selected dropdownlist and radiobutton Pin
Syafiqah Zahirah18-Apr-14 0:43
Syafiqah Zahirah18-Apr-14 0:43 
Hye..can anyone know how I can I display graph from selected dropdownlist and radiobutton. My code like below:

XML
<table>
    <tr>
    <td><h4><span>Choose House:</span></h4></td>
    <td class="style4">
        <asp:DropDownList ID="DropDownList1" runat="server" Height="16px" Width="114px">
        </asp:DropDownList>
        </td>
        <td class="style5"></td>
        <td class="style6"></td>
    </tr>

    <tr>
    <td><h4><span>View:</span></h4></td>
    <td class="style4">
        <asp:RadioButton ID="LineRadioButton" runat="server" Text="Line Graph" />
        </td>
        <td class="style4">
            <asp:RadioButton ID="PieButton" runat="server" Text="Pie Chart" />
        </td>
        <td class="style4">
            <asp:RadioButton ID="BarRadioButton" runat="server" Text="Bar Graph" />
        </td>
    </tr>
    </table>
    <asp:Chart ID="Chart1" runat="server" Height="394px" Width="937px"
        BackColor="PaleTurquoise">
        <Titles>
            <asp:Title ShadowOffset="3" Name="Muhsroom House Environment" />
        </Titles>
       <Legends>
         <asp:Legend Alignment="Center" Docking="Bottom" IsTextAutoFit="False" Name="TempIn" LegendStyle="Row" />
         <asp:Legend Alignment="Center" Docking="Bottom" IsTextAutoFit="False" Name="TempOut" LegendStyle="Row" />
         <asp:Legend Alignment="Center" Docking="Bottom" IsTextAutoFit="False" Name="Humidity" LegendStyle="Row" />
      </Legends>
        <Series>
                <asp:Series legendtext="Temperature In" ChartType="Line" Name="TempIn"> </asp:Series>
                <asp:Series legendtext="Temperature Out"  ChartType="Line" Name="TempOut"> </asp:Series>
                <asp:Series legendtext="Humidity"  ChartType="Line" Name="Humidity"> </asp:Series>
         </Series>
            <borderskin backcolor="Olive" bordercolor="Olive" skinstyle="Emboss" />
            <ChartAreas>
                <asp:ChartArea Name="ChartArea1">
                 <AxisY Title="Degrees" ></AxisY>
                 <AxisX Title="Time"></AxisX>
                 <Area3DStyle IsClustered="True"></Area3DStyle>
                </asp:ChartArea>
            </ChartAreas>
    </asp:Chart>
    <br />


     <table>
     <tr>
     <td>
         TempIn: <asp:TextBox ID="TempInTextBox" runat="server" Width="20px"></asp:TextBox>
         </td>
     <td>
         TempOut:<asp:TextBox ID="TempOutTextBox" runat="server" Width="20px"></asp:TextBox>
         </td>
     <td>
         Humidity:<asp:TextBox ID="HumidTextBox" runat="server" Width="20px"></asp:TextBox>
         </td>
     </tr>
     </table>


Coding aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using System.Web.UI.DataVisualization.Charting;

namespace PSM_Mushroom
{
public partial class Graph : System.Web.UI.Page
{

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=MushroomHouse;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string CS = ConfigurationManager.ConnectionStrings["MushroomHouse"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{

SqlCommand cmd = new SqlCommand("SELECT id, Name FROM TMushroomHouse", con);

con.Open();

DropDownList1.DataSource = cmd.ExecuteReader();
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "id";
DropDownList1.DataBind();
}
}

}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{

String strConnString = ConfigurationManager.ConnectionStrings["MushroomHouse"].ConnectionString;

string sql = "SELECT Environmnets.TempIn, Environmnets.tempOut, Environmnets.humidity, FROM Environmnets INNER JOIN TDevice ON Environmnets.Deviceid = TDevice.id INNER JOIN TMushroomHouse ON TDevice.MushroomHouseId = TMushroomHouse.id WHERE TMushroomHouse.id=@id";

using (SqlConnection con = new SqlConnection(strConnString))
using (SqlCommand cmd = new SqlCommand(sql, con))
//SqlDataReader dr = cmd.ExecuteReader();
{
cmd.Parameters.AddWithValue("@id", DropDownList1.Text);

con.Open();

using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
TempInTextBox.Text = dr.GetValue(0).ToString();
TempOutTextBox.Text = dr.GetValue(1).ToString();
HumidTextBox.Text = dr.GetValue(2).ToString();


Chart1.Series["TempIn"].Points.AddXY(DateTime.Now.ToShortTimeString(),Double.Parse(TempInTextBox.Text));
Chart1.Series["TempOut"].Points.AddXY(DateTime.Now.ToShortTimeString(),Double.Parse(TempOutTextBox.Text));
Chart1.Series["Humidity"].Points.AddXY(DateTime.Now.ToShortTimeString(),Double.Parse(HumidTextBox.Text));
}
}
}

}


}
QuestionCS1525: Invalid expression term '<' error Pin
Member 1075622017-Apr-14 6:12
Member 1075622017-Apr-14 6:12 
AnswerRe: CS1525: Invalid expression term '<' error Pin
Wes Aday17-Apr-14 6:29
professionalWes Aday17-Apr-14 6:29 
GeneralRe: CS1525: Invalid expression term '<' error Pin
OriginalGriff17-Apr-14 8:26
mveOriginalGriff17-Apr-14 8:26 
GeneralRe: CS1525: Invalid expression term '<' error Pin
Richard MacCutchan17-Apr-14 22:16
mveRichard MacCutchan17-Apr-14 22:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.