[RESOLVED] DataTable and GridView - Validate when user enters something

[akhileshbc]

Hi guys

I'm playing with XML, DataGridView control, DataSet and DataTable.
Here's my code:

Imports System.Xml
Imports System.Data
 
Public Class Form1
    Dim dt As DataTable
    Dim ds As New DataSet
 
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
 
        dt = New DataTable("product")
        dt.Columns.Add(New DataColumn("Product_ID", Type.GetType("System.Int32")))
        dt.Columns.Add(New DataColumn("Product_Name", Type.GetType("System.String")))
        dt.Columns.Add(New DataColumn("product_Price", Type.GetType("System.Int32")))
        fillRows(1, "product1", 1111)
        fillRows(2, "product2", 2222)
        fillRows(3, "product3", 3333)
        fillRows(4, "product4", 4444)
        ds.Tables.Add(dt)
 
        ds.DataSetName = "company"
 
        DataGridView1.DataSource = dt
        
    End Sub
 
    '~~~ To fill sample rows
    Private Sub fillRows(ByVal pID As Integer, ByVal pName As String, ByVal pPrice As Integer)
        Dim dr As DataRow
        dr = dt.NewRow()
        dr("Product_ID") = pID
        dr("Product_Name") = pName
        dr("product_Price") = pPrice
        dt.Rows.Add(dr)
    End Sub
 
    '~~~ Save as XML    
    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        ds.WriteXml("c:\Product.xml")
        MsgBox("Done")
    End Sub
 
End Class

My question is, the user can edit/add records via DataGridView control. So, when the user enters a string value where it is expected to give an integer value(first column and third column), it would give a big error message. Instead of showing that, I would like to apply custom validations.

How would I do it ?

Thanks