In this article, we will be using FTP task to download an .xls file and then use that file to upload it in SQL Server using Data Flow Task base. So let's create a new package and name our package as DownloadFile. [More]

With ASP.NET membership API managing website security has become easy to implement yet it is powerful to support enterprise level authentication/authorization for any application.

Today we will leverage password reset capability of membership API to reset registered user's password by generating random password and sending it to his email which is registered with the account. [More]

Certain Business requirements may involve sending database mail that incorporates company's logo, and other formatting things like thick border, particular font etc...Below article describes how this can be done using Database Mail. [More]

While using msdb.dbo.sp_send_dbmail for sending email, we realize that @receipients parameter takes up only one email address, unless that email address is not pinting to a distribution list all receipient cannot get email. In case we want to accomplish sending email to multiple receipient we can do following: [More]

When using database mail, it may be required to send email that is well formatted. Sometimes, we might want to send formatted data with proper header in the email. Below example describes as how we can send such email with table data in email body. For information on how to set up database mail refer to my earlier post here. [More]

ASP.NET user controls provide rich functionality and easy reuse of code but limitations come in when you have to reuse that control in several different website applications.

When you have a control that you are going to use in several different applications then it's a wise idea to build server control library and either add reference to the application or add that control library's dll file to bin directory of web application. [More]

ASP.NET provide solid base for code reuse in various ways, user controls are one of them. User control provide good platform to build functionality that can be shared across multiple pages within a website project, this increases code reusability and rapid application development because developer has to design and develop them only once in a project and they can use it anywhere they need to provide similar functionality. This makes it extremely easy to maintain the code because there will be only one place where developer will have to go and modify the code and once that code is modified changes get reflected wherever that control is used. [More]