Text and Data Manipulation with Regular Expressions in .NET Development

Regular expressions(or regex) is a language used for more sophisticated form and text processing. They are often used to perform complex search-and-replace operations, and to validate that text data is well-formed. Today, regular expressions are supported by most programming languages, as well as many scripting languages (like Perl, ASP, Visual Basic, .NET, C#, Java, JSP, PHP,Python, ColdFusion, Tcl, Ruby and many other languages), editors (EmEditor, TextPad), applications (Microsoft Word, Microsoft Excel, StarOffice, OpenOffice), databases(MySQL, SQL Server), and command-line tools.

Here we see a hands on approach to solve the needs of the majority of RegEx to manipulate data. I have try my best to provide ready to use source for lattest version of ASP.NET, VB.NET, C#.NET. All the example described here are tested with Visual Studio 2008. I have try to cover all important and mostly used regular expressions. If you face with any error or you have new idea which needed to be cover here. Please drop your feedback for me. Ok!, let’s get started…

Read the rest of this entry »

Learning JavaScript tutorial – First Look at Client-Side JavaScript

As we seen in our first article "Learning JavaScript – an introduction with JavaScript", JavaScript is mostly used as a client-side scripting language. With Client-side JavaScript, we are able to interpreter with the Document Object Model (DOM) of a web browser. On Client-Side, JavaScript add interactive features to your page. JavaScript allowing us to do plenty of tasks on Client-Side like mathematical calculations, form validation, drop down and sliding menus, message tickers, work with events, work with cookies, add special effects and animation, develop interactive games, customize graphics selections, and create security passwords and many more.

Read the rest of this entry »

Learning JavaScript tutorial – an introduction with JavaScript

JavaScript is most popular, commonly used, object-oriented, client-side scripting language. JavaScript widely used in tasks ranging from the form data validation to the development of enhanced user interfaces and dynamic websites. The primary use of Client-side JavaScript is to write functions that are embedded in or included from HTML pages and interact with the Document Object Model (DOM) of the page. Because JavaScript code can run locally in a user’s browser (instead of get parse on a remote server like PHP or ASP.NET), it can respond to user actions quickly, making an application feel more responsive and user friendly.

What can a JavaScript do for a Web Developer?

As a web developer you can use JavaScript to perform various tasks, some of them are as follows…

Read the rest of this entry »

How to find out duplicate records (duplicate data) in a SQL Server table

Records duplication or data redundancy is the common issue we face with SQL Server table. In this article we will find out all the duplicate records (duplicate data) in a SQL Server table. We have to use the group by with having command to get the duplicate records (duplicate data).

Syntex:
SELECT column_Name FROM Table_name
GROUP BY column_Name
HAVING count(column_Name) > 1
 
Example:
SELECT studentName FROM tblStudentDtl
GROUP BY studentName
HAVING count(studentName) > 1

This technique is good while fatching single column, if you want more column to fetch you need to modify it like…

Read the rest of this entry »

GridView Custom Paging in ASP.NET 3.5 with SQL Server Stored Procedure

GridView — Displays a set of data items in an HTML table. ASP.NET GridView control enables you to display, sort, page, select, and edit data.

Default gridview paging works best when you deal with limited pages. If there are more pages then, the performance suffers. In this case direct jump to desire page is a good alternative.

I have deal with a problem on GridView while working on user control (.ascx). I have a user control (.ascx) with GridView in it. I have used Stored Procedure to retrieve data. Bounding data to gridview display all the records and Default paging setting not work for me. Here Custom Paging helps me and only those database records that need to be displayed get retrieved. Using GridView Custom Paging solve the Issue for me.

Read the rest of this entry »

Create Temporary virtual table (or a records set) with SQL Server Stored Procedure

Some time we need to create a virtual table to manipulate data without affecting the actual data in the actual table. You can create a virtual table by two ways. Using CREATE TABLE statement and with DECLARE statement.

Let’s consider, I have student table(tblStudent) contain sName, sAddress, ClassId and class table(tblClass) contain classId and ClassName. Now I want to SELECT Name, Address and ClassName based on string pattern and Stored it to a virtual table.

First of all take a look at our table structure…

Read the rest of this entry »