UC知道dropdownlist绑定一个dataset日期字段的问题，在线等，谢谢
来源：百度知道 编辑：UC知道 时间：2024/06/05 09:26:44
我想把dropdownlist绑定一个dataset日期字段，字段的值不重复，我的数据库中的date类型是长时间，如：2005-7-5 10:07:09，我想调用出来是2005-7-5短日期的，而且2005-7-5只出现一次，不管这天有多少时间段.
我用select distinct date from ,可是字段中的日期还是重复的，有多个2006-5-6。
代码如下：
Private Sub DropDownList2_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList2.Init
Dim a As String = "select distinct date from history_sp"
Dim aadptb As New OleDbDataAdapter(a, myoledbcon)
myoledbcon.Open()
Dim datasetb As New DataSet
aadptb.Fill(datasetb)
DropDownList2.DataSource = datasetb
DropDownList2.DataTextField = "date"
DropDownList2.DataValueField = "date"
DropDownList2.DataBind()
myoledbcon.Close()
End Sub
我用select distinct date from ,可是字段中的日期还是重复的，有多个2006-5-6。
代码如下：
Private Sub DropDownList2_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList2.Init
Dim a As String = "select distinct date from history_sp"
Dim aadptb As New OleDbDataAdapter(a, myoledbcon)
myoledbcon.Open()
Dim datasetb As New DataSet
aadptb.Fill(datasetb)
DropDownList2.DataSource = datasetb
DropDownList2.DataTextField = "date"
DropDownList2.DataValueField = "date"
DropDownList2.DataBind()
myoledbcon.Close()
End Sub
"select distinct FormatDateTime(date1,2) from history_sp"
把SQL语句改成这个，然后再把下面的
DropDownList2.DataTextField = "date"
DropDownList2.DataValueField = "date"
改成
DropDownList2.DataTextField = "date1"
DropDownList2.DataValueField = "date1"
就可以了
这样行不行
select distinct cdate(date) from history_sp