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
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 »
WordPress.com vs WordPress.org is competition where one is good and other one is excellent. Yes WordPress.com is good, its great and WordPress.org is excellent. As we all know WordPress.org is a open source content management system (CMS), means you can download, modify and also distribute it. With this CMS you can create a blog or… 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 »