HOME || ABOUT US || PRODUCTS || CONTACT US || SUBMIT QUERY || FRANCHISE OFFER || ALLIANCES || ORDER STATUS


PRODUCT CATEGORY

<% sql="Select * from ProductCategory" rs.Open sql,db,3,3 if not rs.eof and not rs.bof then while not rs.eof response.write("") rs.movenext wend end if%>
")%>
<% dim category dim page page=trim(request("pid")) if page="" then page=1 end if set rs=nothing if request("prod")="" then Category=Session("Category") else Category=request("prod") Session("Category")=Category end if if category<>"" then dim i set rs=server.CreateObject("ADODB.Recordset") sql="select * from allProd where sl='"&category&"' and pageno='"&page&"'" 'response.write(sql) rs.open sql,db,3,3 %>

Our Products Display: <%if not rs.eof and not rs.bof then%><%=rs(7)%><%end if%>

<% if not rs.eof and not rs.bof then rs.movefirst response.write("") i=0 %> <% while not rs.eof if i=0 then response.write("") end if 'response.write("") rs.movenext i=i+1 if i=5 then response.write("") i=0 end if wend response.write("")%> <% response.write("
Page : <%=page%> Click On Images to Zoom.
") response.write("")%> ','<%=rs(5)%>','<%=rs(6)%>','<%=rs(7)%>'); return false;"> <%=rs(8)%> height=<%=rs(4)%> ><%=""%> <% response.write("
Page: | <%sql="select distinct pageno from allprod where sl='"&category&"'" set rs =server.CreateObject("ADODB.Recordset") rs.open sql,db,3,3 while not rs.eof response.write(""&rs(0)&" | ") rs.movenext wend set rs=nothing %>
") else response.write("No Product Avilable this Time,Please View Other Category ") end if set rs= nothing %>
<%else%>

C.K.Jain Jewellers Pvt. Ltd. offers designs with perfect blend of traditional sense and modern sensibility. Our production team consist of highly skilled artisans, designers and concept developers, many of whom have acquired experience for generations.

We have always perfected excellence in quality by using pure  gold for manufacturing ornaments under strict quality control measures in every sphere of manufacturing process.  We also manufacture to customer's specifications to the highest standard.

WELCOME to our site and browse through some of our creations. <%end if%>


Copyright 2009. C.K. Jain Jewellers Pvt. Ltd.
All Rights Reserved.