Don't re-post your question man. :((
You got around 10+ answers for your previous questions. If you have any doubt then make a comment for answers using
Add comment link below the answer
Just see your question history
http://www.codeproject.com/script/Answers/MemberPosts.aspx?tab=questions&mid=7994901[
^]
EDIT
-----------------------------------------------------------
OP wrote:
"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.)
Read this
Troubleshooting 800a0cc1 Errors[
^]
Don't use
select * from studenttable
. Use
select Column1,Column2,Column3,etc., from studenttable
EDIT2
------------------------------------------------------------
OP wrote:
sir i entered rs.Open("select studentno,studentname,studentcourse from studenttable", connection);again its giving error sir in the following line like this strtable += '<td>' + rs.fields(0) + '</td>' + '<td>' + rs.fields(1) + '</td>' + '<td>' + rs.fields(2) + '</td>' + '<td>' + rs.fields(3) + '</td>' ADODB.Recordset: Item cannot be found in the collection corresponding to the requested name or ordinal.
In your query, you are selecting only
3 columns in your query. But in your code you are trying to get
4 columns. That's the issue. So select the 4th column in your query.