You can use WinForms DataGridView control for doing CRUD operations. Your data source can be anything like an SQL Server database, JSON or Ms-Excel. Here in this post I am sharing a small program in ...
Ms-Excel is still one of the most popular applications used all over the world by enterprises, big and small. Using Excel, you can now maintain complex data structures, create graphs and more. You can ...
You can easily modify data in an Excel file from your Windows Forms, popularly known as WinForms. In fact, you can do many things like read, edit and add data to your Excel file from WinForms. Here ...
You must be aware of the AutoFormat feature in Excel, which allow users to format a sheet (or a particular range) with various formatting options. Don’t worry if you have not come across it yet, ...
The Windows Forms “CheckedListBox” control is used to display data in a list format which allows users to check or uncheck the items in the listbox. By default, it shows a small square box before each ...
Microsoft’s .Net framework allows us get a list of network and local printers, installed at the server side. These methods are typically applicable and used on the Intranet or using Window’s ...
Single row or multiple rows can be transferred from one DataGridView to another with help of few lines of code. Why would somebody do that? We have come across a situation where we had to upgrade ...
DataGridView control is used to display data in tabular format. Its use is not limited to just displaying data, but it’s a perfect tool for doing data manipulation by binding it with a database. With ...
Data in an Excel file can be manipulated using Vb.Net without even opening the file. With few steps this can be done. Previously we have created Excel file from Vb.Net with auto formating technique ...
Data can be exported to an excel sheet in Vb.Net using Microsoft.Office.Interop.Excel namespace. Though it’s a classic example, exporting data into an excel file can be useful when you want to share ...