I am not too familiar with the server code you are using. Can you please point me to the server code that is throwing this error, or have a look there yourself to get some more information about the error.
Thanks ChartMan On Mon, Jul 5, 2010 at 9:37 PM, yc <[email protected]> wrote: > I am new to google visualization API. I need to implement dashboard > in application using google visualization API > i am trying to get the data from sql database to generate barcharts > in .net application. I am able to generate the charts using creating a > datable and adding the data to google visualization. > > > GoogleAPI.aspx.cs > > using GoogleVisualizationAPI; > > namespace GoogleChartAPI > { > public partial class GoogleAPI : System.Web.UI.Page > { > protected void Page_Load(object sender, EventArgs e) > { > DataTable dt3 = new DataTable(); > dt3.AddDataColumn(new DataColumn() { DataType = > DataType.String, Name = "Name" }); > dt3.AddDataColumn(new DataColumn() { DataType = > DataType.String, Name = "Manager" }); > dt3.AddDataColumn(new DataColumn() { DataType = > DataType.String, Name = "Tooltip" }); > dt3.AddDataCell(new DataCell() { Caption = "Alexander > Bykin", Value = new List<string> { "", "Perfect Programmer" } }); > dt3.AddDataCell(new DataCell() { Caption = "Steve > Ballmer", Value = new List<string> { "", "Microsoft General > President" } }); > dt3.AddDataCell(new DataCell() { Caption = "Scott > Guthrie", Value = new List<string> { "", "Vice president in the > Microsoft Developer Division." } }); > GVAPI.Visualization.Add(new Visualization() { Package = > VisualizationPackage.OrgChart, DataTable = dt3, DestObjectName = > this.visOrgChart.ID}); > } > } > } > > GoogleAPI.aspx > > > <%@ Register Assembly="GoogleVisualizationAPI" > Namespace="GoogleVisualizationAPI" > TagPrefix="gvapi" %> > > <!-- Import the GViz API --> > <script type="text/javascript" src="http://www.google.com/jsapi";></ > script> > > <!-- Load the columnchart GViz package. --> > <script type="text/javascript"> > google.load("visualization", "1.1", {packages: ["columnchart"]}); > </script> > > <body> > <gvapi:GoogleContainer ID="visOrgChart" ClassName="visualization" > runat="server" /> > </body> > > > But i need to get the data from database by connecting to SQL > database . > > SqlConnection conn = new SqlConnection("connstr"); > conn.Open(); > System.Data.DataSet thisDataSet = new > System.Data.DataSet(); > SqlDataAdapter orderAdapter = new SqlDataAdapter("Select > *", conn); > System.Data.DataTable datatable = thisDataSet.Tables[0]; > GVAPI.Visualization.Add(new Visualization() { Package = > VisualizationPackage.ColumnChart, DataTable = dt, DestObjectName = > this.visScatterChart.ID }); > > It is showing an error > > Cannot implicitly convert type 'System.Data.DataTable' to > 'GoogleVisualizationAPI.DataTable' > > Please help me.. > > > > Thank you, > > YC > > > > > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-visualization-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
