Professional Web Applications Themes

how to show multiple fields in a listbox? - ASP.NET Building Controls

I have a listbox that is filled with data from a database, but only one field shows. Is it possible to show more fields in a listbox? regards, Arvid...

  1. #1

    Default how to show multiple fields in a listbox?

    I have a listbox that is filled with data from a database, but only one field
    shows.
    Is it possible to show more fields in a listbox?


    regards,

    Arvid
    Arvid Guest

  2. #2

    Default Re: how to show multiple fields in a listbox?

    Yes, set the Rows property to determine the number of rows/items to show in
    the list.


    --
    Hope this helps,
    Mark Fitzpatrick
    Former Microsoft FrontPage MVP 199?-2006

    "Arvid" <microsoft.com> wrote in message
    news:com... 


    Mark Guest

  3. #3

    Default Re: how to show multiple fields in a listbox?

    Arvid wrote: 
    Perhaps you can use the template capability of the listbox. You can then
    put any html you need there.

    intrader Guest

  4. #4

    Default Re: how to show multiple fields in a listbox?

    I have multiple rows, but just one item per row. I would like to see in one
    row/record a name and a address and ... But I have to choose one of them.

    Can I show all?

    --
    regards,

    Arvid


    "Mark Fitzpatrick" wrote:
     
    >
    >
    >[/ref]
    Arvid Guest

  5. #5

    Default Re: how to show multiple fields in a listbox?

    Arvid wrote: 

    Use SQL to combine the fields that you want:
    SELECT field1 + '-' + field2 AS myField FROM myTable;

    --

    Riki


    Riki Guest

  6. #6

    Default Re: how to show multiple fields in a listbox?

    I changed my view like you said (but oracle syntax ) , it seems to be a quick
    and easy way to solve my problem

    thank you

    --
    regards,

    Arvid


    "Riki" wrote:
     
    >
    > Use SQL to combine the fields that you want:
    > SELECT field1 + '-' + field2 AS myField FROM myTable;
    >
    > --
    >
    > Riki
    >
    >
    >[/ref]
    Arvid Guest

Similar Threads

  1. Replies: 4
    Last Post: March 15th, 12:19 PM
  2. Combining 2 Fields Using ListBox.DataTextField
    By Nathan Sokalski in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: November 10th, 08:49 AM
  3. How to: Populate listbox with fields from DB
    By Captain Ru in forum Coldfusion Database Access
    Replies: 4
    Last Post: July 28th, 05:42 PM
  4. Search multiple keywords across multiple fields
    By Darren Heinrich in forum ASP Database
    Replies: 3
    Last Post: February 6th, 05:29 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139