按日期搜索使用2dropdownlist year&单日期coloumn的月份 [英] search by date by using 2dropdownlist year & month with single Date coloumn

问题描述

           DATE 
 
Jul/16/2013 Tue  02:22:57 PM  
Jul/17/2013 wed  02:22:57 PM
Jul/18/2013 thur  02:22:57 PM
Jul/19/2013 fri  02:22:57 PM

i had a DB field like this,

by using this i need to search item. 
one ddl box contains "Year" another ddl box contains "Month"    and click search button
by using these how i can search the items, what is the condition??? can any one helps me  

推荐答案

Dim Strdate As String
        If Not String.IsNullOrEmpty(ddlmonth.SelectedValue) Then
            Strdate = ddlCustomer.SelectedValue
        End If
        If Not String.IsNullOrEmpty(ddlyear.SelectedValue) Then
            Strdate = Strdate & ddlProject.SelectedValue
        End If

这篇关于按日期搜索使用2dropdownlist year&单日期coloumn的月份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！