How to get the values from the database into an html page using C# .net

[satyaanandandra]

Hi All,

I am using a html page and in that page i have to get the values from the database.

My total application is written in asp.net with c#

only this page is html page

I am not getting how to get the values from the data base (sql server 2005) to the html page. I have to display the values in that page.

how can i achive this ?

Its a very urgent need for me . please help me out

can anyone solve my problem

Thanks in Advance,
Anand

[Curtis Rutland]

Well, you could create another ASP.NET page. In the Page_Load method, you can connect to your DB, retrieve your results, and Response.Write() them as text or xml. Then Response.End();

You can call this page using the XmlHttpRequest javascript object. You can even POST and GET to the asp.net page, so you can set it up to return different results based on the query string you pass it.

[Frinavale]

HTML pages display static content.

Web pages that display information retrieved from a database do not display static content...they display dynamic content. You require Server side code to create these dynamic pages.

This means that you need to create an ASP.NET web application (or web site) with C# code supporting it.

Once you've got the project created, check out the article on how to use a database in your program.

Cheers,

-Frinny