.NET doesn't have a Date type... only a DateTime. You will need to handle this by formatting your front-end display code.

>I put a DropDownList on a form. Included in the Page_Load method is the following code

>        If Not IsPostBack Then
>                    .
>                    .
>
>            Dim strConn As String = CType(Me.Master, MasterPage).connectString
>            Dim objConn As New MySqlConnection(strConn)
>            Dim objDS As New DataSet
>
>            Dim strSql As String
>            strSql = "SELECT DISTINCT savedate FROM kpi_mrpactionsvalue " & _
>                     "  ORDER BY savedate DESC LIMIT 10"
>
>            Dim daDates As New MySqlDataAdapter(strSql, objConn)
>            daDates.Fill(objDS, "dtDates")
>
>            For Each rowDate In objDS.Tables("dtDates").Rows
>                ddlDates.Items.Add(rowDate("savedate"))
>            Next
>
>                    .
>                    .

>
>This works the way I expect (the DDL is populated with the correct 10 dates)
>
>The next step is to try and bind the DDL to an SqlDataSource. I commented out the Page_Load code and configured the DataSource as follows

>< asp:DropDownList ID="ddlDates" runat="server" Height="20px" Width="107px" 
>       DataSourceID="mysqldatasource" DataTextField="savedate" 
>       DataValueField="savedate" >
> < /asp:DropDownLis t >
>
>< asp:SqlDataSource ID="mysqldatasource" runat="server" 
>       ConnectionString="< %$ ConnectionStrings:ConnectionString % >" 
>       ProviderName="< %$ ConnectionStrings:ConnectionString.ProviderName % >" 
>       SelectCommand="select distinct savedate from kpi_mrpactionsvalue order by savedate desc limit 10" >
>< /asp:SqlDataSource >

>
>This also produces a DDL with the correct 10 dates. However, the values show up as DateTime. The Time portion is 12:00:00 AM for all the rows in the DDL. The backend is MySql and I've verified that the field in question is actually a Date rather than a DateTime (I did a visual verification and I also put the SelectCommand as a parameter into a VFP SQLEXEC command with the resulting cursor having Date values)
>
>Any explanation and code corrections gratefully appreciated.............Rich