Category C#.Net

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

Category: C#.Net Comments: No comments

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 projectRead More

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

Category: C#.Net Comments: No comments

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 projectRead More

Get list of files from SFTP using Winscp(Version 5.5.4) in C#

Category: C#.Net Comments: No comments

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 BinaryRead More

Delete Rows from DataTable Using Linq in C#

Category: C#.NetLINQ Comments: No comments

Delete Rows from DataTable Using Linq in C#Read More

Update Field Value in DataTable using Linq in C#

Category: C#.NetLINQ Comments: No comments

Update Field Value in DataTable using Linq in C#Read More

Unzip compressed folder in C# using 4.0 framework

Category: C#.Net Comments: No comments

Use System.IO.Compression.FileSystem.dll which exist in C:\Windows\Microsoft.NET\assembly\GAC_MSIL\System.IO.Compression.FileSystem\v4.0_4.0.0.0__b77a5c561934e089 Namespace Name :- using System.IO.Compression.FileSystem Read More

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

Category: ASP.NETC#.Net Comments: No comments

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 More

Read File from FTP location in Console Application using C#

Category: C#.Net Comments: No comments

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"]); Read More

CasCading DropDownList using Array in Asp.net

Category: ASP.NETC#.Net Comments: No comments

Sometimes we need to do fill dropdownlist using Array(2 Dimensional and 3 Dimensional) For Static Value in Asp.net Explanation given below: Design Page:
Code Page: protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack)Read More

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

Category: ASP.NETC#.Net Comments: 4 comments

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) EndRead More