Jaya, I can't do much with your aspx and C# code except makes lots of guesses. It would be better if you could either point to a page, or view the source of the page and post that. You can email me directly if you don't want to make it public.
On Tue, Jun 2, 2015 at 4:37 PM, Jaya <[email protected]> wrote: > Thanks Daniel. I went through the links you had posted. Looks like the > examples show how to connect to excel sheets. I would like to use the php > example and mimic that to connect to the SQL Server database. But that > din't work because the example is using MySQL database and has mysql > connection objects. Wasn't sure what would be the sql server connection > objects to connect to a SQL Server. > > I also tried using asp.net. My dataset is pulling the values from the > database but doesn't the page is blank. Below is what I took from one of > the forums. Can you please check and let me know what am I doing wrong. > > aspx: > > <asp:Literal ID="lt" runat="server"></asp:Literal> > <div id="chart_div" style="width: 550px; height: 400px;"></div> > > C#: > > public partial class _Default : System.Web.UI.Page > { > protected void Page_Load(object sender, EventArgs e) > { > if (Page.IsPostBack == false) > { > BindBarChart(); > } > } > private DataTable GetBarData() > { > DataTable dt = new DataTable(); > using (SqlConnection conn = new > SqlConnection(@"server=servername;uid=username;pwd=password;database=databasename")) > { > string cmd = "select UserID, UserFName from Users with(nolock)"; > SqlDataAdapter adp = new SqlDataAdapter(cmd, conn); > adp.Fill(dt); > return dt; > } > } > > private void BindBarChart() > { > StringBuilder str = new StringBuilder(); > DataTable dt = new DataTable(); > > try > { > dt = GetBarData(); > str.Append(@"<script type=text/javascript> google.load( > *visualization*, *1*, {packages:[*Table*]}); > google.setOnLoadCallback(drawChart); > > function drawChart() { > var data = new google.visualization.DataTable(); > data.addColumn('number', 'UserID'); > data.addColumn('string', 'UserFName'); > data.addRows(" + dt.Rows.Count + ");"); > > for (int i = 0; i <= dt.Rows.Count - 1; i++) > { > str.Append("data.setValue( " + i + "," + 1 + "," + "'" + > dt.Rows[i]["UserID"].ToString() + "');"); > str.Append("data.setValue(" + i + "," + 0 + "," + > dt.Rows[i]["UserFName"].ToString() + ") ;"); > } > > str.Append("var chart = new > google.visualization.Table(document.getElementById('chart_div'));"); > str.Append("chart.draw(data, {title:'Report'"); > //str.Append("vAxis: { title: 'Client', titleTextStyle: { > color: 'red' } }"); > str.Append("}); }"); > str.Append("</script>"); > lt.Text = str.ToString().TrimEnd(',').Replace('*', '"'); > } > catch (Exception e) { throw e; } > } > > } > > > Thanks again! > >> >> -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> - 978-394-1058 [email protected] <[email protected]> 5CC, Cambridge MA [email protected] <[email protected]> 9 Juniper Ridge Road, Acton MA -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
