Resolve jQuery conflicts with other libraries

Jquery is the standard library and most of the plugins use jQuery namespace. Usually, global objects are stored in the query namespace so you can solve all conflicts between libraries and even you can solve clashes with any other library like prototype.js, YUI, and MooTools. Generally, jQuery uses $ as a shortcut so if you use some other library with…

Continue Reading

Use CLR functions in SQL

In SQL database you can create functions and stored procedures for calculating data and return some values but as the limitation of SQL as it is not full programming language so sometimes you can not do your stuff with SQL only sometimes you have to go to CLR function to transform some data or calculate some values. CLR functions also…

Continue Reading

Typeahead from twitter provides the fastest autocomplete feature

Typeahead.js is a stronger autocomplete javascript library to provide robustness to autocomplete in textbox with providing instant text search. It provides suggestions and best to handle DOM interaction. There are two parts in this library 1) Suggestion engine, Bloodhound  2) for UI view Typeahead. Typeahead Typeahead’s library role is to handle UI work and also all DOM interaction and event…

Continue Reading

Dynamic C# with using ExpandoObject and ElasticObject

C# Dynamic It is the class that implements DLR(Dynamic Language Runtime) Interface and now you have a question that what is DLR? The dynamic language runtime (DLR) is a runtime environment that adds a set of services for dynamic languages to the common language runtime (CLR). The DLR makes it easier to develop dynamic languages to run on the .NET…

Continue Reading

What is BigData?

Big Data is not just about lots of data or the big thing in a particular size, it is actually a concept providing an opportunity to find new insight into your existing data as well guidelines to capture and analysis your future data. It makes any business more agile and robust so it can adapt and overcome business challenges. In…

Continue Reading

Send Mail Using .Net with Gmail or Ymail Account

Here is a small code for sending an email from ASP.NET 2.0 page, using the namespace System.net.mail and a Gmail account. Note: We can build this email form AJAX based, by putting the content in an UpdatePanel control, and add the button “send” as a trigger.

Get Recently Run Queries in MSSql Database

Generally when you have multiple users use one database and you have to verify some stored procedures or queries that have been run during some interval in such case you can easily run below query to find all queries so here is how to get recently run queries in MySQL database? : By running this query you can easily track…

Continue Reading

Drop and recreate all indexes in database

SQL Server Management Studio does not have an easy way via the wizard to complete these tasks at the same time. In this tip, we look at a creating a script to drop and create all SQL Server indexes for a SQL Server database. Some cases we found indexes, not in a source control system, dropped or corrupted, indexes need…

Continue Reading