Gridview and listbox

Discussion in 'ASP .Net Web Controls' started by AKJTR, Mar 24, 2006.

  1. AKJTR

    AKJTR Guest

    I have a one to many sql query and would like to show the many in a listbox
    in a gridview with the row showing the one record. I know how to get the
    data intoa gridview but can't figure out how to get the data into a listbox
    in a template columun. Clear as mud?

    Here's my sql statement

    SELECT gs_bid_info.gbi_bid_number, gs_bid_amendments.gba_bid_number,
    gs_bid_info.gbi_fiscal_year, gs_bid_info.gbi_bid_desc,
    gs_bid_info.gbi_issue_date, gs_bid_amendments.gba_amendment_date FROM
    gs_bid_amendments RIGHT OUTER JOIN gs_bid_info ON
    gs_bid_amendments.gba_bid_number = gs_bid_info.gbi_bid_number

    I get back multiple gba_amendment_date and want them to be in a listbox in
    the end columun of my datarow in a gridview.

    tia
     
    AKJTR, Mar 24, 2006
    #1
    1. Advertising

  2. http://www.webswapp.com/codesamples/aspnet20/dependentlists/gridview.aspx

    --
    HTH,
    Phillip Williams
    http://www.societopia.net
    http://www.webswapp.com


    "AKJTR" wrote:

    > I have a one to many sql query and would like to show the many in a listbox
    > in a gridview with the row showing the one record. I know how to get the
    > data intoa gridview but can't figure out how to get the data into a listbox
    > in a template columun. Clear as mud?
    >
    > Here's my sql statement
    >
    > SELECT gs_bid_info.gbi_bid_number, gs_bid_amendments.gba_bid_number,
    > gs_bid_info.gbi_fiscal_year, gs_bid_info.gbi_bid_desc,
    > gs_bid_info.gbi_issue_date, gs_bid_amendments.gba_amendment_date FROM
    > gs_bid_amendments RIGHT OUTER JOIN gs_bid_info ON
    > gs_bid_amendments.gba_bid_number = gs_bid_info.gbi_bid_number
    >
    > I get back multiple gba_amendment_date and want them to be in a listbox in
    > the end columun of my datarow in a gridview.
    >
    > tia
     
    Phillip Williams, Mar 24, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. blenderdude
    Replies:
    0
    Views:
    1,149
    blenderdude
    Aug 3, 2003
  2. DC Gringo
    Replies:
    0
    Views:
    421
    DC Gringo
    Apr 6, 2004
  3. kent
    Replies:
    1
    Views:
    909
    Andrew de la Harpe
    May 3, 2004
  4. Simon Prince
    Replies:
    2
    Views:
    3,383
    =?Utf-8?B?TWljaGFlbCBUYXlsb3I=?=
    Oct 19, 2004
  5. DC Gringo

    click listbox and refresh another listbox

    DC Gringo, Apr 6, 2004, in forum: ASP .Net Building Controls
    Replies:
    0
    Views:
    158
    DC Gringo
    Apr 6, 2004
Loading...

Share This Page