SQL select- query analyzer gives results, but it doesn`t work with sqladapter

Discussion in 'ASP .Net Datagrid Control' started by dada, May 18, 2004.

  1. dada

    dada Guest

    Hello,

    I want to add in my dropdownlist extra item for ex. : at first "Chose"
    and than my select. I know that I can add that when ddl is not in
    datagrid using :
    ddl.Items.Insert(0, "Chose"), but mu ddl is in the datagrid and I
    don`t know how to aproach to it.
    Another solution is by using SQL

    SELECT 'Chose' As Naziv, -1 AS IDPredmeta Union
    Select Naziv, IDPredmeta From Predmeti

    and when I put this sellect to query analyzer I get results, but when
    I give it to sqladapter as selectcommand it gives 0 results.

    Thank you for answering
    dada, May 18, 2004
    #1
    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. Yovav
    Replies:
    0
    Views:
    531
    Yovav
    Nov 4, 2003
  2. Simon Devlin
    Replies:
    0
    Views:
    688
    Simon Devlin
    Jan 20, 2004
  3. lekshmi

    SQLAdapter not returning value

    lekshmi, Feb 10, 2005, in forum: ASP .Net
    Replies:
    3
    Views:
    401
    Patrick Olurotimi Ige
    Feb 18, 2005
  4. Learner
    Replies:
    1
    Views:
    984
    Marina Levit [MVP]
    Jan 30, 2006
  5. Anonymous
    Replies:
    0
    Views:
    1,459
    Anonymous
    Oct 13, 2005
Loading...

Share This Page