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 »
Wi-Fi or Wireless Fidelity has changed the way Internet is accessed all over the world.This High Speed Wireless technology has allowed people around the world communicate via Internet. But, now scientists from Estonia developed a technology that is 100 times faster than Wi-Fi. Seems unbelievable, right?. A company named Velmenni, based in Tallinn, Estonia, has… 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 »
When you are all set to start a small business, you always end up looking for the chances to save money. But no business can run without Technology. You need computers, smart phones, file storage, a website, and a whole host of other tech assets. More importantly, you need software’s that you use for business… Read More »
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 »