Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial

MVC : Send email with attachment

In this article I am going to explain how to send email with attachment using Gmail account in MVC application.

Description:
I want to send email with attachment using Gmail account.

Implementation:

Open the web.config file of project. Set key in Appsettings. After that mailsettings as shown below:
<appSettings>
    <add key="Email" value="Emailaddress@gmail.com"/>
  </appSettings>
  <system.net>
    <mailSettings>
      <smtp deliveryMethod="Network">
        <network enableSsl="true" port="587" host="smtp.gmail.com" userName=" Emailaddress@gmail.com" password="password"/>
      </smtp>
    </mailSettings>
  </system.net> 

ASP.NET : Lock user for day after 3 invalid login attempt

In this article I am going to explain how to lock the user for day after 3 invalid login attempt in asp.net.

Description:
I want to lock the users for a day after 3 invalid login attempt. For example if user try to login on 25 November with 3 wrong password attempt, he/she will be locked for 25 November. He/she can’t login even enter correct password. He will be able to login on 26 November.  

Implementation:
I have created a table user_login


ASP.NET : Lock user for  day after 3 invalid login attempt

MVC : Show confirmation message before submit, update or delete record

In this article I am going to explain how to show confirmation message before submit, update or delete record in MVC.

Description:
I want to show a confirmation message before perform any task like submit, update or delete the data. To implement this functionality you have to set onclick action of button or actionlink.

Implementation:
You have two different ways to implement this. First simply on button or actionlink use confirm as shown below:
<input type="submit" value="Create" onclick="return confirm('Are you sure want to create user?')" />       

Second using Jquery. Create Jquery function and call that on Onclick event as shown below:
<script>
    function Confirmmessage() {
        var alert = confirm("Are you sure want to create user?");
        if (alert) {
            return true;
        } else {
            return false;
        }
    }
</script>
Button:
<input type="submit" value="Create" onclick="return Confirmmessage()" />

I have create working example of create users for application.
Model (Login.cs)

How to send email from asp.net MVC application using web.config

In this article I am going to explain how to send email from asp.net MVC application using web.config
. 
Description:
If you don’t have SMTP server to send email then you can use Gmail smtp server to send email from your MVC application. To send email from web.config file you have to            set appsetting.
  
Implementation:
Open the web.config file of project. Set key in appsettings. After that mailsettings as shown below:

MVC : Send email using Gmail account

In this article I am going to explain how to send email using Gmail account in asp.net MVC.

Description:
If you don’t have SMTP server to send email then you can use Gmail smtp server to send email from your MVC application.
  
Implementation:
Open the web.config file of project. Set key in appsettings. After that mailsettings as shown below:

How to show confirmation message in MVC

In this article I am going to explain how to show confirmation message in MVC.

Description:
I want to show a confirmation message before perform any task like submit, update or delete the data. To implement this functionality you have to set onclick action of button or actionlink.

Implementation:
You have two different ways to implement this. First simply on button or actionlink use confirm as shown below:

<input type="submit" value="Create" onclick="return confirm('Are you sure want to create user?')" />  
   
Second using Jquery. Create Jquery function and call that on Onclick event as shown below:

<script>
    function Confirmmessage() {
        var alert = confirm("Are you sure want to create user?");
        if (alert) {
            return true;
        } else {
            return false;
        }
    }
</script>

Button:
<input type="submit" value="Create" onclick="return Confirmmessage()" />

I have create working example of create users for application.

Model (Login.cs)

How to show message in popup in asp.net MVC

In this article I am going to explain how to show message in popup in asp.net MVC.

Description:
I want to show success message in popup after submit the data. We can show message in popup using jquery or HTML raw.

Implementation:
I have create a class Login to create users. When user created successfully show success message in popup.

Model (Login.cs)

Display number of records per page in MVC

In this article I am going to explain how to Display number of records per page in asp.net MVC.

Description:
I am using Pagedlist.mvc package for pagination. I want to show number of records are showing per page. For example you have 100 records and page size is 10. When you are at page 1 show in footer Showing 1-10 of 100 and on page 2 Showing 11-20 of 100.

Implementation:
Model (Employee.cs)

MVC : Compare password and confirm password

In this article I am going to explain how to compare password and confirm password in asp.net MVC.

Description:
When creating users in MVC application want users to enter strong password and re-enter password to confirm.
  
Implementation:
  
Model

How to change page size using dropdownlist in asp.net MVC

In this article I am going to explain how to change page size using dropdownlist in asp.net MVC.

Description:
I am using Pagedlist.mvc package for pagination. In previous article I have explained How to customize the pager in MVC Pagedlist.  Now I want to change/set page size using dropdownlist in foreach loop.

Implementation:
I want to display list of employees.
Model (Employee.cs)

[Solved]: Error:40–could not open a connection to SQL server

In this article I am going to explain how to resolve the Error: 40 – could not open a connection to SQL server.

Description:
When I am trying to connect the Sql server, got an error:

Cannot connect to localhost. :
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that the SQL Server is configured to allow remote connections. (provided: Named Pipes Provider, error: 40- Could not open a connection to the SQL Server) (Microsoft SQL Server, Error: 2).

How to validate strong password in asp.net MVC

In this article I am going to explain how to validate strong password in asp.net MVC. 

Description:
Password ensure the security for confidential information/data which is stored on your system or online anywhere. If you use weak password, it allow hackers to get access easily. So we have to always force users to set strong password. In strong password user must one uppercase, one lowercase, one special and one numeric (number) character.


Implementations:
I am going to create users for application.

Custom Pager in MVC Pagedlist

In this article I am going to explain how to customize the pager in MVC Pagedlist.

Description:
I want to show total number of records and number records are showing out of total records. Change the pagesize using dropdown.

Implementation:

Model
  public partial class Employee
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public Nullable<int> Phone { get; set; }
        public Nullable<int> Salary { get; set; }
        public string Department { get; set; }
        public string ImagePath { get; set; }
        public string EmailId { get; set; }
    }

ASP.NET MVC : Change page size with dropdown

In this article I am going to explain how to change page size with dropdown in asp.net MVC.

Description:
I am using Pagedlist.mvc package for pagination. In previous article I have explained  .  Now I want to change/set page size using dropdown in foreach loop.

Implementation:
I want to display list of employees.

Model (Employee.cs)
    public partial class Employee
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public Nullable<int> Phone { get; set; }
        public Nullable<int> Salary { get; set; }
        public string Department { get; set; }
        public string ImagePath { get; set; }
        public string EmailId { get; set; }
    }

Add controller
Now add an empty controller to project. Create action to fetch the data.

Complete code of controller

Asp.net : Convert base 64 string into image

In this article I am going to explain how to convert or save Base64 string as image in asp.net.

Description:
Recently I have got a requirement to implement digital signature functionality in application. To fulfill this requirement I have use Signature pad jquery. It is HTML5 canvas based. The signature file is created in base64 string. I want to save this base64 string as image in application.

Implementation:
You can download Signature pad script from here. Download Javascript and add reference to web form.

HTML Markup of webform

Asp.net : how to implement digital signature

In this article I am going to explain how to implement digital signature in asp.net application.

Description:
Recently I have got a requirement to implement digital signature functionality in application. To fulfill this requirement I have use Signature pad jquery. It is HTML5 canvas based.

Implementation:
You can download Signature pad script from here. Download Javascript and add reference to web form.

HTML Markup of webform

How to implement pagination in MVC application

In this article I am going to explain how to implement pagination in MVC application.

Description:
I am showing the employees information in foreach loop. I want to paginate the data. For pagination in MVC Pagedlist package is available. You can install this from Nuget package manager console. Run the below command:

Install-Package PagedList.Mvc

Implementation:
Model class of Employee (Employee.cs)

public partial class Employee
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public Nullable<int> Phone { get; set; }
        public Nullable<int> Salary { get; set; }
        public string Department { get; set; }
        public string ImagePath { get; set; }
        public string EmailId { get; set; }
    }


Add controller
Get count of rows and columns from datatable in asp.net

Get count of rows and columns from datatable in asp.net

In this article I am going how to get count of rows and columns from datatable in asp.net.

Implementation:
I want to know how many rows and columns in datatable or dataset?

Syntax
C# code

int row = dt.Rows.Count;
int column = dt.Columns.Count;
//dataset row count
  int row = ds.Tables[0].Rows.Count;
  int column = ds.Tables[0].Columns.Count;

VB.net code

Dim row As Integer = dt.Rows.Count
Dim column As Integer = dt.Columns.Count
dataset row count
Dim row As Integer = ds.Tables(0).Rows.Count
Dim column As Integer = ds.Tables(0).Columns.Count

Example:
HTML Markup of webform