|
I have a question about plotting data from database to a line grpah. In my line graph there is 3 data that is tempin, tempout and also humdity that I must plot in a line graph..I made this coding but it seem doesn't work.I have a sql statement to selesct data but I do know how to plotting the line in a graph. Can anyone help me?
string sql = "SELECT TempIn, tempOut, humidity FROM Environmnets WHERE DateT > DateADD(mi, -30, Current_TimeStamp) 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))
{
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));
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
}
con.Close();
|
|
|
|
|
There's not much to go on here.
Is your chart emtpy or do you get an error? What is the error? Did you debug and step through to find where it goes wrong?
Is the SQLDataReader filled after the statement is executed?
This Chart1 object, what is it? A library? Where there samples where you found the library. Some documentation? Do those samples work?
Also make sure to split business logic from fetching data...
|
|
|
|
|
<asp:Chart ID="Chart1" runat="server" Height="339px" Width="896px"
Chart1 is a Chart ID. Actually there is no error, but the graph is not display line graph as what I want. It will display all data in database but I just want to display data from 30 minutes only. Do you know in this forum there is function to attach picture? so u can see clearly what I want to explain.Tq
|
|
|
|
|
You cannot attach pictures, but you can upload one to an online repository (like flickr or something) and provide the link.
If you execute the SQL to the database directly, is the resultset correct?
If that is correct, debug and check if the resultset in your application is correct. If the graph is showing and drawing, the culprit is most probably getting the data.
|
|
|
|
|
The SQL is wrong. When I execute the SQL to the database, no result will show. I will try to attach the picture for you 
|
|
|
|
|
Syafiqah Zahirah wrote: 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));
Why do you send the values from the database to textboxes, and then parse them from the textboxes to numeric values again?
What about
double tempIn = dr.GetDouble(0);
Chart1.Series["TempIn"].Points.AddXY(DateTime.Now.ToShortTimeString(), tempIn);
And since you always use DateTime.Now on the x axis, I think you are missing something else. What about querying the DateTime value also from the database, and using it here instead of DateTime.Now?
|
|
|
|
|
Hye Bernhard! Tq for replying my message. I will try to change my coding referring in what u say. And one more thing, I actuallt didn't understand on what u try to explain to me with this sentence '. What about querying the DateTime value also from the database, and using it here instead of DateTime.Now?'. can you give some example? tq
Student that not familiar with C# code and try very hard to finish her final year project with flying colours. Hope that everyone out there can help me 
|
|
|
|
|
I tried to retrieve the DateTime value from database,and plot it to the graph but it doesn't seems to work. This is my code:
while (dr.Read())
{
double tempIn = dr.GetDouble(0);
double tempOut = dr.GetDouble(1);
double humidity = dr.GetDouble(2);
double date = dr.GetDouble(3);
DateTime? value = (DateTime?)dr["DateT"];
Chart1.Series["TempIn"].Points.AddXY(value, tempIn);
Chart1.Series["TempOut"].Points.AddXY(value tempOut);
Chart1.Series["Humidity"].Points.AddXY(value, humidity);
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
|
|
|
|
|
using System;
using System.IO;
using System.Collections;
namespace Applica
{
class Program
{
static void Main(string[] args)
{
DirectoryInfo da = new DirectoryInfo("C:\\Folder");
FileInfo[] Arr = da.GetFiles();
if (Arr.Length == 0)
{
throw new InvalidOperationException("No files found.");
}
FileInfo ap = Arr[Arr.Length - 1];
long Totbyte = ap.Length;
string filePath = ap.FullName;
string temPath = Path.GetTempFileName();
byte[] data = File.ReadAllBytes(filePath);
}
}
}
|
|
|
|
|
The ReadAllBytes method does exactly that: it reads the entire file content into the memory and returns it as an array of bytes. If you are getting "Out of memory" errors, then there are two main possibilities:
1) The size of any one file exceeds 2GB. There is an absolute limit on any .NET object of 2GB, no item (and an array of bytes is one item) can exceed this.
2) These are large files, and as such they will go on the Large Object Heap - anything larger than 85KB is a "large object" and as such goes on the LOH - which is not compacted, it's objects are "connected" when they are garbage collected, and it's filling up...but that should trigger a GC which should empty it so it shouldn't cause a problem.
The bad news is...System.Array does not implement IDisposable so you can't free it yourself. You might be able to force it, by setting data to null and manually calling the GC, but that's a nasty solution.
I would suggest that your best approach might be to "block read" your files: 64K lumps for example so that any allocation problem is reduced.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
<pre>
using System;
using System.IO;
using System.Collections;
namespace Applica
{
class Program
{
static void Main(string[] args)
{
DirectoryInfo da = new DirectoryInfo("C:\\Folder");
FileInfo[] Arr = da.GetFiles();
if (Arr.Length == 0)
{
throw new InvalidOperationException("No files found.");
}
FileInfo ap = Arr[Arr.Length - 1];
long Totbyte = ap.Length;
string filePath = ap.FullName;
string temPath = Path.GetTempFileName();
byte[] data = File.ReadAllBytes(filePath);
File.WriteAllBytes(temPath, data);
decimal[] arry = new decimal[Totbyte];
for (int count = 0; count < data.Length; count++)
{
arry[count] = data[count];
}
byte[] data2 = new byte[Totbyte];
for (int count = 0; count < arry.Length; count++)
{
data2[count] = (byte)arry[count];
}
string filePath2 = Path.Combine("C:\\check", Path.GetFileName(filePath));
File.WriteAllBytes(filePath2, data2);
data = File.ReadAllBytes(temPath);
data2 = File.ReadAllBytes(filePath);
}
}
}
|
|
|
|
|
¡Ay, caramba!
You do realize what that code does, don't you?
Not only do you allocate two arrays of bytes the same size as each file in the folder, you also allocate a third array 16 times larger for each file as well!
The decimal datatype is 128 bits wide - or 16 bytes!
So is any file in your folder is bigger than 134MB, you will exceed the 2GB maximum-object limit...and get "out of memory".
And frankly, that code doesn't make a whole lot of sense.
You read the file as bytes, copy each byte value to a decimal (which does nothing in practice), and then convert each decimal back to a byte (which will give you exactly what you started with!)
And then you write the data to a new place...
You could do the same much more easily with File.Copy... 
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
See my comment below; I thought I recognised this code.
|
|
|
|
|
|
hello guys,
below is my sql select statement :
SELECT product.P_ID, Product.P_Name,Product.Leadtime, Product.SafetyStockamount,
Monthlysales.Month, Monthlysales.totalsalesamount, (totalsalesamount/30) as Averagedailysales, ((totalsalesamount/30) * Leadtime + SafetyStockamount) as reorderpoint
FROM Product, Monthlysales
where Product.P_ID = Monthlysales.P_ID
in product table there are product id, name, lead time, safety stock column, meanwhile in monthly sales table, there are productid, month (in int), and totalsalespermonth.
the problem is :
i want to retrieve the reorder point result from the select statement above in visual studio c#
the interface will include product id , month options, button and label to show the result.
the reorder point result will be based on the month, for example
if the user choose
pid 1 : 1
month options: 2 (february)
then label result will show the reorder point amount for pid 1 in february.
i also wondering whether i can directly calculate the reorder point result based on product id and its month in sql server and directly call it in c#.
how could i do it?? please help me
thank you
|
|
|
|
|
And?
What help do you need?
You know how to use SQL from C# I assume, or you wouldn't be writing complicated SQL...so what do you need help with?
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Hi All,
In a tutorial I found a a new way (new for me)of updating a control from a thread.
In the example code the new way(AsyncParallel) is in button1_Click and what I am familiar with is in button2_Click.
They both do the job, but what is better, regarding performance and especially when more tasks are running that might update UI-thread?
Here is the example:
namespace Task_Compare
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string data = "";
Task Tf1 = Task.Factory.StartNew(() =>
{
data = GetData();
});
Task T2 = Tf1.ContinueWith((previousTask) =>
{
listBox1.Items.Insert(0, data);
}, TaskScheduler.FromCurrentSynchronizationContext());
}
private void button2_Click(object sender, EventArgs e)
{
string data = "";
Task Tf2 = Task.Factory.StartNew(() =>
{
data = GetData();
});
Tf2.Wait();
listBox1.Invoke(new EventHandler(delegate
{
listBox1.Items.Insert(0, data);
}));
}
private string GetData()
{
string temp = "";
{
temp = " Do something long running ......";
}
return temp;
}
}
}
Groover,
0200 A9 23
0202 8D 01 80
0205 00
|
|
|
|
|
GrooverFromHolland wrote: They both do the job, but what is better
They do the same; which one is 'better' is nitpicking. If you want to pick the nits (which can be fun and educational), download ILspy and decompile the class.
The Invoke-pattern is older than the Task-class, which was added in 4 (?). To some, the newer way is "more readable" as it does the same with less code (=fewer bugs). Others will be used to the old pattern.
I prefer not to have a wait or an extra task, but to invoke the UI from the thread using the classical invoke-pattern from MSDN;
1 using System;
2 using System.Collections.Generic;
3 using System.Linq;
4 using System.Text;
5 using System.Windows.Forms;
6 using System.Threading.Tasks;
7
8 namespace ConsoleApplication2
9 {
10 class Program
11 {
12 static void Main()
13 {
14 System.Threading.Thread.CurrentThread.Name = "Main thread";
15 using (var f = new SomeForm())
16 f.ShowDialog();
17 }
18 }
19 class SomeDataCollection : List<Guid> { }
20 class SomeForm: Form
21 {
22 ListBox _listBox1;
23 Button _button1;
24 public SomeForm()
25 {
26 _listBox1 = new ListBox() { Dock = DockStyle.Fill };
27 _button1 = new Button() { Dock = DockStyle.Top };
28 Controls.AddRange(new Control[] { _listBox1, _button1 });
29
30 _button1.Click += delegate
31 {
32 Task Tf2 = Task.Factory.StartNew(() =>
33 {
34 SomeDataCollection _data = getData();
35 showData(_data);
36 });
37 };
38 }
39 void showData(IList<Guid> whatData)
40 {
41 if (InvokeRequired)
42 {
43 Invoke(new Action<SomeDataCollection>(showData), new[] { whatData });
44 return;
45 }
46
47 _listBox1.DataSource = whatData;
48 }
49 SomeDataCollection getData()
50 {
51 var result = new SomeDataCollection();
52 for (int i = 0; i < 10; i++)
53 {
54 result.Add(Guid.NewGuid());
55 System.Threading.Thread.Sleep(150);
56 }
57 return result;
58 }
59 }
60 }
I keep preferring the old style as it makes for very predictable code-constructs. I would however add that it's beneficial during debugging to name each thread during coding! Put a breakpoint on line 35, run, and when the debugger hits it, choose "view, threads" from the menu in the VS-IDE. Each thread/task that you launch can have a unique name - which may even include spaces
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi Eddy,
Thank You for the good explanation.
Regards,
Groover
0200 A9 23
0202 8D 01 80
0205 00
|
|
|
|
|
You're welcome
|
|
|
|
|
Hy @ everyone,
i have a Little Problem:
class Track
{
string Name;
string Artist;
string Album;
int SampleRate;
int BitRate;
public Track(string name, string artist, string album, int sampleRate, int bitRate)
{
Name = name;
Artist = artist;
Album = album;
SampleRate = sampleRate;
BitRate = bitRate;
}
}
Now i want to editing some values foreach Track:
List<Track> TracksOniTunes = new List<Track>();
foreach (Track item in TracksOniTunes)
{
}
Later, i have a Switch and I need depending on different values to compare from the List
switch (criteria)
{
case "":
break;
case "Qualität":
break;
case "Album":
break;
case "Compilation":
break;
}
My Problem is that i can't editing some items?
I can not access the objects.
Is there an easy way?
Thanks for help.
|
|
|
|
|
Simple. In the line:
List<Track> TracksOniTunes = new List<Track>();
You are creating a brand new empty List. So when you get to
foreach (Track item in TracksOniTunes)
there is nothing in your list. You have to put something in your list before you can change its properties.
|
|
|
|
|
Just Add some items to the list TracksOniTunes. Then u can edit the inner values.
|
|
|
|
|
Sorry, here is the line that add a Track to the list
for (int countForTrack = countTracks; countForTrack > 0; countForTrack--)
{
currentTrack = tracks[countTracks] as IITFileOrCDTrack;
countTracks--;
TracksOniTunes.Add(new Track(currentTrack.Name, currentTrack.Artist, currentTrack.Album, currentTrack.SampleRate, currentTrack.BitRate));
}
|
|
|
|
|
Okay... since you say that there are actually items in your List, the problem becomes more clear. In your foreach you need to say
item.SampleRate = 0; But to get to the variables, you either need to make your class level variables public or create public properties for your class exposing those variables to outside that class.
modified 10-May-14 20:30pm.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
