Comments by naveenreddychennam

naveenreddychennam 25-Sep-13 5:28am View

I dont want aggegation function.... just to change rows to columns....

naveenreddychennam 25-Sep-13 5:17am View

Can u Apply to My table... I not getting for my table..

naveenreddychennam 3-Sep-13 5:51am View

ASPX Page:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>jVectorMap demo</title>
<link rel="stylesheet" media="all" href ="Styles/jquery-jvectormap.css"/>
<script src="assets/jquery-1.8.2.js"></script>
<script src="assets/jquery-jvectormap.js"></script>
<script src="assets/jquery-mousewheel.js"></script>

<script src="assets/jvectormap.js"></script>

<script src="assets/abstract-element.js"></script>
<script src="assets/abstract-canvas-element.js"></script>
<script src="assets/abstract-shape-element.js"></script>

<script src="assets/svg-element.js"></script>
<script src="assets/svg-group-element.js"></script>
<script src="assets/svg-canvas-element.js"></script>
<script src="assets/svg-shape-element.js"></script>
<script src="assets/svg-path-element.js"></script>
<script src="assets/svg-circle-element.js"></script>

<script src="assets/vml-element.js"></script>
<script src="assets/vml-group-element.js"></script>
<script src="assets/vml-canvas-element.js"></script>
<script src="assets/vml-shape-element.js"></script>
<script src="assets/vml-path-element.js"></script>
<script src="assets/vml-circle-element.js"></script>

<script src="assets/vector-canvas.js"></script>
<script src="assets/simple-scale.js"></script>
<script src="assets/numeric-scale.js"></script>
<script src="assets/ordinal-scale.js"></script>
<script src="assets/color-scale.js"></script>
<script src="assets/data-series.js"></script>
<script src="assets/proj.js"></script>
<script src="assets/world-map.js"></script>

<script src="assets/jquery-jvectormap-world-mill-en.js"></script>
<script>
jQuery.noConflict();
jQuery(function () {
var $ = jQuery;

$('#map1').vectorMap({
map: 'world_mill_en',
focusOn: {
x: 0.5,
y: 0.5,
scale: 2
},
series: {
regions: [{
scale: ['#C8EEFF', '#0071A4'],
normalizeFunction: 'polynomial',
values: {
"AF": 100,
"AL": 200,
"DZ": 50,
"IN": 500,
}
}]
}
});
})
</script>

</head>
<body>
<form id="form1" runat="server">
<div id="map1" style="width: 600px; height: 400px"></div>
</form>
</body>
</html>

Aspx.Cs:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=x001;Initial Catalog=Test;User ID=sa;Password=x@123");
protected void Page_Load(object sender, EventArgs e)
{

}
[WebMethod]
public List<datarow> GetCountries()
{
SqlCommand cmd = new SqlCommand("Select * from tbl_Countries", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
da.Fill(dt);
List<datarow> list = dt.AsEnumerable().ToList();
return list;
}

}

naveenreddychennam 3-Sep-13 5:47am View

Give me Your mail Id i will send the code ?

naveenreddychennam 3-Sep-13 5:11am View

ID int
Country varchar(50)
RegistrationNO int

I have a table like above and iam getting values from databse(sqlserver) but how can i send the countryname and registrationno from .Cs file to JavaScript. and that values should be accepted through json format. for binding Jvectormap

Comments by naveenreddychennam (Top 5 by date)