Amir Hoshang Kioumars: January 2015

Saturday, 31 January 2015

HTML5 JavaScript Charts

"An easy to use HTML5 JavaScript Charting library built on Canvas element. Charts can render across devices including iPhone, iPad, Android, Windows Phone, Desktops, etc. Graphs include several good looking themes and are 10x faster than conventional Flash / SVG based Libraries – resulting in lightweight, beautiful and responsive dashboards". more...

Here is my little ASP.NET program to draw a dynamic chart:

(These codes explains how to access JavaScripts function from codebehind and call codebehind functions from JavaScript)

Codebehind:

protected void Button1_Click(object sender, EventArgs e)
{
// Call JavaScript function in aspx
ScriptManager.RegisterStartupScript(this, GetType(), "draw", "draw();", true);
}
[WebMethod]
public static string chartType()
{
return "bar";
}
[WebMethod]
public static string labels()
{
return "apple,orange,banana,mango,grape";
}
[WebMethod]
public static string values()
{
return "10,20,30,40,50";
}

ASPX Page:

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript" src="scripts/canvasjs.min.js"></script>
<script type="text/javascript">
function draw() {
var t = '<%=labels()%>'; // get the values from codebhind method
var l = new Array();
l = t.split(",");
var t = '<%=values()%>';
var v = new Array();
v = t.split(",");
var data = [];
for (var x = 0; x < v.length; x++) {
data.push({
label: l[x],
y: parseInt(v[x]),
});
}
var chart = new CanvasJS.Chart("chartContainer", {
theme: "theme1",//theme1
title: {
text: "Basic Column Chart - CanvasJS"
},
animationEnabled: false, // change to true
data: [
{
// Change type to "bar", "splineArea", "area", "spline", "pie",etc.
type: '<%=chartType()%>',
dataPoints: data
}
]
});
chart.render();
}
</script>
<script type="text/javascript" src="/assets/script/canvasjs.min.js"></script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="ScriptManager1" EnablePageMethods="true" EnablePartialRendering="true" runat="server" />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
</div>
<div id="chartContainer" style="height: 300px; width: 100%;"></div>
</form>
</body>
</html>

Wednesday, 28 January 2015

Windows 7 Slow Boot and Long Delay Time on Startup After Installing SSD

After installing the Windows 7 x64 on a machine with new Solid State Disk, Windows works slower than usual and has long delay on login screen. To overcome this problem, install the following update:

Monday, 26 January 2015

Limited WiFi Connection Problem in Windows 8.1

After installing the Windows 8.1, wireless connection keep dropping saying "Limited Connectivity". To resolve this issue:

Open "Command Prompt" as administrator and issue the following commands in sequence:

    1. netsh int tcp set heuristics disabled
    2. netsh int tcp set global autotuninglevel=disabled
    3. netsh int tcp set global rss=enabled
    4. netsh int tcp show global
    5. Restart the computer

Thursday, 22 January 2015

Enable Remote Connections for SQL Server Express 2012

Run SQL Server Configuration Manager.
Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
Make sure TCP/IP is enabled.

Then,

Right-click on TCP/IP and select Properties.
Verify that, under IP2, the IP Address is set to the computer's IP address on the local subnet.
Scroll down to IPAll.
Make sure that TCP Dynamic Ports is blank. (Mine was set to some 5-digit port number.)
Make sure that TCP Port is set to 1433. (Mine was blank.)

If follow these steps, it's not necessary to enable SQL Server Browser, and only need to allow port 1433, not 1434

After all, go to Windows Service Manager and RESTART the SQL SERVER service to apply the changes.

Wednesday, 21 January 2015

Soild State Hard Disk Performs Very Slow in Windows 8.1

To fix this problem, execute the following command and restart the computer:

Start > Run > Winsat Format

Sunday, 18 January 2015

Opening Excel File using Task Scheduler

It might be the DCOM permissions issue. One solution is to set Excel to run as a specific user through DCOM permissions.

Open Component Services: Start > Run > DComcnfg
Drill down to: Component Services > Computers > My Computer > DCOM Config
Right-click on 'Microsoft Excel Application' and choose Properties
In the 'Identity Tab', select 'This User' and enter the username and password of an interactive user account (domain or local) and then click Ok

Keeping it as the interactive user or the launching doesn't work with the task scheduler, even when setting the task to run under an account that has admin rights to the machine.

Tuesday, 13 January 2015

React

A JavaScript library for building user interfaces. more...

Bootstrap

Bootstrap is the most popular HTML, CSS, and JS framework for developing responsive, mobile first projects on the web. more...

Amir Hoshang Kioumars