This question is locked. New answers and comments are not allowed.
hi!
i used webservices to bind data in telerik tree i have three tables i want to connect each other i dont understand
how to do this i got a example in the forum i did some work on it
please used it and tell me how to assign the datasource to bind the hierarchical tree i am sending some code here
Regards,
noman
i am using SectionsDataSource please read and help or send me any example like that want to create hierarchical tree using
this webservice that are given below:
its my example.xaml
<UserControl x:Class="SLCareerM3.Example"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:telerik="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls"
xmlns:telerikNavigation="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.Navigation"
xmlns:local="clr-namespace:SLCareerM3" Width="400" Height="300">
<UserControl.Resources>
<local:SectionsDataSource x:Key="MyList" />
<DataTemplate x:Key="section82">
<TextBlock Text="{Binding Name}" />
</DataTemplate>
<telerik:HierarchicalDataTemplate x:Key="section81" ItemTemplate="{StaticResource section82}"
ItemsSource="{Binding section82s}">
<TextBlock Text="{Binding Name}" />
</telerik:HierarchicalDataTemplate>
<telerik:HierarchicalDataTemplate x:Key="section8" ItemTemplate="{StaticResource section81}"
ItemsSource="{Binding section81s}">
<TextBlock Text="{Binding Name}" />
</telerik:HierarchicalDataTemplate>
</UserControl.Resources>
<Grid>
<telerikNavigation:RadTreeView Height="300" Width="300"
ItemsSource="{Binding Source={StaticResource MyList}}"
ItemTemplate="{StaticResource section8}" />
</Grid>
</UserControl>
its my Example.cs
namespace SLCareerM3
{
public partial class Example : UserControl
{
public Example()
{
InitializeComponent();
//Loaded += new RoutedEventHandler(UserControl_Loaded);
}
}
public class section8
{
//public string headingid { get; set; }
public string headingname { get; set; }
public section8(string name)
{
_name = name;
_section81 = new List<section81>();
}
string _name;
public string Name { get { return _name; } }
List<section81> _section81;
public List<section81> section81s { get { return _section81; } }
}
public class section81
{
//public string sub_heading_id1 { get; set; }
public string heading_id1 { get; set; }
public string sub_heading_name1 { get; set; }
public section81(string name)
{
_name = name;
_section82 = new List<section82>();
}
string _name;
public string Name { get { return _name; } }
List<section82> _section82;
public List<section82> section82s { get { return _section82; } }
}
public class section82
{
//public string detail_id2 { get; set; }
public string sub_heading_id2 { get; set; }
public string Heading_id2 { get; set; }
public string detail_text2 { get; set; }
public section82(string name)
{
_name = name;
}
string _name;
public string Name { get { return _name; } }
}
public class SectionsDataSource : List<section8>
{
List<Asection8> sectionList = new List<Asection8>();
List<Asection81> sectionList1 = new List<Asection81>();
List<Asection82> sectionList2 = new List<Asection82>();
public class Asection8
{
public string headingid { get; set; }
public string headingname { get; set; }
}
public class Asection81
{
public string sub_heading_id1 { get; set; }
public string heading_id1 { get; set; }
public string sub_heading_name1 { get; set; }
}
public class Asection82
{
public string detail_id2 { get; set; }
public string sub_heading_id2 { get; set; }
public string Heading_id2 { get; set; }
public string detail_text2 { get; set; }
}
void UserControl_Loaded(object sender, RoutedEventArgs e)
{
BasicHttpBinding bind = new BasicHttpBinding();
bind.MaxReceivedMessageSize = 2147483647;
bind.MaxBufferSize = 2147483647;
//EndpointAddress endpoint = new EndpointAddress("http://localhost:51103/serviceTest_Web/myService.asmx");theSercice.myServiceSoapClient textureSoapClient = new serviceTest.theSercice.myServiceSoapClient(bind, endpoint);
//textureSoapClient.RetrieveTextureAsync();
//EndpointAddress endpoint = new EndpointAddress("http://localhost:51103/serviceTest_Web/myService.asmx"); theSercice.myServiceSoapClient textureSoapClient = new serviceTest.theSercice.myServiceSoapClient(bind, endpoint);
//textureSoapClient.RetrieveTextureAsync();
//textureSoapClient.RetrieveTextureCompleted += new EventHandler(textureSoapClient_RetrieveTextureCompleted);
EndpointAddress endpoint = new EndpointAddress("http://localhost:1258/CareerM/Profile.asmx");
//http://www.emmaculate.com/CareerM/
//EndpointAddress endpoint = new EndpointAddress("http://www.emmaculate.com/CareerM/Profile.asmx");
ServiceProfile3.ProfileSoapClient textureSoapClient = new ServiceProfile3.ProfileSoapClient(bind, endpoint);
textureSoapClient.RetrieveTreeAsync();
//.RetrieveTextureAsync();
textureSoapClient.RetrieveTreeCompleted +=
new EventHandler<ServiceProfile3.RetrieveTreeCompletedEventArgs>(textureSoapClient_RetrieveTreeCompleted);
//textureSoapClient.RetrieveTextureCompleted +=
//new EventHandler<serviceTest.theSercice.RetrieveTextureCompletedEventArgs>(textureSoapClient_RetrieveTextureCompleted);
}
void textureSoapClient_RetrieveTreeCompleted(object sender, ServiceProfile3.RetrieveTreeCompletedEventArgs e)
{
if (e.Error == null)
displayData(e.Result);
}
void displayData(string xmlContent)
{
try
{
if (xmlContent != string.Empty)
{
XDocument xmlSections = XDocument.Parse(xmlContent);
// #region 0
var sections = from section8 in xmlSections.Descendants("section8")
select new
{
headingid = (string)section8.Element("headingid").Value.PadLeft(10, '0'),
headingname = (string)section8.Element("headingname").Value.PadLeft(10, '0')
};
var sections1 = from section81 in xmlSections.Descendants("section81")
select new
{
sub_heading_id1 = (string)section81.Element("sub_heading_id1").Value.PadLeft(10, '0'),
heading_id1 = (string)section81.Element("headingid1").Value.PadLeft(10, '0'),
subheadingname1 = (string)section81.Element("sub_heading_name1").Value.PadLeft(10, '0'),
//txPath = (string)"http://www.texturearchive.com/thumbs/" + texture.Element("class1").Value + "/" + texture.Element("class2").Value + "/" + texture.Element("item").Value.PadLeft(10, '0') + "_" + texture.Element("Artist").Value.PadLeft(10, '0') + "_tn.jpg",
// detailtext1 = (string)section81.Element("detailtext1").Value.PadLeft(10, '0')
};
var sections2 = from section82 in xmlSections.Descendants("section82")
select new
{
detailid2 = (string)section82.Element("detail_id2").Value.PadLeft(10, '0'),
sub_heading_id2 = (string)section82.Element("sub_heading_id2").Value.PadLeft(10, '0'),
heading_id2 = (string)section82.Element("heading_id2").Value.PadLeft(10, '0'),
//subheadingname2 = (string)section82.Element("subheadingname2").Value.PadLeft(10, '0'),
detailtext2 = (string)section82.Element("detail_text2").Value.PadLeft(10, '0')
};
//Bug: http://silverlight.net/forums/t/11147.aspx
//List<Asection8> sectionList = new List<Asection8>();
foreach (var t in sections)
{
Asection8 pdt = new Asection8 { headingid = t.headingid, headingname = t.headingname };
sectionList.Add(pdt);
}
//List<Asection81> sectionList1 = new List<Asection81>();
foreach (var t in sections1)
{
Asection81 pdt1 = new Asection81 { heading_id1 = t.heading_id1, sub_heading_id1 = t.sub_heading_id1, sub_heading_name1 = t.subheadingname1 };
sectionList1.Add(pdt1);
}
// List<Asection82> sectionList2 = new List<Asection82>();
foreach (var t in sections2)
{
Asection82 pdt2 = new Asection82 { Heading_id2 = t.heading_id2, sub_heading_id2 = t.sub_heading_id2, detail_id2 = t.detailid2, detail_text2 = t.detailtext2 };
sectionList2.Add(pdt2);
}
//string text="";
//for (int a=0;a<= int.Parse(sectionList.Count.ToString()) ; a++)
//{
// for (int b=0;b<= int.Parse(sectionList1.Count.ToString()) ; b++)
// {
// for (int c=0;c<= int.Parse(sectionList2.Count.ToString()) ; c++)
// {
// section8 l;
// section81 d;
// Add(l = new section8(sectionList1[0].ToString() ));
// l.section81s.Add((d = new section81(sectionList2[0].ToString())));
// d.section82s.Add(new section82(sectionList[0].ToString()));
// }
// }
//}
//#endregion
// texturesDataGrid.ItemsSource = texturesList;
//CustomersGrid.ItemsSource = profilesList;
//RadTreeViewItem item = new RadTreeViewItem();
// item.ItemsSource = sectionList;
//item.DataContext = sectionList;
//RadTreeView rd = new RadTreeView();
//rd.DataContext = sectionList;
}
else
{
//errMessage.Visibility = Visibility.Visible;
//texturesDataGrid.ItemsSource = null;
//CustomersGrid.ItemsSource = null;
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
}
public SectionsDataSource()
{
// RoutedEventHandler Loaded;
// Loaded +=new RoutedEventHandler(UserControl_Loaded);
//// RoutedEventHandler += new RoutedEventHandler(UserControl_Loaded);
// UserControl_Loaded();
//how to load first webservice to load the data ?
string text = "";
for (int a = 0; a <= int.Parse(sectionList.Count.ToString()); a++)
{
for (int b = 0; b <= int.Parse(sectionList1.Count.ToString()); b++)
{
for (int c = 0; c <= int.Parse(sectionList2.Count.ToString()); c++)
{
section8 l;
section81 d;
Add(l = new section8(sectionList1[0].ToString()));
l.section81s.Add((d = new section81(sectionList2[0].ToString())));
d.section82s.Add(new section82(sectionList[0].ToString()));
}
}
}
//section8 l;
//section81 d;
//Add(l = new section8("1"));
//l.section81s.Add((d = new section81("1")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
//d.section82s.Add(new section82("4"));
//d.section82s.Add(new section82("5"));
//l.section81s.Add((d = new section81("2")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
//d.section82s.Add(new section82("4"));
//d.section82s.Add(new section82("5"));
//l.section81s.Add((d = new section81("3")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
//d.section82s.Add(new section82("4"));
//Add(l = new section8("2"));
//l.section81s.Add((d = new section81("1")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
//l.section81s.Add((d = new section81("2")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
//d.section82s.Add(new section82("4"));
//l.section81s.Add((d = new section81("3")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
}
}
public class League
{
public League(string name)
{
_name = name;
_divisions = new List<Division>();
}
string _name;
public string Name { get { return _name; } }
List<Division> _divisions;
public List<Division> Divisions { get { return _divisions; } }
}
public class Division
{
public Division(string name)
{
_name = name;
_teams = new List<Team>();
}
string _name;
public string Name { get { return _name; } }
List<Team> _teams;
public List<Team> Teams { get { return _teams; } }
}
public class Team
{
public Team(string name)
{
_name = name;
}
string _name;
public string Name { get { return _name; } }
}
public class LeaguesDataSource : List<League>
{
public LeaguesDataSource()
{
League l;
Division d;
Add(l = new League("League A"));
l.Divisions.Add((d = new Division("Division A")));
d.Teams.Add(new Team("Team I"));
d.Teams.Add(new Team("Team II"));
d.Teams.Add(new Team("Team III"));
d.Teams.Add(new Team("Team IV"));
d.Teams.Add(new Team("Team V"));
l.Divisions.Add((d = new Division("Division B")));
d.Teams.Add(new Team("Team Blue"));
d.Teams.Add(new Team("Team Red"));
d.Teams.Add(new Team("Team Yellow"));
d.Teams.Add(new Team("Team Green"));
d.Teams.Add(new Team("Team Orange"));
l.Divisions.Add((d = new Division("Division C")));
d.Teams.Add(new Team("Team East"));
d.Teams.Add(new Team("Team West"));
d.Teams.Add(new Team("Team North"));
d.Teams.Add(new Team("Team South"));
Add(l = new League("League B"));
l.Divisions.Add((d = new Division("Division A")));
d.Teams.Add(new Team("Team 1"));
d.Teams.Add(new Team("Team 2"));
d.Teams.Add(new Team("Team 3"));
d.Teams.Add(new Team("Team 4"));
d.Teams.Add(new Team("Team 5"));
l.Divisions.Add((d = new Division("Division B")));
d.Teams.Add(new Team("Team Diamond"));
d.Teams.Add(new Team("Team Heart"));
d.Teams.Add(new Team("Team Club"));
d.Teams.Add(new Team("Team Spade"));
l.Divisions.Add((d = new Division("Division C")));
d.Teams.Add(new Team("Team Alpha"));
d.Teams.Add(new Team("Team Beta"));
d.Teams.Add(new Team("Team Gamma"));
d.Teams.Add(new Team("Team Delta"));
d.Teams.Add(new Team("Team Epsilon"));
}
}
}
mywebservice
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using MySql.Data;
using MySql;
using MySql.Data.MySqlClient;
using System.Text;
using System.ServiceModel.Configuration;
using System.ServiceModel.Activation;
using System.Security.Principal;
using System.Web.Configuration;
using System.Configuration;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
/// <summary>
/// Summary description for Profile
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class Profile : System.Web.Services.WebService
{
public Profile()
{
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod(EnableSession = true)]
public string RetrieveTree()
{
try
{
MySqlConnection _mysqlConnection = new MySqlConnection();
_mysqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings["CMMysql"].ToString();
_mysqlConnection.Open();
// //8education
string userid = "";
string profileid = "";
if (HttpContext.Current.Session["Userid"].ToString() == "" || HttpContext.Current.Session["Userid"].ToString() == null)
userid = "1";
else
userid = HttpContext.Current.Session["Userid"].ToString();
if (HttpContext.Current.Session["Profileid"].ToString() == "" || HttpContext.Current.Session["Profileid"].ToString() == null)
profileid = "4";
else
profileid = HttpContext.Current.Session["Profileid"].ToString();
//8//education
MySqlDataAdapter da = new MySqlDataAdapter();
//da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=8 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
da.SelectCommand = new MySqlCommand("select * from tbl_heading where section_id=8 and user_id = " + userid + " and th.profile_id= " + profileid, _mysqlConnection);
DataSet ds = new DataSet();
da.Fill(ds);
//8//education
MySqlDataAdapter da1 = new MySqlDataAdapter();
//da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=8 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
da1.SelectCommand = new MySqlCommand("select * from tbl_sub_heading", _mysqlConnection);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
//8//education
MySqlDataAdapter da2 = new MySqlDataAdapter();
//da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=8 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
da2.SelectCommand = new MySqlCommand("select * from tbl_heading_details", _mysqlConnection);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
////1//7experience
//MySqlDataAdapter da1 = new MySqlDataAdapter();
////da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da1.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=7 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
//DataSet ds1 = new DataSet();
//da1.Fill(ds1);
////2//4Achievement
////3//9recomendation
////4//10links
////5 //3careerhighlights
////2//4Achievement
//MySqlDataAdapter da2 = new MySqlDataAdapter();
////da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da2.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=4 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
//DataSet ds2 = new DataSet();
//da2.Fill(ds2);
////3//9recomendation
//MySqlDataAdapter da3 = new MySqlDataAdapter();
////da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da3.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=9 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
//DataSet ds3 = new DataSet();
//da3.Fill(ds3);
////4//10links
//MySqlDataAdapter da4 = new MySqlDataAdapter();
////da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da4.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=10 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
//DataSet ds4 = new DataSet();
//da4.Fill(ds4);
////5 //3careerhighlights
//MySqlDataAdapter da5 = new MySqlDataAdapter();
////da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da5.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=3 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
//DataSet ds5 = new DataSet();
//da5.Fill(ds5);
StringBuilder sb = new StringBuilder();
sb.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
sb.Append("<sections>");
foreach (DataRow dr in ds.Tables[0].Rows)
{
sb.Append("<section8>");
sb.Append("<headingid>");
sb.Append(dr[0].ToString());
sb.Append("</headingid>");
sb.Append("<headingname>");
sb.Append(dr[1].ToString());
sb.Append("</headingname>");
sb.Append("</section8>");
}
foreach (DataRow dr1 in ds1.Tables[0].Rows)
{
sb.Append("<section81>");
sb.Append("<sub_heading_id1>");
sb.Append(dr1[0].ToString());
sb.Append("</sub_heading_id1>");
sb.Append("<headingid1>");
sb.Append(dr1[1].ToString());
sb.Append("</headingid1>");
sb.Append("<sub_heading_name1>");
sb.Append(dr1[2].ToString());
sb.Append("</sub_heading_name1>");
sb.Append("</section81>");
}
foreach (DataRow dr2 in ds2.Tables[0].Rows)
{
sb.Append("<section82>");
sb.Append("<detail_id2>");
sb.Append(dr2[0].ToString());
sb.Append("</detail_id2>");
sb.Append("<sub_heading_id2>");
sb.Append(dr2[1].ToString());
sb.Append("</sub_heading_id2>");
sb.Append("<Heading_id2>");
sb.Append(dr2[2].ToString());
sb.Append("</Heading_id2>");
sb.Append("<detail_text2>");
sb.Append(dr2[4].ToString());
sb.Append("</detail_text2>");
sb.Append("</section82>");
}
sb.Append("</sections>");
_mysqlConnection.Close();
return sb.ToString();
}
catch (Exception ex)
{
return string.Empty;
}
}
}
i used webservices to bind data in telerik tree i have three tables i want to connect each other i dont understand
how to do this i got a example in the forum i did some work on it
please used it and tell me how to assign the datasource to bind the hierarchical tree i am sending some code here
Regards,
noman
i am using SectionsDataSource please read and help or send me any example like that want to create hierarchical tree using
this webservice that are given below:
its my example.xaml
<UserControl x:Class="SLCareerM3.Example"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:telerik="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls"
xmlns:telerikNavigation="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.Navigation"
xmlns:local="clr-namespace:SLCareerM3" Width="400" Height="300">
<UserControl.Resources>
<local:SectionsDataSource x:Key="MyList" />
<DataTemplate x:Key="section82">
<TextBlock Text="{Binding Name}" />
</DataTemplate>
<telerik:HierarchicalDataTemplate x:Key="section81" ItemTemplate="{StaticResource section82}"
ItemsSource="{Binding section82s}">
<TextBlock Text="{Binding Name}" />
</telerik:HierarchicalDataTemplate>
<telerik:HierarchicalDataTemplate x:Key="section8" ItemTemplate="{StaticResource section81}"
ItemsSource="{Binding section81s}">
<TextBlock Text="{Binding Name}" />
</telerik:HierarchicalDataTemplate>
</UserControl.Resources>
<Grid>
<telerikNavigation:RadTreeView Height="300" Width="300"
ItemsSource="{Binding Source={StaticResource MyList}}"
ItemTemplate="{StaticResource section8}" />
</Grid>
</UserControl>
its my Example.cs
namespace SLCareerM3
{
public partial class Example : UserControl
{
public Example()
{
InitializeComponent();
//Loaded += new RoutedEventHandler(UserControl_Loaded);
}
}
public class section8
{
//public string headingid { get; set; }
public string headingname { get; set; }
public section8(string name)
{
_name = name;
_section81 = new List<section81>();
}
string _name;
public string Name { get { return _name; } }
List<section81> _section81;
public List<section81> section81s { get { return _section81; } }
}
public class section81
{
//public string sub_heading_id1 { get; set; }
public string heading_id1 { get; set; }
public string sub_heading_name1 { get; set; }
public section81(string name)
{
_name = name;
_section82 = new List<section82>();
}
string _name;
public string Name { get { return _name; } }
List<section82> _section82;
public List<section82> section82s { get { return _section82; } }
}
public class section82
{
//public string detail_id2 { get; set; }
public string sub_heading_id2 { get; set; }
public string Heading_id2 { get; set; }
public string detail_text2 { get; set; }
public section82(string name)
{
_name = name;
}
string _name;
public string Name { get { return _name; } }
}
public class SectionsDataSource : List<section8>
{
List<Asection8> sectionList = new List<Asection8>();
List<Asection81> sectionList1 = new List<Asection81>();
List<Asection82> sectionList2 = new List<Asection82>();
public class Asection8
{
public string headingid { get; set; }
public string headingname { get; set; }
}
public class Asection81
{
public string sub_heading_id1 { get; set; }
public string heading_id1 { get; set; }
public string sub_heading_name1 { get; set; }
}
public class Asection82
{
public string detail_id2 { get; set; }
public string sub_heading_id2 { get; set; }
public string Heading_id2 { get; set; }
public string detail_text2 { get; set; }
}
void UserControl_Loaded(object sender, RoutedEventArgs e)
{
BasicHttpBinding bind = new BasicHttpBinding();
bind.MaxReceivedMessageSize = 2147483647;
bind.MaxBufferSize = 2147483647;
//EndpointAddress endpoint = new EndpointAddress("http://localhost:51103/serviceTest_Web/myService.asmx");theSercice.myServiceSoapClient textureSoapClient = new serviceTest.theSercice.myServiceSoapClient(bind, endpoint);
//textureSoapClient.RetrieveTextureAsync();
//EndpointAddress endpoint = new EndpointAddress("http://localhost:51103/serviceTest_Web/myService.asmx"); theSercice.myServiceSoapClient textureSoapClient = new serviceTest.theSercice.myServiceSoapClient(bind, endpoint);
//textureSoapClient.RetrieveTextureAsync();
//textureSoapClient.RetrieveTextureCompleted += new EventHandler(textureSoapClient_RetrieveTextureCompleted);
EndpointAddress endpoint = new EndpointAddress("http://localhost:1258/CareerM/Profile.asmx");
//http://www.emmaculate.com/CareerM/
//EndpointAddress endpoint = new EndpointAddress("http://www.emmaculate.com/CareerM/Profile.asmx");
ServiceProfile3.ProfileSoapClient textureSoapClient = new ServiceProfile3.ProfileSoapClient(bind, endpoint);
textureSoapClient.RetrieveTreeAsync();
//.RetrieveTextureAsync();
textureSoapClient.RetrieveTreeCompleted +=
new EventHandler<ServiceProfile3.RetrieveTreeCompletedEventArgs>(textureSoapClient_RetrieveTreeCompleted);
//textureSoapClient.RetrieveTextureCompleted +=
//new EventHandler<serviceTest.theSercice.RetrieveTextureCompletedEventArgs>(textureSoapClient_RetrieveTextureCompleted);
}
void textureSoapClient_RetrieveTreeCompleted(object sender, ServiceProfile3.RetrieveTreeCompletedEventArgs e)
{
if (e.Error == null)
displayData(e.Result);
}
void displayData(string xmlContent)
{
try
{
if (xmlContent != string.Empty)
{
XDocument xmlSections = XDocument.Parse(xmlContent);
// #region 0
var sections = from section8 in xmlSections.Descendants("section8")
select new
{
headingid = (string)section8.Element("headingid").Value.PadLeft(10, '0'),
headingname = (string)section8.Element("headingname").Value.PadLeft(10, '0')
};
var sections1 = from section81 in xmlSections.Descendants("section81")
select new
{
sub_heading_id1 = (string)section81.Element("sub_heading_id1").Value.PadLeft(10, '0'),
heading_id1 = (string)section81.Element("headingid1").Value.PadLeft(10, '0'),
subheadingname1 = (string)section81.Element("sub_heading_name1").Value.PadLeft(10, '0'),
//txPath = (string)"http://www.texturearchive.com/thumbs/" + texture.Element("class1").Value + "/" + texture.Element("class2").Value + "/" + texture.Element("item").Value.PadLeft(10, '0') + "_" + texture.Element("Artist").Value.PadLeft(10, '0') + "_tn.jpg",
// detailtext1 = (string)section81.Element("detailtext1").Value.PadLeft(10, '0')
};
var sections2 = from section82 in xmlSections.Descendants("section82")
select new
{
detailid2 = (string)section82.Element("detail_id2").Value.PadLeft(10, '0'),
sub_heading_id2 = (string)section82.Element("sub_heading_id2").Value.PadLeft(10, '0'),
heading_id2 = (string)section82.Element("heading_id2").Value.PadLeft(10, '0'),
//subheadingname2 = (string)section82.Element("subheadingname2").Value.PadLeft(10, '0'),
detailtext2 = (string)section82.Element("detail_text2").Value.PadLeft(10, '0')
};
//Bug: http://silverlight.net/forums/t/11147.aspx
//List<Asection8> sectionList = new List<Asection8>();
foreach (var t in sections)
{
Asection8 pdt = new Asection8 { headingid = t.headingid, headingname = t.headingname };
sectionList.Add(pdt);
}
//List<Asection81> sectionList1 = new List<Asection81>();
foreach (var t in sections1)
{
Asection81 pdt1 = new Asection81 { heading_id1 = t.heading_id1, sub_heading_id1 = t.sub_heading_id1, sub_heading_name1 = t.subheadingname1 };
sectionList1.Add(pdt1);
}
// List<Asection82> sectionList2 = new List<Asection82>();
foreach (var t in sections2)
{
Asection82 pdt2 = new Asection82 { Heading_id2 = t.heading_id2, sub_heading_id2 = t.sub_heading_id2, detail_id2 = t.detailid2, detail_text2 = t.detailtext2 };
sectionList2.Add(pdt2);
}
//string text="";
//for (int a=0;a<= int.Parse(sectionList.Count.ToString()) ; a++)
//{
// for (int b=0;b<= int.Parse(sectionList1.Count.ToString()) ; b++)
// {
// for (int c=0;c<= int.Parse(sectionList2.Count.ToString()) ; c++)
// {
// section8 l;
// section81 d;
// Add(l = new section8(sectionList1[0].ToString() ));
// l.section81s.Add((d = new section81(sectionList2[0].ToString())));
// d.section82s.Add(new section82(sectionList[0].ToString()));
// }
// }
//}
//#endregion
// texturesDataGrid.ItemsSource = texturesList;
//CustomersGrid.ItemsSource = profilesList;
//RadTreeViewItem item = new RadTreeViewItem();
// item.ItemsSource = sectionList;
//item.DataContext = sectionList;
//RadTreeView rd = new RadTreeView();
//rd.DataContext = sectionList;
}
else
{
//errMessage.Visibility = Visibility.Visible;
//texturesDataGrid.ItemsSource = null;
//CustomersGrid.ItemsSource = null;
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
}
public SectionsDataSource()
{
// RoutedEventHandler Loaded;
// Loaded +=new RoutedEventHandler(UserControl_Loaded);
//// RoutedEventHandler += new RoutedEventHandler(UserControl_Loaded);
// UserControl_Loaded();
//how to load first webservice to load the data ?
string text = "";
for (int a = 0; a <= int.Parse(sectionList.Count.ToString()); a++)
{
for (int b = 0; b <= int.Parse(sectionList1.Count.ToString()); b++)
{
for (int c = 0; c <= int.Parse(sectionList2.Count.ToString()); c++)
{
section8 l;
section81 d;
Add(l = new section8(sectionList1[0].ToString()));
l.section81s.Add((d = new section81(sectionList2[0].ToString())));
d.section82s.Add(new section82(sectionList[0].ToString()));
}
}
}
//section8 l;
//section81 d;
//Add(l = new section8("1"));
//l.section81s.Add((d = new section81("1")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
//d.section82s.Add(new section82("4"));
//d.section82s.Add(new section82("5"));
//l.section81s.Add((d = new section81("2")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
//d.section82s.Add(new section82("4"));
//d.section82s.Add(new section82("5"));
//l.section81s.Add((d = new section81("3")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
//d.section82s.Add(new section82("4"));
//Add(l = new section8("2"));
//l.section81s.Add((d = new section81("1")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
//l.section81s.Add((d = new section81("2")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
//d.section82s.Add(new section82("4"));
//l.section81s.Add((d = new section81("3")));
//d.section82s.Add(new section82("1"));
//d.section82s.Add(new section82("2"));
//d.section82s.Add(new section82("3"));
}
}
public class League
{
public League(string name)
{
_name = name;
_divisions = new List<Division>();
}
string _name;
public string Name { get { return _name; } }
List<Division> _divisions;
public List<Division> Divisions { get { return _divisions; } }
}
public class Division
{
public Division(string name)
{
_name = name;
_teams = new List<Team>();
}
string _name;
public string Name { get { return _name; } }
List<Team> _teams;
public List<Team> Teams { get { return _teams; } }
}
public class Team
{
public Team(string name)
{
_name = name;
}
string _name;
public string Name { get { return _name; } }
}
public class LeaguesDataSource : List<League>
{
public LeaguesDataSource()
{
League l;
Division d;
Add(l = new League("League A"));
l.Divisions.Add((d = new Division("Division A")));
d.Teams.Add(new Team("Team I"));
d.Teams.Add(new Team("Team II"));
d.Teams.Add(new Team("Team III"));
d.Teams.Add(new Team("Team IV"));
d.Teams.Add(new Team("Team V"));
l.Divisions.Add((d = new Division("Division B")));
d.Teams.Add(new Team("Team Blue"));
d.Teams.Add(new Team("Team Red"));
d.Teams.Add(new Team("Team Yellow"));
d.Teams.Add(new Team("Team Green"));
d.Teams.Add(new Team("Team Orange"));
l.Divisions.Add((d = new Division("Division C")));
d.Teams.Add(new Team("Team East"));
d.Teams.Add(new Team("Team West"));
d.Teams.Add(new Team("Team North"));
d.Teams.Add(new Team("Team South"));
Add(l = new League("League B"));
l.Divisions.Add((d = new Division("Division A")));
d.Teams.Add(new Team("Team 1"));
d.Teams.Add(new Team("Team 2"));
d.Teams.Add(new Team("Team 3"));
d.Teams.Add(new Team("Team 4"));
d.Teams.Add(new Team("Team 5"));
l.Divisions.Add((d = new Division("Division B")));
d.Teams.Add(new Team("Team Diamond"));
d.Teams.Add(new Team("Team Heart"));
d.Teams.Add(new Team("Team Club"));
d.Teams.Add(new Team("Team Spade"));
l.Divisions.Add((d = new Division("Division C")));
d.Teams.Add(new Team("Team Alpha"));
d.Teams.Add(new Team("Team Beta"));
d.Teams.Add(new Team("Team Gamma"));
d.Teams.Add(new Team("Team Delta"));
d.Teams.Add(new Team("Team Epsilon"));
}
}
}
mywebservice
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using MySql.Data;
using MySql;
using MySql.Data.MySqlClient;
using System.Text;
using System.ServiceModel.Configuration;
using System.ServiceModel.Activation;
using System.Security.Principal;
using System.Web.Configuration;
using System.Configuration;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
/// <summary>
/// Summary description for Profile
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class Profile : System.Web.Services.WebService
{
public Profile()
{
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod(EnableSession = true)]
public string RetrieveTree()
{
try
{
MySqlConnection _mysqlConnection = new MySqlConnection();
_mysqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings["CMMysql"].ToString();
_mysqlConnection.Open();
// //8education
string userid = "";
string profileid = "";
if (HttpContext.Current.Session["Userid"].ToString() == "" || HttpContext.Current.Session["Userid"].ToString() == null)
userid = "1";
else
userid = HttpContext.Current.Session["Userid"].ToString();
if (HttpContext.Current.Session["Profileid"].ToString() == "" || HttpContext.Current.Session["Profileid"].ToString() == null)
profileid = "4";
else
profileid = HttpContext.Current.Session["Profileid"].ToString();
//8//education
MySqlDataAdapter da = new MySqlDataAdapter();
//da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=8 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
da.SelectCommand = new MySqlCommand("select * from tbl_heading where section_id=8 and user_id = " + userid + " and th.profile_id= " + profileid, _mysqlConnection);
DataSet ds = new DataSet();
da.Fill(ds);
//8//education
MySqlDataAdapter da1 = new MySqlDataAdapter();
//da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=8 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
da1.SelectCommand = new MySqlCommand("select * from tbl_sub_heading", _mysqlConnection);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
//8//education
MySqlDataAdapter da2 = new MySqlDataAdapter();
//da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=8 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
da2.SelectCommand = new MySqlCommand("select * from tbl_heading_details", _mysqlConnection);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
////1//7experience
//MySqlDataAdapter da1 = new MySqlDataAdapter();
////da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da1.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=7 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
//DataSet ds1 = new DataSet();
//da1.Fill(ds1);
////2//4Achievement
////3//9recomendation
////4//10links
////5 //3careerhighlights
////2//4Achievement
//MySqlDataAdapter da2 = new MySqlDataAdapter();
////da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da2.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=4 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
//DataSet ds2 = new DataSet();
//da2.Fill(ds2);
////3//9recomendation
//MySqlDataAdapter da3 = new MySqlDataAdapter();
////da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da3.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=9 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
//DataSet ds3 = new DataSet();
//da3.Fill(ds3);
////4//10links
//MySqlDataAdapter da4 = new MySqlDataAdapter();
////da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da4.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=10 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
//DataSet ds4 = new DataSet();
//da4.Fill(ds4);
////5 //3careerhighlights
//MySqlDataAdapter da5 = new MySqlDataAdapter();
////da.SelectCommand = new MySqlCommand("SELECT t.itemId,t.Artist,t.class1,t.class2,t.Path,c.colorid,c.itemid,c.colorname,c.price FROM Texture t,texturecolor c where t.itemId=c.itemid LIMIT 0, 20", _mysqlConnection);
//da5.SelectCommand = new MySqlCommand("select thd.detail_id,thd.sub_heading_id,thd.heading_id,thd.detail_text,thd.detail_html , th.heading_id,th.heading_name ,th.user_id,tsh.sub_heading_id,tsh.sub_heading_name , tsh.heading_id from tbl_heading_details thd , tbl_heading th , tbl_sub_heading tsh where thd.heading_id = th.heading_id and thd.sub_heading_id = tsh.sub_heading_id and th.section_id=3 and th.user_id = " + userid + " and profile_id= " + profileid, _mysqlConnection);
//DataSet ds5 = new DataSet();
//da5.Fill(ds5);
StringBuilder sb = new StringBuilder();
sb.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
sb.Append("<sections>");
foreach (DataRow dr in ds.Tables[0].Rows)
{
sb.Append("<section8>");
sb.Append("<headingid>");
sb.Append(dr[0].ToString());
sb.Append("</headingid>");
sb.Append("<headingname>");
sb.Append(dr[1].ToString());
sb.Append("</headingname>");
sb.Append("</section8>");
}
foreach (DataRow dr1 in ds1.Tables[0].Rows)
{
sb.Append("<section81>");
sb.Append("<sub_heading_id1>");
sb.Append(dr1[0].ToString());
sb.Append("</sub_heading_id1>");
sb.Append("<headingid1>");
sb.Append(dr1[1].ToString());
sb.Append("</headingid1>");
sb.Append("<sub_heading_name1>");
sb.Append(dr1[2].ToString());
sb.Append("</sub_heading_name1>");
sb.Append("</section81>");
}
foreach (DataRow dr2 in ds2.Tables[0].Rows)
{
sb.Append("<section82>");
sb.Append("<detail_id2>");
sb.Append(dr2[0].ToString());
sb.Append("</detail_id2>");
sb.Append("<sub_heading_id2>");
sb.Append(dr2[1].ToString());
sb.Append("</sub_heading_id2>");
sb.Append("<Heading_id2>");
sb.Append(dr2[2].ToString());
sb.Append("</Heading_id2>");
sb.Append("<detail_text2>");
sb.Append(dr2[4].ToString());
sb.Append("</detail_text2>");
sb.Append("</section82>");
}
sb.Append("</sections>");
_mysqlConnection.Close();
return sb.ToString();
}
catch (Exception ex)
{
return string.Empty;
}
}
}