jquery calculate sum of array elements

  var sum = 0;
            var array = [1, 2, 3, 4, 5];

            $.each(array, function (index, value) {
                sum = sum + value;
            });

            alert(sum);

sql Adding an identity to an existing column

You can't alter the existing columns for identity.

You have 2 options,

1. Create a new table with identity & drop the existing table
2. Create a new column with identity & drop the existing column

Approach 1. (New table) Here you can retain the existing data values on the newly created identity column.

CREATE TABLE dbo.Tmp_Names
    (
      Id int NOT NULL
             IDENTITY(1, 1),
      Name varchar(50) NULL
    )
ON  [PRIMARY]
go

SET IDENTITY_INSERT dbo.Tmp_Names ON
go

IF EXISTS ( SELECT  *
            FROM    dbo.Names ) 
    INSERT  INTO dbo.Tmp_Names ( Id, Name )
            SELECT  Id,
                    Name
            FROM    dbo.Names TABLOCKX
go

SET IDENTITY_INSERT dbo.Tmp_Names OFF
go

DROP TABLE dbo.Names
go

Exec sp_rename 'Tmp_Names', 'Names'

Approach 2 (New column) You can’t retain the existing data values on the newly created identity column, The identity column will hold the sequence of number.

Alter Table Names
Add Id_new Int Identity(1, 1)
Go

Alter Table Names Drop Column ID
Go

Exec sp_rename 'Names.Id_new', 'ID', 'Column'

asp.net dropdownlist set first value using jquery

$('#<%=ddl.ClientID%>').prop('selectedIndex', 0);

html tooltip hover

<input border='0' type='image' style='border-width:0px;' title='Edit' id='imgEditUser'>


---title='Edit'

asp.net check valid emailid

  private static bool ValidateEmail(string email)
        {

            try
            {
                string TextToValidate = email;
                Regex expression = new Regex(@"\w+@[a-zA-Z_]+?\.[a-zA-Z]{2,3}");

                // test email address with expression
                if (expression.IsMatch(TextToValidate))
                {
                    // is valid email address
                    return true;
                }
                else
                {
                    // is not valid email address
                    return false;
                }
            }
            catch (Exception)
            {
                throw;
            }
        }

jquery check valid emailid

  if (!(txtEmail == "" || txtEmail == null || txtEmail == undefined)) {

                var email = /\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*/;
                if (!email.test(txtEmail)) {
                    $('#sp').text("Please enter valid email address.")
                    $('#sp').show();
                    validateFlag = false;
                }
                else {
                    $('#sp').hide();
                }

            }

jQuery/Javascript function to clear all the fields of a form [duplicate]

$('#myForm').trigger("reset");