I'm working on a line chart using Chartjs and I'm getting a error from my webservice. Here is the code for the service:

[WebMethod]
    public List<object> getProgram12Months(string use,c#,web-services,chart.js"/>
	














    

		

        

            
            时间戳
        

		

		

        
		

    
















	
首页  > 解决方案 > 退货清单 from webservice

I'm working on a line chart using Chartjs and I'm getting a error from my webservice.  Here is the code for the service:



[WebMethod]
    public List<object> getProgram12Months(string use












c# - 退货清单 from webservice

I'm working on a line chart using Chartjs and I'm getting a error from my webservice.  Here is the code for the service:



[WebMethod]
    public List<object> getProgram12Months(string use





问题描述



I'm working on a line chart using Chartjs and I'm getting a error from my webservice.  Here is the code for the service:



[WebMethod]
    public List<object> getProgram12Months(string usersessionid)
    {
        List<object> iData = new List<object>();
        List<string> labels = new List<string>();

        //First get distinct Month Name for select Year.
        string query1 = "SELECT DISTINCT TOP (100) PERCENT TimeFrame FROM dbo.CSQ_ProgramCount12Months ORDER BY TimeFrame ";

        string conn = ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;
        SqlDataAdapter dap = new SqlDataAdapter(query1, conn);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        DataTable dtLabels = ds.Tables[0];


        foreach (DataRow drow in dtLabels.Rows)
        {
            labels.Add(drow["TimeFrame"].ToString());
        }
        iData.Add(labels);

        return iData;
    }




When I call the method from a browser I get the following error:




  
System.InvalidOperationException: There was an error generating the
  XML document. ---> System.InvalidOperationException: The type
  System.Collections.Generic.List`1[[System.String, mscorlib,
  Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]
  may not be used in this context.





I'm basing it off this.









List is not serializable to web method instead of this you can return object[].



[WebMethod]
    public object[] getProgram12Months(string usersessionid)
    {
        List<object> iData = new List<object>();
        List<string> labels = new List<string>();

        //First get distinct Month Name for select Year.
        string query1 = "SELECT DISTINCT TOP (100) PERCENT TimeFrame FROM dbo.CSQ_ProgramCount12Months ORDER BY TimeFrame ";

        string conn = ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;
        SqlDataAdapter dap = new SqlDataAdapter(query1, conn);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        DataTable dtLabels = ds.Tables[0];


        foreach (DataRow drow in dtLabels.Rows)
        {
            labels.Add(drow["TimeFrame"].ToString());
        }
        iData.Add(labels.ToArray());

        return iData.ToArray();
    }



标签： c#web-serviceschart.js


解决方案









I resolved this by creating two classes an populating them.  Thank you er-sho, your posts help lead me in the right direction.  



public class ChartData2
    {
        public List<string> Legends;
        public List<int> AD;


    }

    public class Legend
    {
        public List<string> Months;
    }











推荐阅读