Hello, I basically have a table in my SQL server full of information. What I want is to bring all that info to be displayed also on my website. Being able to connect it from me html page, or php page, whatever, also ASP. Can anyone help me with this, thnx.
Refer http://www.connectionstrings.com for how to connect to SQL Server from ASP Use Recordset to capture data and using While loop display them in the format you want
I don't know how to make SQL code work inside of ASP. I tried it with php and sounds really easy, but since this stuff is using asp I really don't know.
but it's still sql stuff, i just need to know ther right integration with asp. If I go to asp sites they will tell me it's a sql matter, so im stuck. pleas
1. write the SQL code to collect the data you want. 2. use the connection string stuff to enable your asp to connect to the specific server type. 3. execute a call to the sql code (1)...either saved as a SQL SP or as in-line code (not advised) 4. use asp logic to loop through returned data from (3)....
you've to mix both worlds...we can only supply 1. buying/reading a book/attending classes is also a good starting point.
Bringing SQL to the web
Forum Locked
Posted - 09/21/2005 : 03:48:04
