i have taken a html page my task was i have taken a button and table in html page ,my task is "when clicked on button table in sqlserver must display in html table using javascript("i have written a piece of code its not executing please edit my code so that i can execute")
"my code is as follows"
"errormessage of my code":(ADODB.Recordset: Item cannot be found in the collection corresponding to the requested name or ordinal
Om prakash SinghPosted Aug 9, 2011, 6:49 AM
If(Request.Form("hdn")="yes" then
dim strtable,rs,connection,connectionstring
connection = server.createobject("ADODB.Connection")
connectionstring = "Persist Security Info=False;Data Source=xxxxxx;Initial Catalog=xxxx;User ID=sa;Password=xxxx;Provider=SQLOLEDB"
connection.Open(connectionstring)
rs=server.createobject("ADODB.Recordset")
rs.Open("select * from studenttable", connection);
rs.MoveFirst
strtable= strtable & '
while (!rs.eof)
Begin
strtable= strtable &'
strtable= strtable & '
strtable= strtable &'
rs.movenext;
loop
strtable= strtable & '
rs.close;
connection.close;
End If
%>
<%=strtable %>