self.grid_1.CreateGrid(r, 4)#this is to create the grid with same rows as database
    self.grid_1.SetColLabelValue(0, _("ID"))
    self.grid_1.SetColSize(0, 12)
    self.grid_1.SetColLabelValue(1, _("NAME"))
    self.grid_1.SetColSize(1, 150)
    self.grid_1.SetColLabelValue(2, _("SURNAME"))
    self.grid_1.SetColSize(2, 150)
    self.grid_1.SetColLabelValue(3, _("NUMBER"))

NAME Surname Number
A       V      55
B       C      45

ID    NAME Surname Number
1      A       V      55
2      B       C      45