i am not be able to show GA - availability status. i am using web service. from last few days its not show. its upload diamond but status not shown.
this is heading
Dim FileContent As String = "StockNumber,Shape,Weight,Color,Clarity,RapNet Discount,Cut,Lab,ClientRowID, " & _
"Polish, Symmetry , Fluorescence Intensity ,Fluorescence Color ,Fancy Color ,FancyColor Intensity ," & _
"FancyColor Overtone, Measurements , Certificate #, depth,Table,Comment,Availability,City,Country"
This is my code ...
Dim sqlstring = "Select ShapeShortName,PolishWeight,Colourname,PurityName,DiamondImage,DiscPrct,CutShortName,LabShortName," & _
"FancyColourName,FancyColourIntensity,FancyColourOvertone,PolishType,SymmName,FluoShortName,FluoColour," & _
"Measurements,CertiNumber,DepthPrct,TablePrct,Remark,Brown,Milky,Natts,NetrepRate,'GA' as Avil,'Mumbai' as City,'India' as Country " & _
"from StockMaster where Barcode='" & BarCode & "'"