The best and easiest way to convert csv file to excel file is here. This is the method I implemented and it is working fine. Hope you all implement it. private void Convert_CSV_To_Excel(string filename) { // Rename .csv To .xls System.IO.File.Move( filename , filename .Replace(“.csv”, “.xls”)); var _app = new MX.Application(); var _workbooks = _app.Workbooks;… Read More »
Hi Guys Here I will show you how to disable the close button in windows form application in C# Declare the constant variable : private const int CP_NOCLOSE_BUTTON = 0x200; Now, define protected override method as shown: protected override CreateParams CreateParams { get { CreateParams myCp = base.CreateParams; myCp.ClassStyle = myCp.ClassStyle | CP_NOCLOSE_BUTTON; return myCp;… Read More »
Happy Coding Guys 🙂 Here am defining the structure of the class and declaring the list of that particular class. I am using a select statement and adding the data returned from the database to that particular list. Defining Connection string in Notepad file and common method to connect to multiple databases How to change… Read More »
Happy Coding Guys 🙂 The below is a notepad (.ini) file to define the connection string Below is the method to connect to multiple databases How to check if directory exists in specified path and then create directory How to Open dynamically specific extension file from a directory
You can track the deleted folders in Windows Application by using FileSystemWatcher Class. 1) First add System.IO.FileSystem.Watcher.dll library. 2) Next Write the code as shown below. 3) If you need to track all the subdirectories which are deleted. The below code is important. fileSystemWatcher.IncludeSubdirectories = true; 4) Write the source code as… Read More »
In this post you can see how to select all the items in checkedlistbox using c#.net Please check on the image As in the image, you add checkbox and checkedlistbox to the windows form and write code in CheckedChanged event of checkbox How to change default icon in… Read More »
In this post you can see two different ways to fix size of window form. Please click on the image 1- Set FormBorderStyle property to FixedSingle or FixedDialog. 2- Set MaximumSize -width and height property to fix the size of form. … Read More »
The below is a notepad(.ini) file to define the connection string Below is the method to connect to multiple databases
The source code to show how to delete files from directory or any folder Please Check on the Code below : You can also check here for Copying Files from Source to Destination Path In the below method we can define the number of paths (inside the Folderpaths.ini file) where the directory files are to… Read More »
Copying Files from Source to Destination Path The following is the code to backup files and folders from source to destination path