Results 1 to 2 of 2


  1. #1
    madhu Guest


    how can we retrive database in asp pages from msaccess datbase ?i will really appreciate if anyone would let me know about it as i have a table in my ms access and i inserted values in that through asp form but now i want to retrieve all that information again in that form from my table how can i do that?i know we have to use select statement what unable to do?is anyone show me some guidance or any article to do that?thanks bye

  2. #2
    Raqeeb Guest

    Default RE:

    After having data Connection.....I hope U are fine with that part..ok <BR><BR>Set RS = server.createObject("ADODB.recordset")<BR><BR>SQL = "Select * from Tablename where condition"<BR><BR>RS.Open SQL, ,1,2<BR><BR>Set Field1 = RS("First_Field_name")<BR>Set Field2 = RS("Second_Field_name")<BR><BR>Do until RS.EOF<BR><BR>Response.write (" Name : ") & Field1<BR>response.write (" LName: ") & Field2<BR><BR>RS.movenext<BR>Loop<BR><BR>I hope Understood...else

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts