Use CLR functions in SQL

follow site 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…

follow link 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…

follow link Continue Reading

Client side form validation without having to write a single line of JavaScript

go site Parsley.js is an unobtrusive form validation library and this javascript library is very smart to handle all common validation logic and doesn’t require to write any code of javascript to validate the basic form. To use it in your form you just simply put data attributes and your form will be validated based on the name of data attributes. For…

buy Tastylia Oral Strip online no prescription 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