how load data into dropdownlist in asp.net from sql data table

Question

0.00/5 (No votes)

See more:

Hi.

I have one problem that I need the load data from my Sql table into dropdownlist. Data is in date format. I need to load the data in yyyy-MM-dd format without time.

Here is my code

Dim ds As New DataSet
Dim SqlAdp As SqlDataAdapter = New SqlDataAdapter("Select dateofmonthly from PaidDetails where SID='" & Me.txtRegNo.Text & "' and Statuspay='N' order by Nomonths", conn)
SqlAdp.Fill(ds)

Me.cbodate.DataSource = ds.Tables(0).DefaultView
Me.cbodate.DataValueField = "dateofmonthly"
Me.cbodate.DataBind()

conn.Close()

dateofmonthly is in date formate with time. I need date format in dropdown like 2013-10-25

Please help me

Maideen

Posted 25-Aug-13 14:52pm

Maideen Abdul Kader

Add a Solution

Comments

syed shanu 25-Aug-13 21:21pm

Check with Date format in MYSQL
Select DATE_FORMAT(dateofmonthly, '%Y%m%d') from PaidDetails where SID=

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

M.R.A. · Accepted Answer · 2013-08-25T19:21:00

Solution 1

Dim SqlAdp As SqlDataAdapter = New SqlDataAdapter("Select convert(datatime,dateofmonthly,101) from PaidDetails where SID='" & Me.txtRegNo.Text & "' and Statuspay='N' order by Nomonths", conn)

for your required format yyyy-MM-dd you may change 101 to 100 or 102 like this

Posted 25-Aug-13 19:21pm

M.R.A.

Updated 25-Aug-13 19:22pm

v2