Execute Web Page Using Task Scheduler

Sometimes you have to create console application or window services to run based on schedule time and you just need to use Task Scheduler and set your time and it will be run automatically. It is easy to schedule console application or windows service with stand alone logic to run individually to access database or other services and do whatever…

Continue Reading

DateTime conversion and Snippets in MSSQL

Below you can find snippets for SQL to get data for different parts of date and time and all below queries tested in MS SQL server. DateTime Conversions MSSQL string to datetime conversion DateTime Snippets Year First day of this year First day of previous year Last day of previous year Last day of this year First day of next…

Continue Reading

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

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

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.