How to add Meta Tag dynamically in ASPX Page in ASP.NET?

Introduction:  In this article I will explain how to change or add Meta tags dynamically in asp.net to aspx page in  c#.net, vb.net. We can add meta tag and page title statically, which is easy. But some time it is needed to add or change Page title and meta tag dynamically i.e. from code behin...

Read More

Number or Numeric Validation on TextBox using onkeypress event handler in Javascript

In this article I will explain how to apply validation (allow only numeric value) on textbox using Javascript. I have entered only numeric values in textbox and alphabets or special characters are not allowed. In this article I have a TextBox for which I have specified three event handlers, onkeypress,...

Read More

How to Merge Multiple Tables into a Single Table in JavaScript?

Introduction:  In this article, I will explain how to use jQuery or javascript to merge multiple tables into a single table....

Read More

Convert textbox value to Uppercase Or Lowercase in Asp.net using JavaScript

Introduction: In this article I will explain how change first letter of the word to uppercase and Lowercase. We can use jquery or javascript to complete this task....

Read More

Explain CTE (Common Table expression) with example?

CTE stands for Common Table expressions. It was introduced with SQL Server 2005. It is a temporary result set which can be referenced in the same query just as a view. Unlike temporary table its life is limited to the current query. It is defined by using WITH statement. CTE improves readability and ease in maintenance of complex queries and sub-queries. Syntax: ; WITH CTEName (Column aliases) AS...

Read More

Magic tables or Logical Tables in SQL server and how to access Magic Tables?

Magic tables in SQL: Magic tables are the logical tables in SQL server. There are two types of logical tables in SQL server: Inserted Deleted  These tables are automatically created and managed by SQL Server internally. These tables hold the recently inserted, deleted and updated values during Insert,...

Read More

What is the difference between string and string builder?

In this article I will explain the  difference between string and stringbuilder in c#. String String is immutable object  (i.e.  once created cannot be changed ) and It always create new object of string type in memory.  If we want to append or replace something in string then it will discard the old value and will create new instance in memory to hold the new value. String...

Read More

What do you mean by SQL dynamic queries? How to execute SQl Dynamic Commands in SQl Server?

SQL Dynamic Query: Sometime hard coded queries are not suitable to achieve the result. In that case we create dynamic query. SQL provide us different ways to create dynamic queries: 1.     Query With parameter 2.     Use Exec 3.     Use sp_executesql 1.     Query With...

Read More