Calendar Extender SelectedDate Working with null values

Question

0.00/5 (No votes)

See more:

I am having an issue with binding data to a Calendar Extender when null values are in the database. I have tried different things and can not get it to work. The below gives me a

ASP.NET

<td>
    <asp:TextBox ID="DateQualifiedTextBox" runat="server"
        Text='<%# Bind("DateQualified")  %>' />
    <asp:CalendarExtender ID="DateQualifiedTextBox_CalendarExtender" runat="server"
    Enabled="True" TargetControlID="DateQualifiedTextBox" SelectedDate='<%# IF(not IsDBNull(Bind("DateQualified")), Bind("DateQualified")  %>' >


</td>

But I get the following:
Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30451: 'Bind' is not declared. It may be inaccessible due to its protection level.

Source Error:

C#

Line 310:                    <asp:TextBox ID="DateQualifiedTextBox" runat="server" 
Line 311:                        Text='<%# Bind("DateQualified")  %>' />
Line 312:                    <asp:CalendarExtender ID="DateQualifiedTextBox_CalendarExtender" runat="server" 
Line 313:                    Enabled="True" TargetControlID="DateQualifiedTextBox" SelectedDate='<%# IF(not IsDBNull(Bind("DateQualified")), Bind("DateQualified")  %>' > 
Line 314:

Posted 11-Dec-11 16:49pm

Andy Morris

Updated 11-Dec-11 16:58pm

Monjurul Habib

v2

Add a Solution

Comments

Andy Morris 12-Dec-11 7:45am

I tried the Eval also but I get the following error:
Server Error in '/' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30691: 'Nullable' is a type in 'System' and cannot be used as an expression.

Source Error:

Line 310: <asp:TextBox ID="DateQualifiedTextBox" runat="server"
Line 311: Text='<%# Bind("DateQualified") %>' />
Line 312: <asp:CalendarExtender ID="DateQualifiedTextBox_CalendarExtender" runat="server"
Line 313: Enabled="True" TargetControlID="DateQualifiedTextBox" SelectedDate='<%# IF(not IsDBNull(Eval("DateQualified")), Eval("DateQualified") %>' >
Line 314:

Source File: C:\Users\Andy\Desktop\PKL_QMWh\PKL_QMW\PersonnelMain.aspx Line: 312

2 solutions

Solution 1

instead of Bind can please try with Eval()

Posted 11-Dec-11 23:04pm

Sudip Saha

Comments

Andy Morris 13-Dec-11 20:17pm

I tried the Eval also but I get the following error:
Server Error in '/' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30691: 'Nullable' is a type in 'System' and cannot be used as an expression.

Source Error:

Line 310: <asp:TextBox ID="DateQualifiedTextBox" runat="server"
Line 311: Text='<%# Bind("DateQualified") %>' />
Line 312: <asp:CalendarExtender ID="DateQualifiedTextBox_CalendarExtender" runat="server"
Line 313: Enabled="True" TargetControlID="DateQualifiedTextBox" SelectedDate='<%# IF(not IsDBNull(Eval("DateQualified")), Eval("DateQualified") %>' >
Line 314:

Source File: C:\Users\Andy\Desktop\PKL_QMWh\PKL_QMW\PersonnelMain.aspx Line: 312

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andy Morris · Accepted Answer · 2011-12-21T17:31:00

Okay I finally have this working now using some script and OnClientShowing

<script type="text/javascript" language="javascript">

function showDate(sender,args)
{
if(sender._textbox.get_element().value == "")
{
var todayDate = new Date();
sender._selectedDate = todayDate;
}
}
</script>

<asp:textbox id="DateQualifiedTextBox" runat="server" xmlns:asp="#unknown">
Text='<%#Bind("DateQualified" , "{0: MM/dd/yyyy}") %>' />
<asp:calendarextender id="DateQualifiedTextBox_CalendarExtender" runat="server">
Enabled="True" TargetControlID="DateQualifiedTextBox" OnClientShowing="showDate" >