Hello there,
Can somebody please guide me how to manage this situation. I have a listgrid with 5 columns. 4 cols are integer and 1 is string. Now I have a excel sheet from where I am copying the col and trying to paste in my sgwt listgrid. Now the problem i have is in excel all the col are string,so when i copy the numbers from there into my listgrid i get validation error - "Must be whole number." the reason is there are comma in the numbers in the excel sheet. Is there some way I can convert them to integer in my listgrid so i can save it to my db.
cheers
Zolf
Can somebody please guide me how to manage this situation. I have a listgrid with 5 columns. 4 cols are integer and 1 is string. Now I have a excel sheet from where I am copying the col and trying to paste in my sgwt listgrid. Now the problem i have is in excel all the col are string,so when i copy the numbers from there into my listgrid i get validation error - "Must be whole number." the reason is there are comma in the numbers in the excel sheet. Is there some way I can convert them to integer in my listgrid so i can save it to my db.
cheers
Zolf
Comment