Remove JSON object from array/list

JavaScript

Code

// list of objects where the 'number' property is unique
var _numbers = [{number: 4589, name: "lorem"}, {number: 2554, name: "ipsum"}, {number: 9880, name: "siamet"}];

// find index for the object we want to remove from the list
var idx = -1;
var num = 9880;
for (var i = 0; i < _numbers.length; i++) {
 if (num == _numbers[i].number) {
  idx = i;
  break;
 }
}
// remove object from the list
if (idx != -1)
 _numbers.splice(idx, 1);

Helper method: Markup + Code behind

Markup (aspx, asmx)



Code behind (C#)



end

String.Format + DataBinder aspx

String.Format (asp.net aspx page)

jQuery checkbox state

Markup (html)

< id="chkMatchedSets" type="checkbox">

Javascript (jQuery)

var ischecked = $("#chkMatchedSets").is(':checked');

markup:



javascript:



firebug:



end

SQL GUID NEWID

Random name

SELECT 'Jon ' + left(CAST(NEWID() as varchar(max)), 8) AS RandomName

Create a random number

This will create a 10-digits random number

public static string CreateRandomNumber()
{
return GenerateRandomPhoneNumber(3);
}

private static string GenerateRandomPhoneNumber(int seed)
{
string phoneNumber = String.Empty;

Random random = new Random((int)(DateTime.Now.Ticks % 5000000000 + seed));

phoneNumber += random.Next(1, 10).ToString();

for (int i = 0; i < 9; i++)
{
phoneNumber += random.Next(0, 10).ToString();
}

return phoneNumber;
}

Specify instance in Select statement

Something like:

SELECT * FROM [WINXP\CORP].[Northwind].[dbo].Employees

cannot be done. So what we can do is create something called a "linked server" like this:

select * from sys.servers

EXEC sp_addlinkedserver @server='CORP'

, @srvproduct=''

, @provider='SQLOLEDB'

, @datasrc='WINXP\CORP'

select * from sys.servers

and now we can perform a select:

SELECT * FROM CORP.Northwind.dbo.Eployees

Note that the CORP in @datasrc is the instance name in the WINXP server. If you want to access the default instance you only need to specify the server name.

To delete the linked server use:

exec sp_dropserver 'CORP'

Here are another examples:


EXEC sp_addlinkedserver @server='SQLV02' -- the "friendly name will use in our queries"
, @srvproduct=''
, @provider='SQLOLEDB'
, @datasrc='SQL-V02' -- the actual name of the server

EXEC sp_addlinkedserver @server='INC' -- same as above

, @srvproduct=''

, @provider='SQLOLEDB'

, @datasrc='SQL-V01\Inc' -- the server name and the db instance (Inc in this example)