Restrict Special Characters Using JavaScript By Copy,Paste

-
Restrict Special Characters using copy,paste events in JavaScript.

Please follow these steps:

 1. Create a textbox with the name of txtValidation and add event by the name of onpaste to that textbox.
<asp:TextBox ID="txtValidation" runat="server" onpaste="return Validate(this.value);"></asp:TextBox>

 2. Create a Function to that event.

  <script type="text/javascript">
        function Validate(Value) {
            var pastedData = window.clipboardData.getData('Text');
            var reg = /^[a-zA-Z0-9 ]*$/
            if (!reg.test(pastedData)) {
                alert('Not Accept Special Characters');
                return false;
            }
        }
    </script>


Some of the special characters are hidden when you copy,paste it will not visible. If you want to restrict those special characters in sql database only, not in application.

 These Special Characters is not visible when you copy,paste in your application, we have to find in database(tables) only, in that you have to restrict hidden special characters in Sql Database(tables) also.


Please follow these steps:

 1. Create a textbox with the name of txtValidation and add event by the name of onpaste to that textbox.

 2. Create a button with the name of btnValidate and add event by the name of OnClick to that button.

 3. Create a constraint for specific column in your table.

 4. Handle that Exception in your code.

Lets See How...


 <form id="form1" runat="server">
    <div>
        <center>
            <table>
                <tr>
                    <td>
                        <asp:Label ID="lblValidation" runat="server" Text="Validation"></asp:Label>
                        &nbsp;
                        <asp:TextBox ID="txtValidation" runat="server" ></asp:TextBox>
                    </td>
                </tr>
            </table>
            <asp:Button ID="btnValidate" Text="Validate" runat="server" CausesValidation="false"
                OnClick="btnValidate_Click" />
           </center>
    </div>
    </form>


Code behind for btnValidate

        protected void btnValidate_Click(object sender, EventArgs e)
        {
           string connectionString = You Pass your Connection string here;
            try
            {
                int result = InsertData();
                if (result > 0)
                {
                    Response.Write("Data Saved Successfully");
                }

             }
            catch (SqlException Sqlex)
            {
                if (Sqlex.Message.Contains("CHECK constraint"))
                {
                    Response.Write("Special Characters are not Allowed");
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public int InsertData()
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand cmd = new SqlCommand("INSERT INTO tblValidate (Name) VALUES (@ColumnName)");
                cmd.CommandType = CommandType.Text;
                cmd.Connection = connection;
                cmd.Parameters.AddWithValue("@ColumnName", txtValidation.Text);
                connection.Open();
                return cmd.ExecuteNonQuery();
            }
        }

Create a constraint for Specific column.
I am giving my column name as 'Name'.

 Your can create a Check Constraint on this column and only allow Number sand Alphabets to be inserted in this column, see below:

Check Constraint to only Allow Numbers & Alphabets

ALTER TABLE Table_Name
ADD CONSTRAINT ck_No_Special_Characters
       CHECK (Column_Name NOT LIKE '%[^A-Z0-9]%')


Check Constraint to only Allow Numbers

ALTER TABLE Table_Name
ADD CONSTRAINT ck_Only_Numbers
       CHECK (Column_Name NOT LIKE '%[^0-9]%')
Check Constraint to only Allow Alphabets

ALTER TABLE Table_Name
ADD CONSTRAINT ck_Only_Alphabets
       CHECK (Column_Name NOT LIKE '%[^A-Z]%')



 For Your Reference please check this link for brief description for using SQL Constraints.
http://www.techrepublic.com/blog/how-do-i/how-do-i-reject-alpha-characters-in-a-sql-server-character-column/

Hope It will help You Guys..!!!!

Comments

Post a Comment

Popular posts from this blog

Create Custom Form Control for ng-select in Angular

-
Image
How to Create Custom Form Control in Angular  Why we create custom form control ? Normally, we used to create custom form control for re-usability.  The best advantage is that to add common functionality and features in this custom form control and extend the functionality as per our need and requirement.  And we can use everywhere into the application. But this example will tell you how to create custom form control to extend the functionality of  angular ng-select component.  We are adding a feature for this control, multi selection along with checkbox. Before that, we need to know what is the basic syntax of creating custom form control in angular. So, we start by implementing the ControlValueAccessor interface from @angular/forms into the component. This interface has three functions that need to be implemented and one optional functional. writeValue(obj: any): void { } registerOnChange(fn: any): void { } registerOnTouched(f
Read more

Configure the API gateway in Microservices Architecture with example in .NET Core

-
API Gateway in Microservices Architecture In a microservices architecture, an API Gateway is a layer that sits between clients and the microservices that provide the necessary functionalities. It acts as a single entry point for all client requests and handles communication between the clients and the underlying microservices. The API Gateway serves as a mediator between the client and the backend services. It receives incoming requests from clients and routes them to the appropriate microservice. It also handles authentication, authorization, load balancing, and other cross-cutting concerns such as rate limiting, caching, and request/response transformation. By providing a single entry point and a unified interface for clients, the API Gateway simplifies client access to the system and helps to decouple the client code from the underlying microservices. It also provides a central point for monitoring and logging of all the incoming requests, making it easier to identify and troublesho
Read more

Domain Driven Design (DDD) in .NET Core

-
Domain-Driven Design (DDD) is an approach to software development that emphasizes the importance of the business domain in the software design process. It is a set of principles and practices aimed at building software systems that are aligned with the business needs and requirements. The main idea behind DDD is to create a shared understanding of the domain model between the domain experts (business stakeholders) and the software developers. This is achieved by using a common language and a set of tools that allow for the domain model to be explicitly represented and manipulated in code. In DDD, the domain model is the central focus of the software design process. It is a representation of the core business concepts and rules that govern the behavior of the system. The domain model is expressed in code using object-oriented programming techniques, and it serves as the backbone of the software system. DDD also introduces several design patterns and
Read more

Content Negotiation in Web API with example

-
Content negotiation in Web API C# refers to the process of determining the best format for data exchange between the client and the server. It allows the client to specify the format they prefer to receive data in, and the server will send the data in that format if it's available. In Web API C#, content negotiation is done through the use of media formatters. A media formatter is responsible for serializing and deserializing the data in a specific format, such as JSON, XML, or plain text. The process of content negotiation in Web API C# involves the following steps: The client sends a request to the server and specifies the media type it prefers to receive the response in, through the Accept header in the HTTP request. The server receives the request and examines the Accept header to determine the media type requested by the client. The server then looks for a media formatter that can serialize the response in th
Read more

Send API POST Request in MS SQL Server

-
To send an API POST request in MS SQL Server using multipart/form-data, you can use the following T-SQL code: Example of content type : multipart/form-data SQL DECLARE @url VARCHAR(200) = 'https://example.com/api'; DECLARE @boundary VARCHAR(50) = '---------------------------' + CAST(NEWID() AS VARCHAR(36)); DECLARE @param1Name VARCHAR(50) = 'name'; DECLARE @param1Value VARCHAR(50) = 'John Doe'; DECLARE @param2Name VARCHAR(50) = 'email'; DECLARE @param2Value VARCHAR(50) = 'johndoe@example.com'; DECLARE @param3Name VARCHAR(50) = 'file'; DECLARE @param3Value VARBINARY(MAX) = (SELECT BulkColumn FROM OPENROWSET(BULK 'C:\path\to\file.txt', SINGLE_BLOB) AS x); DECLARE @param4Name VARCHAR(50) = 'description'; DECLARE @param4Value VARCHAR(200) = 'This is a sample file'; DECLARE @formData NVARCHAR(MAX) = N'--' + @boundary + CHAR(13) + CHAR(10) +
Read more

Restrict Special Characters in Windows Application using c#

-
Image
Example : In this application it will remove all the special characters when we trying to copy paste the special characters. Lets see how it is possible with Copy,paste. Please follow these steps : 1. Create a New Windows Form with the name of 'Form1', and take one label with the name of 'lblName' and one textbox with the name of 'txtName' and one button with the name of 'btnValidate'. Please see below image. 2. Add a code in TextChanged event for that textbox. Here my textbox name is 'txtName' in that I have added a event like . private void txtName_TextChanged(object sender, EventArgs e) {       txtName.Text = RemoveSpecialCharacters(txtName.Text); } 3. In that event you observed method name of 'RemoveSpecialCharacters'.Basically it will remove all the special characters when you are copy paste in to the textbox.       private string RemoveSpecialCharacters(String inString)      
Read more

How to Create Custom DialogBox using JQuery

-
Image
Example: In this application I will show you how to create Dialog box using  JQuery . Mostly we use JavaScript Default confirmation box for yes or no options.But we can't add another option into that Default Confirmation box in that requirement we want to create custom Dialog box. For my requirement I need three button Yes,No and Cancel Options in Dialog Box. Lets see how it possible with JQuery 1. Create a new webform with the name of 'UIDialog.aspx'. 2. Add a JQuery and Css plugins for custom Dialog Box below head tag. Please see in code. 3. Create a function in that I have three buttons in aspx page. Please see below code. <head runat="server">     <meta name="viewport" content="width=device-width, initial-scale=1">     <title>jQuery UI Dialog - Modal confirmation</title>     <link href="Css/styles.css" rel="stylesheet" type="text/css" />     <script type=&quo
Read more

HTTP and grPC Communication protocols used in Microservices

-
Microservices architecture is an approach to building distributed systems that involves breaking down a large application into smaller, loosely coupled services that communicate with each other through APIs. There are several communication protocols used in microservices architecture, including HTTP and gRPC. HTTP: HTTP (Hypertext Transfer Protocol) is a widely used protocol for communication between web applications and servers. In microservices architecture, HTTP is used for communication between services as it's a well-established and reliable protocol that's widely supported. HTTP is simple and easy to use, and it supports a wide range of data formats like JSON, XML, and plain text, making it a popular choice for microservices communication. gRPC: gRPC is a modern, high-performance, open-source protocol for communication between microservices. It uses Google's Protocol Buffers as a data format, which is a language-neutral, platform-neu
Read more

CORS (Cross-Origin Resource Sharing) in .NET

-
CORS stands for Cross-Origin Resource Sharing. It is a security feature that allows web pages from one domain to access resources (such as APIs) on another domain. When a web page attempts to access a resource on a different domain, the browser will send a CORS request to the server hosting the resource. The server can then choose to allow or deny the request based on the domain of the requesting web page. CORS is important because it helps to prevent malicious attacks, such as cross-site request forgery (CSRF) and cross-site scripting (XSS). By enforcing same-origin policies, CORS helps to protect users from unauthorized access to their sensitive data. We use CORS to enable cross-domain communication between web pages and APIs. Without CORS, web pages would only be able to communicate with APIs hosted on the same domain. With CORS, we can make APIs available to web pages on other domains, allowing for a more flexible and dynamic web. CORS is co
Read more