Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Datagrid Control > SQL select- query analyzer gives results, but it doesn`t work with sqladapter

Reply
Thread Tools

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

 
 
dada
Guest
Posts: n/a
 
      05-18-2004
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
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to query the Address table data of AdventureWorks database from Query Analyzer - need help! Learner ASP .Net 1 01-30-2006 08:58 PM
Build dynamic sql query for JSTL <sql:query> Anonymous Java 0 10-13-2005 10:01 PM
SQLAdapter not returning value lekshmi ASP .Net 3 02-18-2005 11:02 AM
SQL Server timeout mysteries. asp.net=bad, query analyzer=good Simon Devlin ASP .Net 0 01-20-2004 06:48 PM
HELP - exporting database without DTS / Query Analyzer Yovav ASP .Net 0 11-04-2003 10:31 PM



Advertisments
 



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