If recall correctly, you don't need .net at all. Your windows workstation should have IIS ready, and SQL server admin guy probably knows the plugin I talked about. I used it in 2002, I will check my archive files if needed...

nicetomeetyou(_)

Don't have time to google now, but will check.....

I remember:

a. wrote style sheets .xsl files and save them in local directory.
b. wrote several statements in htm,

each statement (1) included a call to the plugin, and plugin forwards the call to SQL server stored procedure to get XML string, then (2) use XSLT engine combining xsl file to get html segment, you then integrate those html segments into a complete html page.

The plugin of SQL server acts like the web service gateway from database, very neat.

If you are interested, I will test a solution tomorrow at office.

What is the solution Indian told you?

(#5021495@0)
Last Updated: 2009-2-2
This post has been archived. It cannot be replied.

sigh ....... -win(秋天的菠菜); 2009-2-2 (#5020662@0)

too simple? there are many ways, but I would like to hear about the best technology, which is efficient, flexible, scalable, secure, cost effective and industry standard. -superseven11321(0dfa427); 2009-2-2 (#5020679@0)

这个问题很模糊啊。 -bdbs(别的不算); 2009-2-2 (#5020711@0)

I need to create about 50 static html pages to display data say interest rates, term, product, the data source is sql server 2000, using .Net desktop application, non-Web, I am looking for a best solution, thanks! -superseven11321(0dfa427); 2009-2-2 (#5020735@0)

static html : no data source; data source: no static html. Got it? -tjhong(我检讨); 2009-2-2 (#5020738@0)

got it, thanks. but I still need to embed data into html pages, there is no any connection between datasource and html pages, the data has to be added in html pages thru desktop application. -superseven11321(0dfa427); 2009-2-2 (#5020842@0)

* sigh ....... -win(秋天的菠菜); 15:47 (#5020662@0) -bdbs(别的不算); 2009-2-2 (#5020757@0)
为安全起见, 建议弄它50几个图片显示, 谁也改不了. 为提高显示速度, 可选黑白的JPEG -coolmao(酷猫*Fremen); 2009-2-2 (#5020766@0)

grerat idea, but how to dump data to a jpeg file? -superseven11321(0dfa427); 2009-2-2 (#5020853@0)

System.Drawing.Bitmap.Save(Response.OutputStream, Imaging.ImageFormat.Jpeg) -coolmao(酷猫*Fremen); 2009-2-2 (#5020869@0)

你眼瞎阿？Response.OutputStream 是在 Desktop Application 里面用的吗？在Response.OutputStream 里能设计data layout ？你白痴阿？谢谢 -superseven11321(0dfa427); 2009-2-2 (#5020988@0)

酷猫疯掉了 -246(246); 2009-2-2 (#5021076@0)

sigh ....... -win(秋天的菠菜); 15:47 (#5020662@0) -bdbs(别的不算); 16:20 (#5020757@0) -tjhong(我检讨); 2009-2-2 (#5021261@0)

今天好不容易喝口汤, 一大半喂键盘了. 怪我, 见什么人说什么话惯了. 要不, 你试试 System.IO.File.OutputStream 吧, 怎么着也得弄出它50多个图片出来. -coolmao(酷猫*Fremen); 2009-2-2 (#5021371@0)

I have got a solution from an Indian guy, sounds not bad and professional, is it ture that India is more better than China in IT area? was I in a wrong place, IT guys here in this forum are garbage? -superseven11321(0dfa427); 2009-2-2 (#5021413@0)

问题严重了, 已经上升到事关民族荣誉的程度了..... -coolmao(酷猫*Fremen); 2009-2-2 (#5021446@0)
不要贬低同胞啦，老印的方案是什么？ -nicetomeetyou(_); 2009-2-2 (#5021462@0)

老印也提到XML，但没你的具体，只是你的需要安装插件什么的，不懂。我的任务只是提供一些包含数据的，HMLT格式下的表格，不需要从HTML里面动态调用任何数据原 -superseven11321(0dfa427); 2009-2-2 (#5021479@0)

哈哈，另一半汤是不是喂下面那张嘴了？谢谢了，俺先试验牛牛的办法，不行的话再请教你啊。 -superseven11321(0dfa427); 2009-2-2 (#5021490@0)

if each page is not so big, you can use stringbuilder to compose html & a dataset for pages. (simple use loop to do it) save to file system with name like "xxx.htm" -whereismyid(到处找ID); 2009-2-2 (#5021372@0)

thanks, I would not post the question here if this is the good solution, thx anyways -superseven11321(0dfa427); 2009-2-2 (#5021402@0)

create a PDF file regarding a dataset. then embed this PDF into html. -whereismyid(到处找ID); 2009-2-3 (#5021732@0)

(1) Create stored proc in SQL Server, wrap data into XML string and output it. (2) Through SQL Server IIS plug-in, you can call stored proc directly from .htm in IE, use XSLT to produce html. (3) Those calls are parallel-processed, very fast. -nicetomeetyou(_); 2009-2-2 {135} (#5021438@0)

Don't quite remember exactly the name of SQL server plug-in for IIS, and default xslt engine which IE uses. But I will check tomorrow.

虽然少，还是有牛人。不过有个问题，我只负责提供一些包含数据的HTML文件给IT部门，其他数据库，web 服务器等我都管不了，也就是说我没办法安装任何插件，我能做的只是.Net Desktop App and pull data from SQL server, 这样的话，你的办法也行吗？多谢！ -superseven11321(0dfa427); 2009-2-2 (#5021467@0)

If recall correctly, you don't need .net at all. Your windows workstation should have IIS ready, and SQL server admin guy probably knows the plugin I talked about. I used it in 2002, I will check my archive files if needed... -nicetomeetyou(_); 2009-2-2 {637} (#5021495@0)
Don't have time to google now, but will check.....

I remember:

a. wrote style sheets .xsl files and save them in local directory.
b. wrote several statements in htm,

each statement (1) included a call to the plugin, and plugin forwards the call to SQL server stored procedure to get XML string, then (2) use XSLT engine combining xsl file to get html segment, you then integrate those html segments into a complete html page.

The plugin of SQL server acts like the web service gateway from database, very neat.

If you are interested, I will test a solution tomorrow at office.

What is the solution Indian told you?

老印也提到XML，style sheet, 但没你的具体。我提供的数据网页，不能和任何数据库连的，只是给别人off line看，只是HMLT格式下的表格，不需要从HTML里面动态调用任何数据原，怎么办？ -superseven11321(0dfa427); 2009-2-2 (#5021502@0)

OK, if I understand your word "off-line" correctly, there are two ways I can think of now to make it happen: -nicetomeetyou(_); 2009-2-2 {440} (#5021510@0)
(1) Create a scheduled job in windows system to connect to SQL server through ODBC periodically to get data, file them in pre-defined format.

(2) Create a scheduled job in SQL server calling a local package, dumps data into your local drive through network( your SQL schedule agent in windows service must have network access), in pre-defined format.

Then your static html loads/shows them.

In offline mode, data may be outdated.

exactlly, how to dump data to a pre-defined format (in html) is what I am asking. you won't suggest to code html table tags line by line for each dump. -superseven11321(0dfa427); 2009-2-3 (#5021517@0)

Then creating a scheduled job in SQL server will be handy, there will be two steps in the job, -nicetomeetyou(_); 2009-2-3 {248} (#5021526@0)
the first step dumps data wrapped into xml format, the second step loads native xslt engine (need to check the exact app name), input xml text file produced in the first step, and another input of a predefined xsl file, output html file in the end.

Thanks Niu, I will give it a try. -superseven11321(0dfa427); 2009-2-3 (#5022903@0)

哇, 牛哥用过SQLXML啊. 几年前是很先进的东东. -coolmao(酷猫*Fremen); 2009-2-3 (#5021974@0)

Datasource =>Xml + XSLT => html -deep_blue(BLUE); 2009-2-3 (#5021837@0)

Thanks! -superseven11321(0dfa427); 2009-2-3 (#5022905@0)

There are millions way to do it. -iwantcar_majia(iwantcar); 2009-2-3 (#5022930@0)

@Florida

If recall correctly, you don't need .net at all. Your windows workstation should have IIS ready, and SQL server admin guy probably knows the plugin I talked about. I used it in 2002, I will check my archive files if needed...

Replies, comments and Discussions:

More Topics