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. Advertisements

  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. Advertisements

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. DC Gringo
    Replies:
    0
    Views:
    563
    DC Gringo
    Apr 6, 2004
  2. kent
    Replies:
    1
    Views:
    1,040
    Andrew de la Harpe
    May 3, 2004
  3. Simon Prince
    Replies:
    2
    Views:
    3,591
    =?Utf-8?B?TWljaGFlbCBUYXlsb3I=?=
    Oct 19, 2004
  4. Chris Kettenbach

    Listbox selection to populate another listbox?

    Chris Kettenbach, Jun 15, 2005, in forum: ASP .Net
    Replies:
    3
    Views:
    1,883
    Chris Kettenbach
    Jun 16, 2005
  5. bh_jodokast

    Drag from one listbox to another listbox

    bh_jodokast, Oct 7, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    540
    bh_jodokast
    Oct 7, 2005
  6. COHENMARVIN
    Replies:
    1
    Views:
    724
    =?Utf-8?B?U3JlZWppdGggUmFtKE1DU0QuTkVUKQ==?=
    Oct 14, 2005
  7. John Dalberg

    drag & drop from listbox to listbox?

    John Dalberg, Feb 21, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    985
    =?Utf-8?B?RFdT?=
    Feb 21, 2006
  8. DC Gringo

    click listbox and refresh another listbox

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