Category - DataGridView
Results 21 - 25 of 69
01 Jun 2018 01 Jun 2018 0 Comments  5650 Views
Here Mudassar Ahmed Khan has explained with an example, how to read (import) Excel file without using OLEDB or installing Microsoft Office Excel or Interop Library in C# and VB.Net.

The Excel file will be read using ClosedXml and OpenXml DLLs which does not require OLEDB and does not require Microsoft Office Excel or Interop Library software to be installed.
01 Jun 2018 01 Jun 2018 0 Comments  7956 Views
Here Mudassar Ahmed Khan has explained with an example, how to export DataGridView data to Excel file with formatting i.e. Colors and Styles in Windows Forms (WinForms) Applications using C# and VB.Net.

DataGridView cannot be exported directly to Excel file and hence need to generate a DataTable and export the DataTable to Excel file.

The DataTable will be exported to a formatted Excel file using ClosedXml library which is a wrapper of OpenXml.
31 May 2018 31 May 2018 0 Comments  3741 Views
Here Mudassar Ahmed Khan has explained with an example, how to read and import Excel file data to DataGridView using ClosedXml using C# and VB.Net in Windows Forms (Winforms) Application.
04 Apr 2018 04 Apr 2018 0 Comments  2827 Views
Here Mudassar Ahmed Khan has explained with an example, how to Filter DataGridView using Multiple CheckBoxes in Windows Forms Application using C# and VB.Net.

By default the DataGridView will show all records. As soon as user selects a CheckBox, the records will be searched in Database and the DataGridView rows will be filtered in Windows Forms (WinForms) Application using C# and VB.Net.
27 Mar 2018 27 Mar 2018 0 Comments  5854 Views
Here Mudassar Ahmed Khan has explained with an example, how to upload, insert and display Images using the Path stored in database in DataGridView in Windows Forms (WinForms) Application using C# and VB.Net.

Image files will be uploaded using OpenFileDialog and then will be saved into a Folder (Directory) on disk. The Path of the saved files will be inserted into SQL Server Database Table.

The saved (inserted) Image files will be retrieved and displayed in DataGridView in Windows Application using C# and VB.Net.
Results 21 - 25 of 69