<% Sub ShowStructure() dim objConn,objRs dim fld,totrec set objConn=server.CreateObject("ADODB.Connection") set objRs=server.CreateObject("ADODB.Recordset") 'edit this line with your odbc connection details (can be access or SQL server) objConn.Open "dsn=your_database_name" If lcase(left(trim(sql),6))<>"select" then objConn.Execute sql,totrec 'show the number of records altered by any update or insert Response.Write totrec & " records are affected!" exit sub End If set objRs=objConn.Execute(sql) If err.number=0 then Response.Write " " for each fld in objRs.Fields Response.Write " " & trim(fld.name) & "" next Response.Write " " While not objRs.EOF Response.Write " " for each fld in objRs.Fields Response.Write " " & fld.value & "" next Response.Write " " objRs.Movenext Wend Response.Write " " Response.Write " " Else Exit sub End If End Sub Sub ShowForm() %> <% if request.form("query")="" then Response.Write Request.Cookies("query")("query_screen") else response.write request.form("query") end if %> <% End Sub %> Thanks Nilanka
Is Reporting Service is used for this purposeNo. Reporting Services is for displaying data in report-style formats. You can use it to do updates, but it involves a fair amount of bodging around, and is not really recommended.
Or Can anyone give me brief idea of How to and Where to start?Others have answered this already, but I would suggest learning ASP.NET. It's not going to be a quick fix for you, though.
I am in a trouble...In trouble? Why? For not having the experience / skills to do something that has not yet ever been part of your job? If that's the case, you might want to look around for something else...
THank you in advanceYou're welcome. You know where to find us...
They want me to build like FrontEnd so that they can access it besides looking into SQL Database and manages it....They want to be able to manage the server via the same interface? There's a whole new world of pain opening up right there. Top tip: get some backups going, right now. Schedule them to run regularly. Make sure you know how to recover from them when something goes wrong, because, by the sound of it, it will. Full backup every day, transaction log backups regularly - hourly, every ten minutes, whatever floats your boat. Keep 'em safe. Keep yourself safe. Good luck!
No one has followed this question yet.