Rakesh Patel

Thursday, December 5, 2019

Get Table Name with Row Count from SQL Database

Select the database you want to filter the information about the row count and run following SQL Statement

SELECT
T.NAME AS 'TABLE NAME',
P.[ROWS] AS 'ROW COUNT'
FROM SYS.TABLES T
INNER JOIN SYS.PARTITIONS P ON T.OBJECT_ID=P.OBJECT_ID

This help me to know how many rows are there in table. Hope this will help you too.

Monday, November 18, 2019

Block or Disable Cut, Copy and Paste operation Using jQuery

It is required to block the cut, copy and paste operations on some of the textbox. For example, it will be better if we do not allow users to copy paste the data entered in Email and Confirm Email field in order to make the user to type themselves.

The below jQuery code will help us to do the same using preventDefault() method

Move List Items Up and Down Using jQuery

Sometimes, we require moving/scrolling the list items in the select control up and down to sort manually. This little code snippet will help us to do that using jQuery library.

var nextOption = $("#ListBox1 > option[selected]").next("option");

if ($(nextOption).text() != "") {
      $(selectedOption).remove();

$(nextOption).after($(selectedOption));
    }
  }

function MoveUp() {
    var selectedOption = $("#ListBox1 > option[selected]");

var prevOption = $("#ListBox1 > option[selected]").prev("option");

if ($(prevOption).text() != "") {
      $(selectedOption).remove();

$(prevOption).before($(selectedOption));
    }
  }
</script>

Thursday, November 14, 2019

Convert JSON data to CSV

JSON Data

Output as CSV

Wednesday, October 23, 2019

Sorting by Key in An Array of object with Jquery

Tuesday, October 22, 2019

8 Must Know JavaScript Array Methods

Working with arrays in JavaScript used to be a pain with barely any support for complex array operations. Fast forward to today, though, and there are tons of amazing JavaScript array methods available to us. In this video I will be covering the 8 most important array methods in JavaScript.

const items =[
{ name: 'Bike', price:100},
{ name: 'TV', price:200},
{ name: 'Album', price:10},
{ name: 'Book', price:5},
{ name: 'Phone', price:500},
{ name: 'Computer', price:1000},
{ name: 'Keyboard', price:25}
]

// create another array with filtered items
const filteredItems = items.filter((item) => {
return item.price <= 100
})

console.log(filteredItems);

// get element and create another array
const itemNames = items.map((item) => {
return item.name
});

console.log(itemNames)

//find element in array
const foundItem = items.find((item) =>{
return item.name === 'Album'
})
console.log(foundItem)

//forEach
items.forEach((item) =>{
console.log(item.price)
})

// some -- return true if found
const hasInExpensiveItem = items.some((item) =>{
return item.price <= 100
})
console.log(hasInExpensiveItem)

// calculate with variable initiate as 0
const total = items.reduce((currentTotal, item){
return item.price + currentTotal
},0) // 0 is the initial value of CurrentTotal

console.log(total)

// include -- if item present in array return true.. this work fine with simple array...

const items =[1, 2, 3, 4, 5]
const includesTwo = items.includes(2)
console.log (includesTwo) // return True..

const includesTwo = items.includes(6)
console.log (includesTwo) // return false..

// distinct from array

var distinct = (value, index, self) =>{
return self.indexOf(value) === index;
}

var years = [2016, 2017, 2017, 2020, 2016, 2019]
var distinctYears = years.filter(distinct)

output : [2016, 2017, 2020, 2019]

Thanks to Web Dev Simplified and codeburst

Friday, October 18, 2019

PrintQueue.Purge Method

Code help to Purge Network/Local Print .

Dim ps = New LocalPrintServer(PrintSystemDesiredAccess.AdministrateServer)
Dim pq = New PrintQueue(ps, ps.DefaultPrintQueue.FullName,

PrintSystemDesiredAccess.AdministratePrinter)

If pq.NumberOfJobs > 0 Then
pq.Purge()
End If