Dynamically generated data type for google time annotated string
I want to use google annotated timeline visualization . It is very easy to do this by manually adding rows for the column and row data. This is all done using the google.visualization.DataTable () attributes. I would like to dynamically update this data table, but I don’t know how. The data is on a server with MS SQL Server 2005.
I found a post to accomplish this with PHP and MySQL, but I don't know how to translate this to VB.NET or C # (either good).
Does anyone know how to use MS SQL Server data in .NET or is it better to use dynamically generated code so new data doesn't need to add rows manually every time?
Thank!
source to share
I know this is an old post, but take a look at http://www.panterlo.com/2010/10/17/google-visualization-api-gets-easy-with-net-mvc/ which states what I have released a class library available on github (GPL v3) that you can use for this purpose.
source to share
You can use the post you mentioned to help you write this code in PHP, but use PHP ODBC functions ( http://us3.php.net/odbc ) to access the data in MSSQL Server instead of the examples shown when accessing the database MySQL data.
$connectionstring = odbc_connect($db, $user, $pass) or die("Connection Failed");
$query = "...";
$result = odbc_do($connectionstring, $query) or die("Query Failed");
Sorry it doesn't help you with .NET or C #.
source to share