In this tutorial I have used SharpSSH for downloading, uploading and deleting file from remote SFTP.. Code use in video is mentioned below:
Insert Delete Update Select using Web Service and Stored procedure in ASP.NET
In this lecture, you will learn to do basic CRUD operation using web service and stored procedure. To complete this lecture you need database script, web service and website to test. You can download it from here (click here to download). Lecture: