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 Mike Lewis 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
Sep 4, 2001
756
0
0
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

G12Consult
  • Locked
  • Question
Javascript from Content Pages
Replies
0
Views
246
G12Consult
G12Consult
G12Consult
  • Locked
  • Question
Retrieve data from JSON
Replies
1
Views
252
gmmastros
gmmastros
stinkybee
  • Locked
  • Question
getting DropDownList Value from ListView InsertItemTemlate
Replies
1
Views
97
jbenson001
jbenson001
ahm1985
  • Locked
  • Question
select item from city not fill items in district drop down linq
Replies
0
Views
61
ahm1985
ahm1985
engsalah2018
  • Locked
  • Question
How to get label text from table reference on database based on TableName and FieldName
Replies
2
Views
262
jbenson001
jbenson001

Part and Inventory Search

Sponsor

Back
Top