1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

doesn't show table fields ?

Discussion in 'C#' started by nivas_kumar, Jul 14, 2008.

0
  1. #1
    plz help me i am working asp with msacces. how to display all the colums in the table in asp. if i put following query "show membertable.colums" it doesn't display.
     
    nivas_kumar, Jul 14, 2008 IP
  2. saurabhj

    saurabhj Banned

    Messages:
    3,459
    Likes Received:
    61
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I am not getting you. Will you please explain it in details so that we can help you.
     
    saurabhj, Jul 14, 2008 IP
  3. dylanj

    dylanj Peon

    Messages:
    173
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    0
    #3
    I don't know exactly what you are trying to do, but the script below will show all of the columns in the [Customers] table in the Northwind database:

    
<%
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
conn.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\databases\northwind.mdb;")
rs.Open "SELECT * FROM [Customers]", conn
For Each x In rs.Fields
  Response.Write(x.Name & "<br>")
Next
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
%>
    Code (markup):
    Try that code. That should help :)
     
    dylanj, Jul 14, 2008 IP
  4. nivas_kumar

    nivas_kumar Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    yes above script working. I need what you done in the above post. thank you. Now working fine. .:p
     
    nivas_kumar, Jul 14, 2008 IP