Showing posts with label datas. Show all posts
Showing posts with label datas. Show all posts

Friday, February 24, 2012

display sql datas in xml file with stylesheet

hi,
can any one help me in displaying my sql database datas in an xml file and apply stylesheet to that displayed content.

thanks in advance...You have to learn how to write queries with
FOR XML EXPLICIT close.

Read this article for starters.

http://www.topxml.com/sql/for_xml_explicit.asp

Sunday, February 19, 2012

display programatically images,text in a page

hi everyone.
i want to build a page that all datas,images will store in sql server.
i want to display images,text from database in a page with a template (images left of the page,text near the image and like...,programatically)
there will be very much data . about 500-1000 pages data.
is this possible with sql server?
can SQL server store big datas?
if it is possible can you give me an idea.Yes, it is entirely possible. The method I use on my personal website does not store the image in the db, just the URL to the image. However, it is possible to store binary data in sql. Do a search on google.com and you will find all kinds of tutorials.