Remove or Delete file from SFTP using Winscp(Version 5.5.4) in C#

Use below link to download DLL and EXE Download Link :- http://olex.openlogic.com/packages/winscp/5.5.4 Dll :- WinSCPnet.dll :-> Select Winscp 5.5.4 .NET Assembly / COM library Windows ALL Binary Executable Path :- WinSCP.exe :-> Select Winscp 5.5.4 Portable Executable Windows ALL Binary Use WinSCP;//Namespace after adding Dll in project

Download file from SFTP using Winscp(Version 5.5.4) in C#

Remove or Delete file from SFTP using Winscp(Version 5.5.4) in C# Use below link to download DLL and EXE Download Link :- http://olex.openlogic.com/packages/winscp/5.5.4 Dll :- WinSCPnet.dll :-> Select Winscp 5.5.4 .NET Assembly / COM library Windows ALL Binary Executable Path :- WinSCP.exe :-> Select Winscp 5.5.4 Portable Executable Windows ALL Binary Use WinSCP;//Namespace after adding Dll in project

Read Multiple Files from folder and Download using FTP location in Console Application using C#

Today I’m going to tell you to read multiple files from folder using FTP Location.Please follow below steps to fetch Step 1 :- Place code in Class file string ftpDownloadResult = string.Empty; try { WebRequest request = WebRequest.Create(ConfigurationManager.AppSettings["FTPPath"]); request.Method = WebRequestMethods.Ftp.ListDirectory; request.Credentials = newNetworkCredential(ConfigurationManager.AppSettings["FTPUserName"], ConfigurationManager.AppSettings["FTPPassword"]);

Read File from FTP location in Console Application using C#

Today I'm going to tell you to read text from FTP Location.Plz follow below steps to fetch Step 1 :- Place code in Class file WebRequest request = WebRequest.Create(ConfigurationManager.AppSettings["FTPPath"]); request.Method = WebRequestMethods.Ftp.DownloadFile; request.Credentials = new NetworkCredential(ConfigurationManager.AppSettings["FTPUserName"], ConfigurationManager.AppSettings["FTPPassword"]);

Import Data from Excel and CSV to SQL server using C# in Asp.net

The Page having a FileUpload control and the Upload button, on selecting the Excel or CSV file user needs to click on Upload button to store the data to Server. Here we are treating the uploaded file as database hence we need to create OLEDB connection to this file, from this connection will be created and the data is fetched to C# as DataTable. '[Sheet1$]' is the Name of the Worksheet where requires data is present. Table CREATE TABLE [dbo].[Tag]( [ID] [int] IDENTITY(1,1) NOT NULL, [TagType] [int] NULL, [TagCode] [nvarchar](100) NULL, [Status] [bit] NULL, [Duration] [int] NULL) Stored Procedure Create proc [dbo].[ExcelTag] @TagType int, @TagCode nvarchar(100), @Status bit, @Duration int as if Not exists(Select top 1 TagCode from dbo.[Tag] where TagCode=@TagCode) Begin insert into dbo.[Tag](TagType,TagCode,[Status],Duration)values(@TagType,@TagCode,@Status,@Duration) End