C#

void repriceQuedataGridView1_CellParsing(object sender,
                                         DataGridViewCellParsingEventArgs e)
{
    try
    {
        // Validate entered value by converting to column's type. Note that 
        // Convert.ChangeType doesn't handle Nullable types. Also, DataGridView 
        // doesn't support setting the value to null within the CellParsing 
        // event. To work around this requires creating a derived cell that 
        // overrides the ParseFormattedValue method. For this example, assume
        // that the user should not enter nulls.

        object convertedValue = Convert.ChangeType(e.Value, e.DesiredType);
    }
    catch
    {
        // Validation failed. Alert user.

        MessageBox.Show("Please try again. Expected type is " + 
                        e.DesiredType.ToString());

        // The CurrentCell still contains the pre-edit value. If the 
        // previous value was a null, then restoring the null will lead
        // to another exception (because still in CellParsing event). 
        // Attempt to work around the problem by setting the current cell's 
        // value to an empty string. This works for some types (e.g. DateTime) 
        // but not for others (e.g. Double).

        DataGridView gridView = (DataGridView)sender;

        if (Convert.IsDBNull(gridView.CurrentCell.Value))
        {
            gridView.CurrentCell.Value = string.Empty;
        }

        // Set arg value to current cell's value and mark parsing applied.

        e.Value = gridView.CurrentCell.Value;
        e.ParsingApplied = true;
    }
}

Archyami wrote:

But how about the one for SQL Server 2000?