Jump to content
Software FX Community

gaurav

Members
  • Posts

    5
  • Joined

  • Last visited

Posts posted by gaurav

  1. i am using a link.xml file to link the sql query returned to my map. My query returns 'United States' as countryname for USA whereas in the label link file (i.e link.xml) has svg text for USA assigned as <svgtext> U.S.A < / svgtext>

    i changed it to United States so that it my sql results get mapped on to the world countries map... but for united states it aint happening..

    is the white space between United and States the problem or am i allowed to define united states with a white space... ? please help .. this is urgent 

  2. can u please tell me why the data is not being reflected into the map..... the code is as follows

    string mySelectQuery = "select countryname,sum(ElectricityUse)as electricity from AcctRptdata,country where IdCountryCode=countrycode group by countryname";   SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=DEMO_2;Integrated Security=SSPI");   conn.Open();   SqlDataAdapter adapter = new SqlDataAdapter();   DataSet ds = new DataSet();   adapter.SelectCommand = new SqlCommand(mySelectQuery, conn);   adapter.Fill(ds,"AcctRptData,country");     chart1.DataSourceSettings.Fields.Add(new FieldMap("countryname", FieldUsage.Label));   chart1.DataSourceSettings.Fields.Add(new FieldMap("electrcity", FieldUsage.Value));   chart1.DataSource = ds.Tables[0];   chart1.ConditionalAttributes.Clear();   ConditionalAttributes condition1 = new ConditionalAttributes();   ConditionalAttributes condition2 = new ConditionalAttributes();   condition1.Condition.To = 1400000;   condition1.Color = Color.Green;   condition2.Color = Color.Red; condition2.Condition.From = 1400001;   condition2.Condition.To = 7200000;   chart1.ConditionalAttributes.Add(condition1);   chart1.ConditionalAttributes.Add(condition2);   chart1.ConditionalAttributes.Recalculate();   conn.Close();

×
×
  • Create New...