Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting only Month from db into drop down 1

Status
Not open for further replies.
qwert231

qwert231

Programmer
Joined
Sep 4, 2001
Messages
756
Location
US
I want to get a list of months from my database. I want my drop down list to show only months that have orders. I have SQL query to get the number of the month, but how can I convert it to text?

Mark Kenyon II
 
Sort by date Sort by votes
Modify your query to get month name:
Code: 
select DATENAME(month, table.datefield) AS 'MonthName' from table
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

chikwendu
  • Locked
  • Question Question
Mouse jumps to DropDownList when clicking a button
Replies
0
Views
375
chikwendu
chikwendu
G12Consult
  • Locked
  • Question Question
Javascript from Content Pages
Replies
0
Views
983
G12Consult
G12Consult
G12Consult
  • Locked
  • Question Question
Retrieve data from JSON
Replies
1
Views
1K
gmmastros
gmmastros
stinkybee
  • Locked
  • Question Question
getting DropDownList Value from ListView InsertItemTemlate
Replies
1
Views
504
jbenson001
jbenson001
ahm1985
  • Locked
  • Question Question
select item from city not fill items in district drop down linq
Replies
0
Views
269
ahm1985
ahm1985

Part and Inventory Search

Sponsor

Back
Top