
Heey
I have a strange error when i try to uppdate my data in db an Error appears( Value of '0001-01-01 00:00:00' is not valid for 'SelectedDate'. 'SelectedDate' should be between 'MinDate' and 'MaxDate'. Parameter name: SelectedDate)
Story: I have a grid in in my UserEditPanel where i try to create users that works perfectly but in this same UserEditPanel there is a little gird where you can add (with new record button) FromDate ToDate WorkingTime and VacationDays for one user that is in same time how to say in creation . if I try to save/update it wont it just reset only in the fields FromDate and ToDate to (0001-01-01 00:00:00') some help would be just awesome btw i'm working with Viewstate
I think that the error appears in this part of the code and i really dont know what is wrong here ...
<telerik:RadDatePicker ID="fromdatepicker" runat="server" DbSelectedDate='<%# Eval("FromDate") == null ? null : Eval("FromDate") %>' TabIndex="4">
</telerik:RadDatePicker>
</td>
</tr>
<tr>
<td>To</td>
<td>
<telerik:RadDatePicker ID="todatepicker" runat="server" DbSelectedDate='<%# Eval("ToDate") == null ? null :Eval("ToDate")%>'
TabIndex="4">
</telerik:RadDatePicker>
<asp:Button ID="btnUpdate" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>' runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'></asp:Button> </div> </td> <td> <asp:Button ID="btnCancel" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancle" OnClick="btnCancel_Click"></asp:Button> </td> </tr> </table> </FormTemplate> </EditFormSettings> </MasterTableView> <FilterMenu EnableImageSprites="False"> </FilterMenu> </telerik:RadGrid> </telerik:RadAjaxPanel> </div> <div class="BackAndSave"> <telerik:RadButton ID="rbBack" CssClass="rowButton" runat="server" Text="Back" OnClick="rbBack_Clicked" CausesValidation="false" /> <telerik:RadButton ID="rbSave" CssClass="rowButton" runat="server" Text="Save" OnClick="rbSave_Clicked" />protected void rgAnnualVacation_UpdateCommand(object sender, GridCommandEventArgs e) { try { GridEditableItem item = e.Item as GridEditableItem; Hashtable values = new Hashtable(); item.ExtractValues(values); AnnualVacation editedAnnualVacation = new AnnualVacation(); item.UpdateValues(editedAnnualVacation); //newAnnualVacation.IsNew = true; List<AnnualVacation> annualVacationSource = (List<AnnualVacation>)ViewState["AnnualVacationSource"]; AnnualVacation existingAnnualVacation = annualVacationSource.Where(av => av.AnnualVacationId == editedAnnualVacation.AnnualVacationId).FirstOrDefault(); existingAnnualVacation.WorkingTime = editedAnnualVacation.WorkingTime; existingAnnualVacation.VacationDays = editedAnnualVacation.VacationDays; //Set values to zero when update existingAnnualVacation.FromDate = editedAnnualVacation.FromDate; existingAnnualVacation.ToDate = editedAnnualVacation.ToDate; } catch { //Hier fehlermeldung } }Hi,
I am using RegularExpressionValidator for validating email id for a particular company. ValidationExpression=\\w+([-+.']\\w+)*@ABCCompany.com working for only first email id, i need to validate more than one email. I found in online ValidationExpression="((\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*)*([;])*)*", its working fine but i have to validate for ABCCompany.com. I tried also CustomValidator server side validation, its working code wise but its not showing error message.
Can you please anybody solve my problem.
My HTML Code:
-------------
<
telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="false" CellPadding="0" CellSpacing="0" GridLines="None" HorizontalAlign="Left" ShowFooter="true" AllowPaging="true" PageSize="10" AllowMultiRowSelection="true" OnItemCommand="RadGrid1_OnItemCommand" OnNeedDataSource="RadGrid1_OnNeedDataSource" OnInsertCommand="RadGrid1_OnInsertCommand" OnUpdateCommand="RadGrid1_OnUpdateCommand" OnDeleteCommand="RadGrid1_OnDeleteCommand" AllowSorting="true">
<PagerStyle Position="Bottom" AlwaysVisible="true" />
<ValidationSettings EnableValidation="true" ValidationGroup="products" />
<MasterTableView CommandItemDisplay="Top" HorizontalAlign="NotSet" AutoGenerateColumns="False" DataKeyNames="id">
<Columns>
<telerik:GridTemplateColumn DataField="Product_ID" FilterControlAltText="Filter Product_ID column" HeaderText="Product_ID" UniqueName="Product_ID" SortExpression="Product_ID">
<HeaderStyle HorizontalAlign="Center" />
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<asp:Label ID="lblProduct_ID" runat="server" Text='<%# Bind("Product_ID") %>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn DataField="Product_Email" FilterControlAltText="Filter Product_Email column"
HeaderText="Product Email" UniqueName="Product_Email" SortExpression="Product_Email">
<HeaderStyle HorizontalAlign="Left" />
<ItemStyle HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblProduct_Email" runat="server" Text='<%# Bind("Product_Email") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tbProduct_Email" runat="server" Text='<%# Bind("Product_Email") %>'
Width="500px"></asp:TextBox> (Note: Enter multiple emails with ; separator)
<asp:RequiredFieldValidator ID="rfvtbProduct_Email" runat="server" ControlToValidate="tbProduct_Email"
ErrorMessage="Please enter Product Email" ForeColor="Red" ValidationGroup="products"></asp:RequiredFieldValidator>
<%
--<asp:RegularExpressionValidator ID="revtbProduct_Email" runat="server" ControlToValidate="tbProduct_Email"
ErrorMessage="Enter only valid ABCCompany Emails" ForeColor="Red" ValidationExpression="\\w+([-+.']\\w+)*@ABCCompany.com"
ValidationGroup="products"></asp:RegularExpressionValidator>--%>
<asp:CustomValidator ID="cvtbProduct_Email" runat="server" ControlToValidate="tbProduct_Email"
ForeColor="Red" ErrorMessage="Enter only valid ABCCompany Emails" OnServerValidate="cvtbProduct_Email_OnServerValidate"
ValidationGroup="products" EnableClientScript="false" Display="None"></asp:CustomValidator>
</EditItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</telerik:GridEditCommandColumn>
<telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" Text="Delete"
UniqueName="DeleteColumn">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</telerik:GridButtonColumn>
</Columns>
<EditFormSettings ColumnNumber="1" CaptionDataField="Product_id" CaptionFormatString="Edit properties of Product ID: {0}" InsertCaption="Product ID:">
</EditFormSettings>
</MasterTableView>
<ClientSettings EnableRowHoverStyle="true">
</ClientSettings>
</telerik:RadGrid>
Severside validation Code:
--------------------------
protected void cvtbProduct_Email_OnServerValidate(object sender, ServerValidateEventArgs args)
{
bool valid;
string[] email = new string[100];
TextBox EmailList = (TextBox)RadGrid1.MasterTableView.GetInsertItem().FindControl("Product_Email");
if (EmailList.Text != "")
{
if (EmailList.Text.Contains(";"))
email = EmailList.Text.Split(';');
else
email[0] = EmailList.Text;
for (int i = 0; i < email.Length; i++)
{
if (email[i] != null)
{
valid = Regex.IsMatch(email[i], "\\w+([-+.']\\w+)*@ABCCompany.com");
if (!valid)
{
args.IsValid = false;
}
else
args.IsValid = true;
}
}
}
}
Thanks,
Swetha.

i am using version 2012.2.607.35
