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 following code illustrates on how to check if directory exists in specific path, if not then create directory. Here I show that how to create the directory with simple condition. private void TestDirectory() { string pathname = “C:\\Myfolder”; if(!Directory.Exists(pathname)) { Directory.CreateDirectory(pathname); } }
The SQL ALTER TABLE command is used to add, delete or modify columns in an existing table. You can also use the ALTER TABLE command to add and drop various constraints on an existing table. The basic syntax of an ALTER TABLE command to add a New Column in an existing table is as follows.… Read More »
If you need the similar structure of the table with different tablename, it’s better to duplicate r copy the table structure than creating a new table from scratch. It is easy to duplicate the table structure and rename it. Select any database table and right click and click on the option Duplicate Table Structure /Data… Read More »