Hi,
this is my datepicker <telerik:RadDatePicker ID="RadReceiveAFCA"
DbSelectedDate='<%# Bind("ReceiveAFCA") %>'
DateInput-DateFormat="dd/mmm/yyyy" SharedCalendarID="sharedCalendar"
Width="100px" runat="server">
<DateInput ID="DateInput1" runat="server" DateFormat ="dd/MM/yyyy" DisplayDateFormat="dd/MM/yyyy" />
</telerik:RadDatePicker>
When i save null date table has mindate. (1/1/1900 ). How can i stop saving min date and save null?
This is my save code
string sqlStr = "update tbl_DATA_Docs set DocuStartP = '" + dtpDocStart.SelectedDate + "' , " +
" DocuStartF = '" + RadDocuStartF.SelectedDate + "' , " +
" DocuEndP = '" + RadDocuEndP.SelectedDate + "' , " +
" DocuStartA = '" + RadDocuStartA.SelectedDate + "' , " +
" DocuEndF = '" + RadDocuEndF.SelectedDate + "' , " +
" DocuEndA = '" + RadDocuEndA.SelectedDate + "' , " +
" SubmitForIDCP = '" + RadSubmitForIDCP.SelectedDate + "' , " +
" SubmitForIDCF = '" + RadSubmitForIDCF.SelectedDate + "' , " +
" SubmitForIDCA = '" + RadSubmitForIDCA.SelectedDate + "' , " +
" ReturnFromIDCP = '" + RadReturnFromIDCP.SelectedDate + "' , " +
" ReturnFromIDCF = '" + RadReturnFromIDCF.SelectedDate + "' , " +
" ReturnFromIDCA = '" + RadReturnFromIDCA.SelectedDate + "' , " +
" IssueForCommentsP = '" + RadIssueForCommentsP.SelectedDate + "' , " +
" IssueForCommentsF = '" + RadIssueForCommentsF.SelectedDate + "' , " +
" IssueForCommentsA = '" + RadIssueForCommentsA.SelectedDate + "' , " +
" ClientReturnedCommentsP = '" + RadClientReturnedCommentsP.SelectedDate + "' , " +
" ClientReturnedCommentsF = '" + RadClientReturnedCommentsF.SelectedDate + "' , " +
" ClientReturnedCommentsA = '" + RadClientReturnedCommentsA.SelectedDate + "' , " +
" ReceiveForCommentsP = '" + RadReceiveForCommentsP.SelectedDate + "' , " +
" ReceiveForCommentsF = '" + RadReceiveForCommentsF.SelectedDate + "' , " +
" ReceiveForCommentsA = '" + RadReceiveForCommentsA.SelectedDate + "' , " +
" IncorporateCommentsP = '" + RadIncorporateCommentsP.SelectedDate + "' , " +
" IncorporateCommentsF = '" + RadIncorporateCommentsF.SelectedDate + "' , " +
" IncorporateCommentsA = '" + RadIncorporateCommentsA.SelectedDate + "' , " +
" IssueForApprovalP = '" + RadIssueForApprovalP.SelectedDate + "' , " +
" IssueForApprovalF = '" + RadIssueForApprovalF.SelectedDate + "' , " +
" IssueForApprovalA = '" + RadIssueForApprovalA.SelectedDate + "' , " +
" ClientReturnFromIFAP = '" + RadClientReturnFromIFAP.SelectedDate + "' , " +
" ClientReturnFromIFAF = '" + RadClientReturnFromIFAF.SelectedDate + "' , " +
" ClientReturnFromIFAA = '" + RadClientReturnFromIFAA.SelectedDate + "' , " +
" ReceiveForComments2P = '" + RadReceiveForComments2P.SelectedDate + "' , " +
" ReceiveForComments2F = '" + RadReceiveForComments2F.SelectedDate + "' , " +
" ReceiveForComments2A = '" + RadReceiveForComments2A.SelectedDate + "' , " +
" IncorporateComments2P = '" + RadIncorporateComments2P.SelectedDate + "' , " +
" IncorporateComments2F = '" + RadIncorporateComments2F.SelectedDate + "' , " +
" IncorporateComments2A = '" + RadIncorporateComments2A.SelectedDate + "' , " +
" IssueForAFCP = '" + RadIssueForAFCP.SelectedDate + "' , " +
" IssueForAFCF = '" + RadIssueForAFCF.SelectedDate + "' , " +
" IssueForAFCA = '" + RadIssueForAFCA.SelectedDate + "' , " +
" ReceiveAFCP = '" + RadReceiveAFCP.SelectedDate + "' , " +
" ReceiveAFCF = '" + RadReceiveAFCF.SelectedDate + "' , " +
" ReceiveAFCA = '" + RadReceiveAFCA.SelectedDate + "' , " +
" OURACTION = '" + RadOURACTION.SelectedDate + "' , " +
" Progress = '" + txtProgress.Text + "' , " +
" CLIENTACTION = '" + RadCLIENTACTION.SelectedDate + "' where DocNo= '" + DocNo + "'";
SqlCommand cmd = new SqlCommand(sqlStr, Conn);
cmd.ExecuteNonQuery();
ltrPlan.Text = "<SPAN style='color=blue'><br>Succesfully Updated<br></SPAN>";
cmd.Dispose();
this is my datepicker <telerik:RadDatePicker ID="RadReceiveAFCA"
DbSelectedDate='<%# Bind("ReceiveAFCA") %>'
DateInput-DateFormat="dd/mmm/yyyy" SharedCalendarID="sharedCalendar"
Width="100px" runat="server">
<DateInput ID="DateInput1" runat="server" DateFormat ="dd/MM/yyyy" DisplayDateFormat="dd/MM/yyyy" />
</telerik:RadDatePicker>
When i save null date table has mindate. (1/1/1900 ). How can i stop saving min date and save null?
This is my save code
string sqlStr = "update tbl_DATA_Docs set DocuStartP = '" + dtpDocStart.SelectedDate + "' , " +
" DocuStartF = '" + RadDocuStartF.SelectedDate + "' , " +
" DocuEndP = '" + RadDocuEndP.SelectedDate + "' , " +
" DocuStartA = '" + RadDocuStartA.SelectedDate + "' , " +
" DocuEndF = '" + RadDocuEndF.SelectedDate + "' , " +
" DocuEndA = '" + RadDocuEndA.SelectedDate + "' , " +
" SubmitForIDCP = '" + RadSubmitForIDCP.SelectedDate + "' , " +
" SubmitForIDCF = '" + RadSubmitForIDCF.SelectedDate + "' , " +
" SubmitForIDCA = '" + RadSubmitForIDCA.SelectedDate + "' , " +
" ReturnFromIDCP = '" + RadReturnFromIDCP.SelectedDate + "' , " +
" ReturnFromIDCF = '" + RadReturnFromIDCF.SelectedDate + "' , " +
" ReturnFromIDCA = '" + RadReturnFromIDCA.SelectedDate + "' , " +
" IssueForCommentsP = '" + RadIssueForCommentsP.SelectedDate + "' , " +
" IssueForCommentsF = '" + RadIssueForCommentsF.SelectedDate + "' , " +
" IssueForCommentsA = '" + RadIssueForCommentsA.SelectedDate + "' , " +
" ClientReturnedCommentsP = '" + RadClientReturnedCommentsP.SelectedDate + "' , " +
" ClientReturnedCommentsF = '" + RadClientReturnedCommentsF.SelectedDate + "' , " +
" ClientReturnedCommentsA = '" + RadClientReturnedCommentsA.SelectedDate + "' , " +
" ReceiveForCommentsP = '" + RadReceiveForCommentsP.SelectedDate + "' , " +
" ReceiveForCommentsF = '" + RadReceiveForCommentsF.SelectedDate + "' , " +
" ReceiveForCommentsA = '" + RadReceiveForCommentsA.SelectedDate + "' , " +
" IncorporateCommentsP = '" + RadIncorporateCommentsP.SelectedDate + "' , " +
" IncorporateCommentsF = '" + RadIncorporateCommentsF.SelectedDate + "' , " +
" IncorporateCommentsA = '" + RadIncorporateCommentsA.SelectedDate + "' , " +
" IssueForApprovalP = '" + RadIssueForApprovalP.SelectedDate + "' , " +
" IssueForApprovalF = '" + RadIssueForApprovalF.SelectedDate + "' , " +
" IssueForApprovalA = '" + RadIssueForApprovalA.SelectedDate + "' , " +
" ClientReturnFromIFAP = '" + RadClientReturnFromIFAP.SelectedDate + "' , " +
" ClientReturnFromIFAF = '" + RadClientReturnFromIFAF.SelectedDate + "' , " +
" ClientReturnFromIFAA = '" + RadClientReturnFromIFAA.SelectedDate + "' , " +
" ReceiveForComments2P = '" + RadReceiveForComments2P.SelectedDate + "' , " +
" ReceiveForComments2F = '" + RadReceiveForComments2F.SelectedDate + "' , " +
" ReceiveForComments2A = '" + RadReceiveForComments2A.SelectedDate + "' , " +
" IncorporateComments2P = '" + RadIncorporateComments2P.SelectedDate + "' , " +
" IncorporateComments2F = '" + RadIncorporateComments2F.SelectedDate + "' , " +
" IncorporateComments2A = '" + RadIncorporateComments2A.SelectedDate + "' , " +
" IssueForAFCP = '" + RadIssueForAFCP.SelectedDate + "' , " +
" IssueForAFCF = '" + RadIssueForAFCF.SelectedDate + "' , " +
" IssueForAFCA = '" + RadIssueForAFCA.SelectedDate + "' , " +
" ReceiveAFCP = '" + RadReceiveAFCP.SelectedDate + "' , " +
" ReceiveAFCF = '" + RadReceiveAFCF.SelectedDate + "' , " +
" ReceiveAFCA = '" + RadReceiveAFCA.SelectedDate + "' , " +
" OURACTION = '" + RadOURACTION.SelectedDate + "' , " +
" Progress = '" + txtProgress.Text + "' , " +
" CLIENTACTION = '" + RadCLIENTACTION.SelectedDate + "' where DocNo= '" + DocNo + "'";
SqlCommand cmd = new SqlCommand(sqlStr, Conn);
cmd.ExecuteNonQuery();
ltrPlan.Text = "<SPAN style='color=blue'><br>Succesfully Updated<br></SPAN>";
cmd.Dispose();