mfatih says:
[WebMethod]
protected
void
Page_Load(
object
sender, EventArgs e)
{
OleDbConnection con =
new
OleDbConnection(
"Provider=Microsoft.ACE.OLEDB.12.0; DATA Source="
+ Server.MapPath(
"app_data/familytree.accdb"
));
}
public
static
List<
object
> GetChartData()
{
string
query =
"SELECT MemberId, Name, ParentId"
;
query +=
" FROM FamilyHierarchy"
;
string
constr = ConfigurationManager.ConnectionStrings[
"constr"
].ConnectionString;
using
(OleDbConnection con =
new
OleDbConnection(constr))
{
using
(OleDbCommand cmd =
new
OleDbCommand(query))
{
List<
object
> chartData =
new
List<
object
>();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
using
(OleDbDataReader sdr = cmd.ExecuteReader())
{
while
(sdr.Read())
{
chartData.Add(
new
object
[]
{
sdr[
"MemberId"
], sdr[
"Name"
], sdr[
"ParentId"
]
});
}
}
con.Close();
return
chartData;
}
}
}
replace above code with below and one more thing database table should contain records same as per the table structure used in sample