Configure Database Mail in SQL Server to send e-mail from SQL Server Database

This article explains, How to configure Database Mail to send e-mail from SQL Server database. So, we explain this step by step as follows:

What is Database Mail ?

Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results, and can also include files from any resource on your network.

STEP 1 : 

First of all, We need Microsoft SQL Server Management Studio (SSMS) installed on our system (PC or Laptop) to send mail from sql  server. So if you do not have installed SSMS on your system, then first download and install it from here.

STEP 2 : 

1. Now Open SSMS and connect it to your SQL Server instance.
2. Expand Management option, there you can find Database Mail option. As you can see in below image.
   

Create Windows Service to send mail daily using ASP.Net and C#

This article explains, How to create Windows Service in ASP.Net with C# to send mail on daily basis. So, we explain this step by step as following :

STEP 1 : 

Create Windows Service Proejct in Microsoft Visual Studio 2012 and give project name as   "WindowsServiceProject1".

STEP 2 : 

Now update your App.Config file as follow :

<configuration>
  <appSettings>
    <add key="StartTime" value="03:50 PM "/>
    <add key="callDuration" value="2"/>
    <add key="CallType" value="1"/>
    <add key="FromMail" value="your_from_email_id@gmail.com"/>
    <add key="Password" value="your_email_id_password"/>
    <add key="Host" value="smtp.gmail.com"/>
  </appSettings>
  <system.net>
    <mailSettings>
      <smtp from="your_from_email_id@gmail.com">
        <network host="smtp.gmail.com" userName="your_from_email_id@gmail.com" password="your_email_id_password" enableSsl="true" port="587" />
      </smtp>
    </mailSettings>
  </system.net>
</configuration>
In this configuration settings, we use gmail email id to send mail, so for that we use smtp.gmail.com as host and Port number 587.

E-card Generator in ASP.Net C# using iTextSharp

Create E-Card Generator  (PDF format file) in ASP.Net with C# using iTextSharp

E-Card Generator

1000 Hacking Tutorials

This book provides 1000 types of Hacking tips, tricks and tutorials which are very useful.

  1000
  HACKING TUTORIALS

DB2 Express-C v9.7

This book is intended for anyone who works with or intends to work with databases, such as database administrators (DBAs), application developers, consultants, software architects, product managers, instructors, and students.

  Getting Started With
  DB2 EXPRESS-C v9.7

DB2 LUW v9.7 SQL Cookbook

This Cookbook is written for DB2 for LUW (i.e. Linux, Unix, Windows).

 

DB2 LUW v9.7
  SQL Cookbook

HTML Color Chart

This document provides the true color chart for HTML coding,

 HTML
  True Color Chart

WEB TECHNOLOGIES - A Computer Science Perspective

This book is designed for use in Computer Science(CS) and Information & Technology(IT) courses.

  WEB TECHNOLOGY
  A Computer Science Perspective

PROFFESIONAL ASP.NET MVC 1.0

This is the complete reference book for ASP.NET MVC application....
 

Proffesional
  ASP.NET MVC 1.0

C# School

14 lessons to get you started with C# and .NET

  C# School
  PROGORAMMER'S HEAVEN (FIRST EDITION)

Three Mistake Of My Life - By Chetan Bhagat

Three Mistake Of My Life - By Chetan Bhagat

Download Book

Three Mistake Of My Life - 
                                                        "The Biggest selling English-Language novelist in India's History...!!"

Introduction to C# for Microsoft .NET

Introduction to C# - The New Language for Microsoft .NET (Part 1)

Introduction to C# - Part 1

Download Part 1

Advanced C# for Microsoft .NET (Part 2)

Software Engineering - A Practitioner's Approach

This is the complete reference book for Software Engineering...
 

Software Engineering
A PRACTITIONER’s APPROACH (FIFTH EDITION)

JAVA 2 -The Complete Reference Fifth Edition

This is the complete reference book for JAVA programming language...

JAVA 2 -The Complete Reference Fifth Edition

Project Report Guideline for IT and CS

This project report example is only for students of Bachelor Engineering of Information Technology and Ccomputer Science....


 Project Report Guidelines IT and CS

Certificates - Project Report

This project report example is only for students of Bachelor Engineering of Information Technology and Computer Science....


 Certificate, Acknowlegdement & Abstract

Candidate's Decleration - Project report

This project report example is only for students of Bachelor Engineering of Information Technology and Computer Science....


 Candidate's Declarartion

Acknowledgement - Project Report

This project report example is only for students of Bachelor Engineering of Information Technology and Computer Science....


 
 Acknowledgement

Abstract - Projact Report

This project report example is only for students of Bachelor Engineering of Information Technology and Computer Science....

 
 Abstract

Notetion - Project Report

This project report example is only for students of Bachelor Engineering of Information Technology and Computer Science....


 Notations