draw graph with mschart by splting data

Question

User923723782 posted

hi all.i am working on a project which is for drawing a graph with data that are comming from n instrument that measures decible of the place. i want to store the measurements in my database bue the question is here: my database has just two columns.one is PK and its name is graphid and is for setting the number of the graph,ex :graph number one has graphid=1 and so on.so when for every test(one graphid) i want to store the decibles in another column with "decible" name.but i want to store decible measures like this: 12,45,56,67,...i mean i want to store them in just one column and seperate it with comma..please jelp me how i can store the data like this and how to read it? i know  string.split but i do not know how to use it and how to assign it to my Yvauenumber of my chart. plereease help me.i am in trouble.

thanks

Answer 1

User-2074802862 posted

 ok

u can do in this way 

first stored ur value in one strin say s1

then create string array s2 

say 

dim s2 as string[]=s1.split( ',' )

now use for loop to attach this values to graph in this way

for i =0 to s2.length

chart.Data.Add(New WebChart.ChartPoint( i+1&"position value", s2[i]))

next

Answer 2

User923723782 posted

ity is in vb  i am a c# programmer ,i tried to convert it, but something is wrong,there is no chart.data.add.......  i could not  figure it out,could you please help me in c#.thanks

Answer 3

User854688209 posted

string strValue ="12,45,56,67";

string[] arrStr = strValue.Split(',');

for(int i = 0;i <=arrStr.Length; i++)
{
      myChart.Data.Add(new WebChart.ChartPoint(i.ToString(), arrStr[i]))
}

Refer below links to know more:

http://www.carlosag.net/Tools/WebChart/sampleCode.aspx

http://www.carlosag.net/Tools/WebChart/imagelinemarker.aspx

Answer 4

User923723782 posted

i anm working on windows application and the webchart is webchart and it errors me to missing namespaces.also i am using mschart control,couldn1t i assign the arraylist(arrStr) to my mschart control?help me how.i tried this code:

chart1.Series["Series1"].YValueMembers = "arrStr" but it does not help and show me aan empty chart.help pleeeeeeeeease.

Answer 5

User854688209 posted

Try this;

string strValue ="12,45,56,67";

string[] arrStr = strValue.Split(',');

for(int i = 0;i <=arrStr.Length; i++)
{
      chart1.Series["Series1"].YValueMembers = arrStr[i];

} 

 

Answer 6

User-2074802862 posted

 have u add Chart.dll file in ur toolbox ......

add it first and then drop down that controll in ur design view ,it will work 

and code for the c# is below

string s1;

string [] s2=s1.split( ' , ' ) ;

for (int i=0; i< s1.length ;i++)

{

  chart.Data.Add(New WebChart.ChartPoint(i.tostring+"Posion",s2[i]));
  }

i hop this will help you

Answer 7

User923723782 posted

hi.i tried it but it error me this at the last line: Index was outside the bounds of the array.

is anyone test it before?i really confused what should i do

Answer 8

User854688209 posted

 My mistake, i have corrected it and marked it as bold

string strValue ="12,45,56,67";

string[] arrStr = strValue.Split(',');

for(int i = 0;i <=arrStr.Length - 1; i++)
{
      chart1.Series["Series1"].YValueMembers = arrStr[i];

}

 

Answer 9

User923723782 posted

i test it again but it show me a blank white  chart without axis and anything,i think there is something missing.i have to say that this code is working for a double array:

double [] array = { 2.8, 4.4, 6.5, 8.3, 3.6, 5.6, 7.3, 9.2, 1.0};

// Bind the double array to the Y axis points of the data series.

Chart1.Series["Series1"].Points.DataBindY(array);

 but about my daa that is string and coming from database i don`t know.!!!!!!!!!!!!!!!!

Answer 10

User854688209 posted

 If double is working, loop throug string and converting the data in double.

Answer 11

User-2074802862 posted

 make it S2.length-1 in for loop

Answer 12

User923723782 posted

what do you mean of s2.Lenght-1  ?what is s2? if you mean my array , i have done it like this :

for(i=0;i<=arrstr.Lenght-1;i++)

but it shows me an empty chart.i do not know what to do more? 

Answer 13

User-2074802862 posted

  i just want to know that ur using asp.net2.0 or 3.5

 next if ur using asp.net2.0 then u have to add chartcontoll.dll file ok 

 if ur using asp.net 2.0 give ur email id will mail u the  Graphcontroll.dll that i have

and for 3.5 i m sorry i m still using asp.net 2.0

THIS IS tested Code and Giving me the graph

protected void Page_Load(object sender, EventArgs e)
    {
        string s1 = "12,10,13,20,100";
        string[] ss = s1.Split(',');
        WebChart.ColumnChart chart=new WebChart.ColumnChart() ;
        for (int i = 0; i < ss.Length - 1; i++)
        {
            float f_num = float.Parse(ss[i]);

            chart.Data.Add(new WebChart.ChartPoint(Convert.ToString(i), f_num));
          
        }
        
            ChartControl1.Charts.Add(chart);
            ChartControl1.RedrawChart();
    }

Answer 14

User923723782 posted

hi and thank you all.i solved my problem with this:

string st ="12,45,56,67"; // comes from database

string [] arrString = st.Split(new char[] {','});

double[] arrDouble = new double[arrString.Length];for(int i=0; i<arrString.Length; i++)

{

arrDouble[i] = double.Parse(arrString[i]);

}

chart1.Series["Series1"].Points.DataBindY(arrDouble);

chart1.Series["Series1"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;

 it draw a line chart for me.thank you all for your help and time.

Answer 15

User854688209 posted

 Hi narina,

Please mark the post as answer which helped you in resolving the issue, so that other can refer for same kind of issue.

Answer 16

User-468310695 posted

hi i want to draw graph for that i required dllthis is my mail id [e-mail] 

is it possible to find the area between two lines

do need full