Introduction:
In this article, i am going to explain about how to calling database objects through jquery/ajax.

Main:

In article http://netprogramminghelp.com/aspnet/updating-datagrid-values-to-database-using-ajax/ explained with ajax,in this article i am going to explain with jquery

<%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <script runat="server"> protected void Page_Load(object sender, EventArgs e) { string connect = "Server=localhost;Database=Northwind;Trusted_Connection=True"; string query = "SELECT EmpName, Address, City, Region, PostalCode," + "Country, Phone, Fax FROM Emps WHERE EmpID = @EmpID"; string id = Request.QueryString["EmpID"]; if (id != null && id.Length == 5) { using (SqlConnection conn = new SqlConnection(connect)) { using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("EmpID", Request.QueryString["EmpID"]); conn.Open(); SqlDataReader local_rdr = cmd.ExecuteReader(); if (local_rdr.HasRows) { while (local_rdr.Read()) { Response.Write(local_rdr["EmpName"].ToString() + "<br />"); Response.Write(local_rdr["Address"].ToString() + "<br />"); Response.Write(local_rdr["City"].ToString() + "<br />"); Response.Write(local_rdr["Region"].ToString() + "<br />"); Response.Write(local_rdr["PostalCode"].ToString() + "<br />"); Response.Write(local_rdr["Country"].ToString() + "<br />"); Response.Write("Phone: " + local_rdr["Phone"].ToString() + "<br />"); Response.Write("Fax: " + local_rdr["Fax"].ToString()); } } } } } else { Response.Write("<p>No Emp selected</p>"); } Response.End(); } </script> <asp:DropDownList runat="server" id=Empddl AutoPostBack=false> <List>...</List> </asp:DropDownList>

In this examble,i am calling database in ddlchange event,here i am going to attach the ddl change event through jquery.

There are a number of ways that jQuery can request this page and handle the response. The first way to look at is the load() function,

<script type="text/javascript" src="script/jquery-1.3.2.min.js"></script> <script type="text/javascript"> $(document).ready(function() { $('#Emps').change(function() { $('#EmpDetails').load("GetEmpDetails.aspx?EmpID=" + $('#Emps').val()); }); });   </script>   Next way is get is $.get(),   <script type="text/javascript" src="script/jquery-1.3.2.min.js"></script> <script type="text/javascript"> $(document).ready(function() { $('#Emps').change(function() { $.get("GetEmpDetails.aspx", { EmpID: "" + $('#Emps').val() + "" }, function(data) { $('#EmpDetails').html(data); }); }); }); </script>

Conclusion:
Hope this helps,
Happy Coding.