SQL server and HTML 2

[tdh2]

Hi,

I would like to know how to select database from MS SQL Server and display the results in HTML.

Thank you.

 

[DotNetGnat]

you cannot do this using plain HTML...you need to use a server side script like ASP or something else...

-DNG

 

[gmmastros]

I'm not sure if this will be too helpful, but...

Lookup [!]sp_MakeWebTask[/!] and [!]sp_RunWebTask[/!] in Books On Line.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[tdh2]

Thanks George

 

[tdh2]

Hi,

I use sp_MakeWebTask as your suggestion.
When I executed query, I am having this error message.
Server: Msg 16822, Level 11, State 1, Procedure sp_makewebtask, line 125.
SQL Web Assistant: Could not open the template file.
Please help.
Thanks,

tdh2

 

[Elegabalus]

Interesting...never knew about sp_MakeWebTask and sp_RunWebTask.

Still, I would strongly recommend that you look into something more robust.

The best place to start would be to take a look at the .NET quickstarts:

http://asp.net/QuickStart/aspnet/Default.aspx,

in particular, the data access sections may help:

http://asp.net/QuickStart/aspnet/doc/data/default.aspx

 

[Geoka]

Thats a new piece of great information.. thx guys