Loading

datagridview

Calculate column in DataGridView

Submitted by: 
admin
Saturday, January 21, 2012 - 01:01
Language: 
Visual Basic .NET

In this simple source code you will learn on how to calculate the column (for example Amount column) in a DataGridView control. I have similar tutorial on this about “How to Calculate Two Columns in DataGridView“ but it lacks a grand total on the Amount column.

Additionally the tutorial I have made before don’t have a sample source code so I decided to create one.

Export Datagridview to Excel

Submitted by: 
cedrick blas
Friday, February 5, 2010 - 13:25
Language: 
Visual Basic .NET

Export Datagridview to Excel + Simple Database Query( Add, update, Delete, Search)
Hope You Like It Guys :)

How to Configure ComboBox in DataGridView

Wednesday, December 9, 2009 - 22:34
Language: 
Visual Basic .NET

I feel it would be necessary to create a tutorial on how I program the ComboBox in DataGridView. So, this tutorial will guide you on how to:

  1. Add DataSet
  2. Create a master/detail form
  3. Add ComboBox in DataGridView

How to add a DataSet

1. Click on the Data Sources.

2. Click Add New Data Source.

ComboBox in DataGridView

Submitted by: 
admin
Tuesday, December 8, 2009 - 22:37
Language: 
Visual Basic .NET

Learn how master/detail form works in Visual Basic .NET 2008. The detail form or the DataGridView control contain a ComboBox that looks up record from Products table.

For the tutorial please read How to Configure ComboBox in DataGridView.

Display Record in DataGridView Based on ComboBox Selected Value

Thursday, December 3, 2009 - 21:54
Language: 
Visual Basic .NET

In this tutorial I will teach you on how to display related record based on the selection value from a ComboBox.

The example displays a student’s subject in a DataGridView after a SelectedIndexChanged event of a ComboBox.

This tutorial assumes that you already know how to add a DataSet in your project.

The following are important steps in order to understand how I made this simple program.

1. Bind a ComboBox

[inline:ComboBox_Data_Binding.jpg=Bind a ComboBox]

2. Add a query in the Course Table under DataSet designer

CheckBox in DataGridView

Submitted by: 
admin
Saturday, October 24, 2009 - 22:23
Language: 
Visual Basic .NET

In this program I will teach you on how to validate a CheckBox control before the value are change inside a DataGridView.

I have tested all the events and only DataGridView CellMouseDown can do this. The point here is to validate first if the user really want to change the value of a CheckBox to true. If not then the value of a CheckBox will revert to false.

The important code in this program is:

DataGridView Control with MySQL

Submitted by: 
admin
Wednesday, August 5, 2009 - 18:19
Language: 
Visual Basic .NET

I received a lot of email if I can make a tutorial on how to connect VB.NET with MySQL. So here it is. I am planning to continue this tutorial that is similar on my previous article on Database Programming Made Easy. The only difference with the previous one is that I will be using MySQL instead of MS Access and MS SQL Server.

This tutorial will teach you how to connect Visual Basic .NET 2008 to MySQL Server v5.0. I used DataGridView Control as the model of this tutorial.

How to Bind Data to the Windows Forms DataGridView Control

Saturday, June 27, 2009 - 23:05
Language: 
.NET

[inline:DataGridView Control.jpg=How to Bind Data to the Windows Forms Datagridview Control]

The DataGridView control provides a customizable table for displaying data. The DataGridView class allows customization of cells, rows, columns, and borders through the use of properties such as DefaultCellStyle, ColumnHeadersDefaultCellStyle, CellBorderStyle, and GridColor. (Source: MSDN)

Pages