Tuesday, February 14, 2012

Fetch data from Sql Server using AJAX in ASP.Net

Fetch and display data using AJAX

Step 1)Open a ASP.Net AJAX enable website in your visual Studio .

Step 2)Add below code in your ASP.net page.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="check user.aspx.cs" Inherits="check_user" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                Enter username:-<asp:TextBox ID="TextBox2" runat="server" Width="134px"></asp:TextBox>&nbsp;
                <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="Password" />
                &nbsp; &nbsp;<asp:Label ID="Label1" runat="server" Width="156px"></asp:Label>
                &nbsp; &nbsp; &nbsp;<br />

Step 3) Add below code into your code behind page.
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class check_user : System.Web.UI.Page
    SqlConnection con = new SqlConnection();
    SqlCommand cmd = new SqlCommand();
    SqlDataReader rd;
    public string query;

    protected void connection()
        con.ConnectionString = "server=.\\SQLEXPRESS; integrated security=SSPI; initial catalog=sourav;";
        cmd.Connection = con;


    protected void Page_Load(object sender, EventArgs e)

    protected void Button2_Click(object sender, EventArgs e)
        string user=this.TextBox2.Text.ToString();
        cmd.CommandText = "select * from loginfo where username='"+user+"'";
        rd = cmd.ExecuteReader();
        if (rd.Read())
            this.Label1.Text = rd.GetSqlValue(1).ToString();

N.B:-Change databaseserver name , database name and table name in code.

1 comment: