I think it will help you.. I've improved my solution so it is more useful to you
public partial class AJAXTestPage : System.Web.UI.Page
{
SqlConnection con;
SqlCommand cmd;
SqlDataReader reader;
DataTable dt = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
con.Open();
cmd = new SqlCommand("select User_Name from Registration", con);
reader = cmd.ExecuteReader();
con.Close();
}
}
protected void btnCheck_Availablity_Click(object sender, EventArgs e)
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
con.Open();
cmd = new SqlCommand("select User_Name from Registration where userName = @userName", con);
cmd.Parameter.AddWithValue("@userName",txtUser_Name.Text");
con.Open();
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
lblUnavailableUser_Name.Visible = true;
lblAvailable.Visible = false;
}
else
{
lblAvailable.Visible = true;
lblUnavailableUser_Name.Visible = false;
}
con.Close();
}
}