Selecting dates based on to and from dates from filter

add in selectcommand of sqldatasource
  FROM Data
        WHERE Date_of_Entry BETWEEN @Date_of_Entry_From AND @Date_of_Entry_To
full listing:
SelectCommand="
        SELECT
        CONVERT(VARCHAR,
        (CASE
            WHEN Autokey IS NULL THEN
            (SELECT TOP 1 '' AS Autokey FROM Data)
            ELSE Autokey
        END), 1) AS Autokey,
        CONVERT(VARCHAR,
        (CASE
            WHEN Province IS NULL THEN
            (SELECT TOP 1 '' AS Province FROM Data)
            ELSE Province
        END), 1) AS Province,
        CONVERT(VARCHAR,
        (CASE
            WHEN District IS NULL THEN
            (SELECT TOP 1 '' AS District FROM Data)
            ELSE District
        END), 1) AS District,
        CONVERT(VARCHAR,
        (CASE
            WHEN Hospital IS NULL THEN
            (SELECT TOP 1 '' AS Hospital FROM Data)
            ELSE Hospital
        END), 1) AS Hospital,
        CONVERT(VARCHAR,
        (CASE
            WHEN Caterer_Name IS NULL THEN
            (SELECT TOP 1 '' AS Caterer_Name FROM Data)
            ELSE Caterer_Name
        END), 1) AS Caterer_Name,
        CONVERT(CHAR(11),
        (CASE
            WHEN Date_of_Entry IS NULL THEN
            (SELECT TOP 1 '' AS Date_of_Entry FROM Data)
            ELSE Date_of_Entry
        END), 106) AS Date_of_Entry,
        CONVERT(VARCHAR,
        (CASE
            WHEN No_of_Daigs IS NULL THEN
            (SELECT TOP 1 '' AS No_of_Daigs FROM Data)
            ELSE No_of_Daigs
        END), 1) AS No_of_Daigs,
        CONVERT(VARCHAR,
        (CASE
            WHEN Food_Item IS NULL THEN
            (SELECT TOP 1 '' AS Food_Item FROM Data)
            ELSE Food_Item
        END), 1) AS Food_Item,
        CONVERT(VARCHAR,
        (CASE
            WHEN No_of_Rotis IS NULL THEN
            (SELECT TOP 1 '' AS No_of_Rotis FROM Data)
            ELSE No_of_Rotis
        END), 1) AS No_of_Rotis,
        CONVERT(VARCHAR,
        (CASE
            WHEN No_of_Bene_Male IS NULL THEN
            (SELECT TOP 1 '' AS No_of_Bene_Male FROM Data)
            ELSE No_of_Bene_Male
        END), 1) AS No_of_Bene_Male,
        CONVERT(VARCHAR,
        (CASE
            WHEN No_of_Bene_Female IS NULL THEN
            (SELECT TOP 1 '' AS No_of_Bene_Female FROM Data)
            ELSE No_of_Bene_Female
        END), 1) AS No_of_Bene_Female,
        CONVERT(VARCHAR,
        (CASE
            WHEN Daily_Cost_Per_Person IS NULL THEN
            (SELECT TOP 1 '' AS Daily_Cost_Per_Person FROM Data)
            ELSE Daily_Cost_Per_Person
        END), 1) AS Daily_Cost_Per_Person,
        CONVERT(VARCHAR,
        (CASE
            WHEN Acc_Exp IS NULL THEN
            (SELECT TOP 1 '' AS Acc_Exp FROM Data)
            ELSE Acc_Exp
        END), 1) AS Acc_Exp
        FROM Data
        WHERE Date_of_Entry BETWEEN @Date_of_Entry_From AND @Date_of_Entry_To
        "
then add
<SelectParameters>
            <asp:ControlParameter Name="Date_of_Entry_From" ControlID="FTR_Date_of_Entry_From" />
            <asp:ControlParameter Name="Date_of_Entry_To" ControlID="FTR_Date_of_Entry_To" />
        </SelectParameters>

Selecting WEEK in T-SQL to display as a col in GV

CONVERT(CHAR(11),
        (CASE
            WHEN Date_of_Entry IS NULL THEN
            (SELECT TOP 1 '' AS Date_of_Entry FROM Data)
            ELSE Date_of_Entry
        END), 106) AS Date_of_Entry,
        CASE
            WHEN Date_of_Entry = '01 Jan 1900' THEN
            (SELECT TOP 1 '' AS Date_of_Entry FROM Data)
            ELSE DATENAME(WEEKDAY, Date_of_Entry)
        END AS Week,
The key command here is WEEKDAY

Selecting null instead of 0 or 01/01/1900 in int and date columns in FV

  Protected Sub FormView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView1.DataBound
        If FormView1.CurrentMode = FormViewMode.ReadOnly Then
            Dim tmp_LBL1 As Label
            tmp_LBL1 = CType(FormView1.FindControl("No_of_DaigsLabel"), Label)
            Dim str_tmp_LBL1 As String = tmp_LBL1.Text
            If str_tmp_LBL1 = "0" Then
                tmp_LBL1.Text = ""
            End If
        End If
    End Sub

Setting date in textbox onfocus

Despite focus property not supported by textbox control, it seems to work both in FF in IE
<asp:TextBox ID="Date_of_EntryTextBox" runat="server" onfocus="this.value='test';"
Text='<%# Bind("Date_of_Entry") %>' Width="473px" Font-Names="Arial" Font-Size="9pt" />
Another method would be to just allow the textbox to display the current date on page_load and then when validating at end during insert / edit, omit the date field when checking if all fields are empty.

Inserting date automatically in textbox on focus and removing it on non-focus in FV aswell as showing guiding temporary text

In Formview1.Inserting()
REM Handling Auto Current Date Insert in FV Insert
REM Adding guiding text again after removing it for inserting
Dim tmp_Date_of_EntryTextBox As TextBox
tmp_Date_of_EntryTextBox = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
If FormView1.CurrentMode = FormViewMode.Insert Then
tmp_Date_of_EntryTextBox.Text = "Type 'd' to enter Today's Date..."
End If
In Formview1.Databound()
REM Handling Auto Current Date Insert in FV Insert
REM Adding guiding text to textbox
If FormView1.CurrentMode = FormViewMode.Insert Then
Dim tmp_Date_of_EntryTextBox As TextBox
tmp_Date_of_EntryTextBox = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
tmp_Date_of_EntryTextBox.Text = "Type 'd' to enter Today's Date..."
End If
REM Handling Auto Current Date Insert in FV Insert
If FormView1.CurrentMode = FormViewMode.Insert Then
Dim tmp_Date_of_EntryTextBox As TextBox
tmp_Date_of_EntryTextBox = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
REM Clearing guiding text in textbox on FIRST focus
REM Adding javascript onfocus and changing value to Nothing in textbox
REM Using ternary operator to see if guiding text is present, then clear it, else not.
tmp_Date_of_EntryTextBox.Attributes.Add("onfocus", "javascript:((this.value == 'Type \'d\' to enter Today\'s Date...') ? (this.value = '') : (null));")
REM Adding javascript onkeyup and changing value to current date in textbox through ShowTime() function defined in aspx
REM Using ternary operator to see if key pressed is 'd', then insert current date, else not.
tmp_Date_of_EntryTextBox.Attributes.Add("onkeyup", "javascript:((this.value == 'd') ? (this.value = ShowTime()) : (null));")
REM Adding javascript onblur (lost focus) and changing value to guiding text if textbox is empty, else not.
tmp_Date_of_EntryTextBox.Attributes.Add("onblur", "javascript:((this.value == '') ? (this.value = 'Type \'d\' to enter Today\'s Date...') : (null));")
End If
In Insertbutton.click()
REM Handling Auto Current Date Insert in FV Insert
REM Checking if guiding text is present and if so, removing it before insert
If FormView1.CurrentMode = FormViewMode.Insert Then
Dim tmp_Date_of_EntryTextBox As TextBox
tmp_Date_of_EntryTextBox = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
If tmp_Date_of_EntryTextBox.Text = "Type 'd' to enter Today's Date..." Then
tmp_Date_of_EntryTextBox.Text = ""
End If
End If
In .aspx <head>
<head runat="server">
<link href="Gridview_StyleSheet.css" rel="stylesheet" type="text/css" />
<title>Lungar Project Online Portal</title>
<link rel="SHORTCUT ICON" href="~/Images/favicon.ico" />
<script type="text/javascript">
function ShowTime() {
// REM Handling Auto Current Date Insert in FV Insert
var dt = new Date();
var d = "0"
var m = "0"
var y = "0"
// Converting month to MMM format and assigning it to variable
if (dt.getMonth() == "0")
{
var m = "Jan"
}
if (dt.getMonth() == "1")
{
var m = "Feb"
}
if (dt.getMonth() == "2")
{
var m = "Mar"
}
if (dt.getMonth() == "3")
{
var m = "Apr"
}
if (dt.getMonth() == "4")
{
var m = "May"
}
if (dt.getMonth() == "5")
{
var m = "Jun"
}
if (dt.getMonth() == "6")
{
var m = "Jul"
}
if (dt.getMonth() == "7")
{
var m = "Aug"
}
if (dt.getMonth() == "8")
{
var m = "Sep"
}
if (dt.getMonth() == "9")
{
var m = "Oct"
}
if (dt.getMonth() == "10")
{
var m = "Nov"
}
if (dt.getMonth() == "11")
{
var m = "Dec"
}
// Getting day and assigning it to variable
d = dt.getDate()
// Getting full year and assigning it to variable
y = dt.getFullYear()
// Returning back to Formview1.databound()
return d + " " + m + " " + y
}
</script>
</head>

Method below works but causes problems due to autopostback in textbox which causes the button to be pressed twice to work
In textchanged()
Protected Sub Date_of_EntryTextBox_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs)

REM Handling Auto Current Date Insert in FV Insert mode
REM Upon pressing of key 'd', current date shall be inserted automatically
REM Make sure that of the textbox, Autopostback = true, Enableviewstate=true.
REM Text will change upon entering 'd' and then pressing tab.
Dim tmp_Date_of_EntryTextBox As TextBox
tmp_Date_of_EntryTextBox = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
If FormView1.CurrentMode = FormViewMode.Insert Then
If tmp_Date_of_EntryTextBox.Text = "d" Or tmp_Date_of_EntryTextBox.Text = "D" Then
tmp_Date_of_EntryTextBox.Text = Date.Now.ToString("dd MMM yyyy")

End If
End If

REM Handling Auto Current Date Insert in FV Insert mode
REM Removing guiding text COMPLETELY from textbox after first focus
REM Removing javascript onfocus
tmp_Date_of_EntryTextBox.Attributes.Remove("onfocus")

End Sub
In FV databound()
REM Handling Auto Current Date Insert in FV Insert mode
REM Adding guiding text to textbox
If FormView1.CurrentMode = FormViewMode.Insert Then
Dim tmp_Date_of_EntryTextBox As TextBox
tmp_Date_of_EntryTextBox = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
tmp_Date_of_EntryTextBox.Text = "Press 'd' then 'TAB' for Today's Date..."
End If

REM Handling Auto Current Date Insert in FV Insert mode
REM Clearing guiding text in textbox on FIRST focus
If FormView1.CurrentMode = FormViewMode.Insert Then
Dim tmp_Date_of_EntryTextBox As TextBox
tmp_Date_of_EntryTextBox = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
REM Adding javascript onfocus and changing value to Nothing in textbox
tmp_Date_of_EntryTextBox.Attributes.Add("onfocus", "javascript:this.value = '';")

End If
In Insertbutton_click()
Protected Sub InsertButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)
REM Handling showing of Calendar control
Session.Add("session_cal", "dontShow")

REM Handling Auto Current Date Insert in FV Insert mode
REM Checking if guiding text is present and if so, removing it before insert
If FormView1.CurrentMode = FormViewMode.Insert Then
Dim tmp_Date_of_EntryTextBox As TextBox
tmp_Date_of_EntryTextBox = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
If tmp_Date_of_EntryTextBox.Text = "Press 'd' then 'TAB' key to enter Today's Date..." Then
tmp_Date_of_EntryTextBox.Text = ""
End If
End If

End Sub

Using javascript in asp.net

In .vb of asp.net
tmp_Date_of_EntryTextBox.Attributes.Add("onkeyup", "javascript:((this.value == 'd') ? (this.value = ShowTime()) : (null));")
In .aspx of asp.net
<script type="text/javascript">
function ShowTime() {
// REM Handling Auto Current Date Insert in FV Insert
var dt = new Date();
var d = "0"
var m = "0"
var y = "0"
// Converting month to MMM format and assigning it to variable
if (dt.getMonth() == "0")
{
var m = "Jan"
}
if (dt.getMonth() == "1")
{
var m = "Feb"
}
if (dt.getMonth() == "2")
{
var m = "Mar"
}
if (dt.getMonth() == "3")
{
var m = "Apr"
}
if (dt.getMonth() == "4")
{
var m = "May"
}
if (dt.getMonth() == "5")
{
var m = "Jun"
}
if (dt.getMonth() == "6")
{
var m = "Jul"
}
if (dt.getMonth() == "7")
{
var m = "Aug"
}
if (dt.getMonth() == "8")
{
var m = "Sep"
}
if (dt.getMonth() == "9")
{
var m = "Oct"
}
if (dt.getMonth() == "10")
{
var m = "Nov"
}
if (dt.getMonth() == "11")
{
var m = "Dec"
}
// Getting day and assigning it to variable
d = dt.getDay()
// Getting full year and assigning it to variable
y = dt.getFullYear()
// Returning back to Formview1.databound()
return d + " " + m + " " + y
}
</script>