---
title: "Google Organization Chart from database in asp.net"
description: "In this article I am going to explain how to create google organization chart from database in ASP.NET. Step by stepStep 1 Create Database and table i"
author: "Ashok Aryan"
published: 2016-02-12
updated: 2018-03-14
canonical: https://www.mindstick.com/blog/11019/google-organization-chart-from-database-in-asp-dot-net
category: "asp.net"
tags: ["google api", "chart"]
reading_time: 3 minutes
---
# Google Organization Chart from database in asp.net
In this article I am going to explain how to create google [organization](https://answers.mindstick.com/qa/100623/what-is-the-role-of-the-world-health-organization-in-global-health) chart from [database in ASP.NET](https://www.mindstick.com/forum/158707/what-are-the-different-methods-available-for-connecting-to-a-database-in-asp-dot-net-mvc). Step by step
##### Step 1
Create Database and [table in sql](https://www.mindstick.com/forum/205/find-the-all-column-with-schema-for-any-table-in-sql-server) server
Table Design
| **Column** | **[DataType](https://www.mindstick.com/forum/32/stored-procedure-return-datatype)** |
| --- | --- |
| Id | Int |
| Name | Varchar(50) |
| Parent | Varchar(50) |
| ToolTip | Varchar(50) |
##### Sample Data
| **Name** | **Parent** | **Tooltip** |
| --- | --- | --- |
| [Manager](https://www.mindstick.com/articles/13000/perks-of-implementing-a-quotation-manager) | | Manager |
| Supervisor1 | Manager | Supervisor1 |
| Supervisor2 | Manager | Supervisor2 |
| Supervisor3 | Manager | Supervisor3 |
| Employee1 | Supervisor1 | Employee1 |
| Employee2 | Supervisor1 | Employee2 |
| Employee23 | Supervisor2 | Employee3 |
##### Step 2
Open [visual studio](https://www.mindstick.com/articles/12378/visual-studio-for-mac-is-out-of-beta-preview-now-officially-available) => Create new [website](https://www.mindstick.com/articles/13110/why-copywriting-is-crucial-for-new-website-build) => Add new page and give the suitable name
##### Step 3
Html Markup
```
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Chart.aspx.cs" Inherits="Chart" %>
```
[Namespace](https://www.mindstick.com/articles/12552/namespace)
```
using System;using System.Collections.Generic;using System.Linq;
using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;using System.Text;
```
##### Code Snippet
```
SqlConnection conn = new SqlConnection("Data source=ASHOK-PC\\SQLSERVER_NEW; Database=Practice;USER ID=sa;PWD=a;Pooling=true;");
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindOrganaizationChart(); } } private void BindOrganaizationChart() {
StringBuilder str=new StringBuilder(); DataTable dt = new DataTable(); try { string cmd = "select [id] ,[name] ,[parent] ,[ToolTip] from Sample";
SqlDataAdapter adp = new SqlDataAdapter(cmd, conn);
adp.Fill(dt); str.Append(@""); ltrScript.Text = str.ToString(); } catch { }
}
```
##### \
##### Results
\
---
Original Source: https://www.mindstick.com/blog/11019/google-organization-chart-from-database-in-asp-dot-net
Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.