c# - Searching Gridview by Date, but the Calendar control picker (that is DateTime) includes the date and also the time, example: 2013-01-01 00:00:00.000 -

-

i have gridview should populated according selected date, made use of calendar control.

the problem

  • since calendar control's selected date datetime, unfortunately selected date in calendar seems in format: dd-mm-yyy
    example 2013-02-15
  • while date field in database of type datetime meaning: dd-mm-yyyy hh:mm:ss.ms
    example 2013-02-15 09:02:03.253

so there no result since calendar control , database field of different types.


what tried

sqldatasource1.selectcommand = "select * table1 start_date '% " & calendar1.selecteddate.date & " %' "

as can see worked sqldatasource in code behind , made use of like use of like no results show due database having not date time too.

i thinking change sql query itself, , precisely field start_date, omit time (hh:mm:ss.ms) possible so?


edit:

even if calendar control's selected date , field in database both datetime, search won't work because when searching calendar control query date , time example 2013-01-01 00:00:00.000 while in db time not 00:00:00 need of between answer below.

you can use date extract records database using datetime field. dont think using on dates idea. specify , date ranges 1 day worth of data:

sqldatasource1.selectcommand = "select * table1 start_date >" & calendar1.selecteddate.date & " , start_date < " & calendar1.selecteddate.date.adddays(1)

or using between operator:

sqldatasource1.selectcommand = "select * table1 start_date between " & calendar1.selecteddate.date & " , " & calendar1.selecteddate.date.adddays(1)

Comments

Post a Comment

Popular posts from this blog

javascript - Image onload event not firing in firefox -

-
i'm creating image preloader. works fine in browsers except firefox (testing firefox 10.0). input array of images called image_list . these images appended dynamically body of document , load callback attached, calls function update_progress . code follows: $(image_list).each(function() { var x = $('<img />') .load(function() {update_progress(percent_loaded += step);}) .attr('src', this) .appendto('body') .css('display', 'none'); .each(function() { if(this.complete) update_progress(percent_loaded += step); }); }); in firefox, load callback , update_progress never called. yet exact same code works fine in chrome , other browsers i've tested. there way detect when image has loaded in firefox? i first check see whether image has height, checking height property. if (the_image.height > 0) { // image loaded (possibly cached) } if have cached ...
Read more

android - getbluetoothservice() called with no bluetoothmanagercallback -

-
i getting getbluetoothservice() called no bluetoothmanagercallback error in android application. i have no idea causing or bluetooth manager callbacks. can give me idea of causing problem or start looking. by reading android source code, seems warning cannot about. source code shows if call bluetoothsocket#connect(); then call bluetoothadapter.getdefaultadapter().getbluetoothservice(null); the key here, null parameter passes in above line. due this, there no callback, , bluetoothsocket class throw out warning. since warning, not think need it. https://android.googlesource.com/platform/frameworks/base/+/master/core/java/android/bluetooth/bluetoothsocket.java line 306 https://android.googlesource.com/platform/frameworks/base/+/master/core/java/android/bluetooth/bluetoothadapter.java line 1610
Read more

sql - ASP.NET SqlDataSource, like on SelectCommand -

-
i'm working on asp.net. have sqldatasource query hardcoded on selectcommand: <asp:sqldatasource id="datasource1" runat="server" cancelselectonnullparameter="false" connectionstring="<%$ connectionstrings:s.properties.settings.connectionstring %>" selectcommand="select * [table] ([col1] case @col1_param when null col1 else @col1_param end) , ([col2] case @col2_param when null col2 else @col2_param end)" selectcommandtype="text"> <selectparameters> <asp:controlparameter controlid="textbox1" name="col1_param" propertyname="text" type="string" /> <asp:controlparameter controlid="textbox2" name="col2_param" propertyname="text" type="string" /> </selectparameters> what want if enter data on 1 textbox only, data display according textbox...
Read more