Wednesday, 18 February 2015

Validation to Check Duplicate Records Before Inserting Using in Asp.Net C#

No comments    
categories: , ,
Validation to Check Duplicate Records Before Inserting


If UserName or Id Values Enter in  Manually  Avoid Duplicate Values Before Insert  to Validate Using  Asp.Net C#.


                                               DEMO



                                     
      DOWNLOAD CODING



                                        HTML CODING




<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
   
      

        Username
        <asp:TextBox ID="txtUsername" runat="server" AutoPostBack="True"

            OnTextChanged="txtUsername_TextChanged" ></asp:TextBox>

        <asp:Label ID="Label1" runat="server" ForeColor="#CC3300" Visible="False"></asp:Label>
     


    </div>
    </form>
</body>
</html>

                        
                     C# CODING

  
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Net;


public partial class Login : System.Web.UI.Page
{
    SqlConnection con;
    SqlCommand cmd;
    SqlDataAdapter adp;
    SqlDataReader rd;  
    string query;


    public void dbcon()
    {
        string connn = (System.Configuration.ConfigurationManager.ConnectionStrings["dbcon"].ToString());
        con = new SqlConnection(connn);
        con.Open();

    }

    protected void Page_Load(object sender, EventArgs e)
    {

    }


    protected void txtUsername_TextChanged(object sender, EventArgs e)
    {
        dbcon();
        query = "select username from register";
        cmd = new SqlCommand(query, con);       
        rd = cmd.ExecuteReader();
         while(rd.Read())
        {
            Label1.Text = "";

           if (rd["username"].ToString() ==                                txtUsername.Text.ToString())

            {
                Label1.Visible = true;

                Label1.Text = "Already Exists";

                break;
           
            }
         
        }
    }
}































0 comments:

Post a Comment