I have database (DB2) with column name (datatype varchar(6000)) xmlemployee where i store xml file info of the file created.
There is no problem in getting xml column from the database. The problem is i have to either loop through the xmlstring (xmlemployee) and get the salary, bonus and other fees from the xml.
Do i need to loop through to get the salary value of using dataset to get the value.
I tried with index of then i get confused that the salary amount may be 4to 10 digits then in that case i have to replace, replace many times if the salary digit is 2 or 3.
Could anyone help me with code sample how to retrieve the salary, bonus from the xml string.