--- title: "Fetch values from database with Ajax" description: "Fetch values from database with Ajax" author: "chandu kumar" published: 2012-11-09 updated: 2019-09-07 canonical: https://www.mindstick.com/articles/1056/fetch-values-from-database-with-ajax category: "ajax" tags: ["ajax"] reading_time: 4 minutes --- # Fetch values from database with Ajax ##### Aspx Page ``` <%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>                                                     
 
                                      
                
 
<%#DataBinder.Eval(Container.DataItem, "category_name")%>Image
NavigateUrl="http://www.hunchsoft.co.in" style="color: #FFFFFF">Hunch Software Pvt. Ltd.
``` ##### .cs File ``` using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using MySql.Data.MySqlClient;using System.Data;using System.Configuration;public partial class MasterPage : System.Web.UI.MasterPage{MySqlConnection sqlConn = new MySqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){bind();company_bind();int? x = null;if (x.HasValue){}}}public void company_bind(){MySqlDataAdapter cmd = new MySqlDataAdapter("select * from packpouch.company_info",sqlConn);DataTable tb = new DataTable();cmd.Fill(tb);Label1.Text = tb.Rows[0][0].ToString();Label2.Text = tb.Rows[0][1].ToString();Label3.Text = tb.Rows[0][2].ToString();Label4.Text = tb.Rows[0][3].ToString();Label5.Text = tb.Rows[0][4].ToString();Label6.Text = tb.Rows[0][5].ToString();Label7.Text = tb.Rows[0][6].ToString();Label8.Text = tb.Rows[0][7].ToString();Label9.Text = tb.Rows[0][8].ToString();Label10.Text = tb.Rows[0][9].ToString();Label11.Text = tb.Rows[0][10].ToString();Label12.Text = tb.Rows[0][11].ToString();Label13.Text = tb.Rows[0][12].ToString();Label14.Text = tb.Rows[0][13].ToString();}public void bind(){//string p= Accordion1.Panes.ToString();string p= Accordion1.SelectedIndex.ToString();MySqlCommand sqlSelect = new MySqlCommand("SELECT * FROM category where parentid=0", sqlConn);sqlSelect.CommandType = System.Data.CommandType.Text;MySqlDataAdapter sqlAdapter = new MySqlDataAdapter(sqlSelect);DataSet myDataset = new DataSet();sqlAdapter.Fill(myDataset);Accordion1.DataSource = myDataset.Tables[0].DefaultView;Accordion1.DataBind();}protected void Accordion1_ItemDataBound(object sender, AjaxControlToolkit.AccordionItemEventArgs e){// int p = 1;if (e.ItemType == AjaxControlToolkit.AccordionItemType.Content){//p = Accordion1.SelectedIndex;// int pp= Accordion1.TabIndex;HiddenField x= (HiddenField)e.AccordionItem.FindControl("txt_categoryID");string p= x.ToString();string xx = e.Item.ToString();// MySqlConnection sqlConn = new MySqlConnection("Server=packpouch.db.7649735.hostedresource.com; Database=packpouch;uid=packpouch;pwd=Hunch@123");sqlConn.Open();MySqlCommand sqlSelect = new MySqlCommand("SELECT category_name FROM category where parentid = " + ((HiddenField)e.AccordionItem.FindControl("txt_categoryID")).Value + "",sqlConn); sqlSelect.CommandType = System.Data.CommandType.Text; MySqlDataAdapter sqlAdapter = new MySqlDataAdapter(sqlSelect); DataSet myDataset = new DataSet(); sqlAdapter.Fill(myDataset); sqlConn.Close(); GridView grd = new GridView(); grd = (GridView)e.AccordionItem.FindControl("GridView1"); grd.DataSource = myDataset; grd.DataBind(); } } ``` ##### Database: ![Fetch values from database with Ajax](https://www.mindstick.com/mindstickarticle/07e27dea-bc99-4c07-b91a-32a597af940b/images/64f2f61e-ce8a-4643-9e4d-7ae778e2979c.png) ![Fetch values from database with Ajax](https://www.mindstick.com/mindstickarticle/07e27dea-bc99-4c07-b91a-32a597af940b/images/7f259c68-09bc-49b9-bd7d-5e45a37bdc8d.png) \ --- Original Source: https://www.mindstick.com/articles/1056/fetch-values-from-database-with-ajax Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.