How to open folder directly in Visual Studio Code by right click in windows explorer

Visual Studio Code lightweight code editor and runs on any platform. It is so much easy to work with it. Often we need to open folder in Visual Studio Code in order to run project, So its easy if there is an option to open any folder directly in Visual Studio Code from  windows explorer  We can do it by changing  "Right Click Context Menu" registry  Step 1 : Create a file with...

Read More

SQL Server, select all date but not Saturday and Sunday from given dates

DECLARE @OnlineRegTokenPerDay INT SET @OnlineRegTokenPerDay=10 declare @dteStart date declare @dteEnd date declare @dtStart smalldatetime declare @dtEnd smalldatetime Select @dteStart = GETDATE()+2 Select @dteEnd = GETDATE()+20 CREATE TABLE #working_hours (FullDates SMALLDATETIME); while @dteStart <= @dteEnd BEGIN print @dteStart    IF    datename(WEEKDAY, @dteStart) <> 'Saturday'  AND DATENAME(WEEKDAY, @dteStart) <> 'Sunday'  AND @dteStart...

Read More

How to Make Windows Photo Viewer Your Default Image Viewer on Windows 10

Windows 10 uses the new Photos app as your default image viewer, but many people still prefer the old Windows Photo Viewer. You can get Photo Viewer back in Windows 10  It can be activate by Enable Photo Viewer in the Registry Activate-Windows-Photo-Viewer-on-Windows-10 Run the “Activate Windows Photo Viewer on Windows 10” hack to create the keys and values in the Registry and...

Read More

Windows 10: How to fix Error Code 0x800F081F when installing .NET Framework 3.5

Problem When you select to install .NET Framework in the Windows Features list in the Control Panel, it does not complete. After asking if you’d like to use Windows Update, it then gives you an error code 0x800F081F Solution Insert Windows 10 installation CD or mount the ISO Open an administrator command prompt Type the following command (substitute correct drive letter) Dism /online /enable-feature /featurename:NetFx3 /All /Source:X:\sources\sxs /LimitAccess Note : Change drive name to "X:"...

Read More

Animated Loading Effect, Hexagon Shape

Found another cool animated loading effect in hexagon shape. Lets try it. Content platform @-webkit-keyframes preload-show-1 { from { -webkit-transform: rotateZ(60deg) rotateY(-90deg) rotateX(0deg); transform: rotateZ(60deg) rotateY(-90deg) rotateX(0deg); border-left-color: #9c2f2f; } } @keyframes...

Read More

SQL Server, Get Second and Forth Saturday list

I had a requirement to get second and forth Saturday in a month. Here is a SQL Server query which allow to get it done. select *    from (    select datein2n4,                datename( weekday, datein2n4 ) as wkdy,               row_number( ) over ( partition by datepart( month, datein2n4 ), datename( weekday, datein2n4 ) order by datein2n4 ) as rn_dy_mth   ...

Read More

SQL Server Database connection error on Amazon RDS

Creating Database using Amazon RDS is very eary. See detailed documentation about creating a Microsoft SQL Server DB Instance and Connecting to a DB Instance After that you can connect SQL Server from SQL Server Management Studio. Amazon automatically configured Inbound permission to the IP from which it is created from. While connecting from other PC or Hosting server you will receive bellow...

Read More

AWS Create Windows Server 2016 Instance using EC2

Amazon Web Service EC2 configuration is very very easy! Its totally free service. EC2 stands for Amazon Elastic Compute Cloud. URL : https://console.aws.amazon.com/ec2 Help : https://aws.amazon.com/documentation/ec2/ Select EC2 :   Resource Summary Page:  Click on "Launch Instance" Choose an Amazon Machine Image (AMI), Operating System Selection: An AMI is a template that...

Read More

Request for the permission of type 'System.Net.Mail.SmtpPermission

Trying to send email from Godaddy Hosting! Its show below error: Request for the permission of type 'System.Net.Mail.SmtpPermission, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Solution : MailMessage mail = new MailMessage(); mail.From = new MailAddress("email address", "FriendlyName"); mail.To.Add("send to email address"); mail.Subject = "Subject for email";mail.Body = "Some Message";mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient("smtp.mydomain.com"); smtp.Host...

Read More

MVC 101

Models: These are the classes that represent the domain you are interested in. These domain objects often encapsulate data stored in a database as well as code that manipulates the data and enforces domain-specific  c business logic. With ASP.NET MVC, this is most likely a Data Access Layer of some kind, using a tool like Entity Framework or NHibernate combined with custom code containing...

Read More