I have added the UDF in my excel template(C#) using excel addin classlibrary,but i can not use that function in custom validation when i use the UDF in custom validation of xcel(data->validation->dropdownlist(custom))i get an error as:
You can not use references to other worksheeta or workbooks for data validation criteria.
Is there any solution to this this problem? Can we use UDF in custom validation of excel...?
I am trying to create a custom password validation attribute which has these requirements
1. cannot be empty.
2. doesn't contain space or other special chracters, which I'll define later.
3. length is between 6 - 12
[Code]....
it works fine on the server-side but I'd like to make this work on the client side as well, so I created a PasswordAttributeAdapter class
[Code]....
and in global.asax I added
[Code]....
Custom Validation Attribute is not called by validation mechanism?
[Code]....
ViewModel
[Code]....
I've been trying to get a custom validator component working that ensures at least one checkbox from a checkboxlist has been checked. I've been used some code I found on dotnetjunkies.com but the client-side validation didn't work. I've been attempting to modify it to get the client-side javascript validation to work with no luck. Basically, I compile the below code into a DLL and add it to my bin folder.
[Code]....
I've got a custom control with asp:hyperlinks that's causing validation which I don't want... Is there anyway I can stop this from happening?
View 1 RepliesWhen to go for custom validation control and when to do validation in javascript? What are pros and cons of each of them?
View 3 Repliesobjws is Microsoft.Office.Interop.Excel.Worksheet object
ObjWs.get_Range("F2", "G100").Validation.Add(Microsoft.Office.Interop.Excel.XlDVType.xlValidateDate, Excel.XlDVAlertStyle.xlValidAlertStop, Excel.XlFormatConditionOperator.xlGreaterEqual, TODAY(), Type.Missing);
ObjWs.get_Range("F2", "G100").Validation.IgnoreBlank = true;
[Code]....
the above colde validate date in mm/dd/yyyy format i want to validate in dd/mm/yyyy
Is there a method in jQuery that I can customize an invalid validation myself instead of using jQuery plug-in validation?
For example, if the form is valid do this below.
$('form').validate();
if ($('form').valid()) {
//do something
};
But if I wanted to have a cutomize invalid method I could do this below.
$('form').validate();
if (!x == y) {
$('form').valid() = False; //[:(]
alert('Form is not valid.');
};
I use FileHelpers to import data from excel sheet to classes and then put it in MSSQL. Can somebody tell me if there is there a way to do model validation data imported from excel files?
View 6 Repliesiam have 5 columns in my sheet1,in that 5 column i have data in nth row, how to validate my container column if the data is blank, i need to fire in 10th row no data available
View 1 Replies i am currently working on importing excel sheets into my database.
SqlBulkCopy seems to be working fine, when i whole import the data over.
But i can't do automated validation (i.e. checking for identical data in the database & etc, i am stuck!) i can import the excel sheet data a line at a time , and perform automated validation check on them.
For validating login field (at register form) I use customValidator
<asp:CustomValidator id="uniqueLoginValidator" class="validator" runat="server" ControlToValidate="tbUserName" ErrorMessage="Login duplicate" ClientValidationFunction="LoginValidate"/>
For validate login I need consume wcf, so decide use web-methods
<script type="text/javascript">
function LoginValidate(oSrc, args) {
var login = $(".loginField").val();[code]....
For successfull validating I should setup args at ClientValidationFunction, but I get result validation only at callBack. So how can I setup args for validation work.
I am creating a custom 'control' which is simply made of two html inputs [type=text] but can't figure out how the validation will work on the view end.
I want to treat these 2 inner controls as asingle control so when a error is added to modelstate both of these inputs are highlighted in the view and a single validation message is shown.
I'm having problems with getting my custom dataannotations to work, I'm trying to add a validation-attribute that validates that the UsergroupName for a Customer (CustomerID) is unique.
[Code]....
the IsValid should return false if the "count >0". How do I fix this one so it works. GetUsergroups() returns IQueryable<Usergroup>.
protected void cusCustom_ServerValidate(object sender, ServerValidateEventArgs e)
{
if(e.Value.Length == 8)
.IsValid = true;
else
e.IsValid = false;
ge code
<asp:CustomValidator runat="server" id="cusCustom" controltovalidate="txtoedate" onservervalidate="cusCustom_ServerValidate" errormessage="The text must be exactly 8 characters long!" />
I am new to asp.net and I have a problem. When the users insert in a editor for a decimal field something other than numbers, they get an error "Field name" is not a number. But I don't want them to receive this message I want them to receive another message. I have no problem with this with required and range validators. Is there any way for me to do this?
I am not refering necessarily to changing the culture just displaying another message.
I am creating a system in visual web developer. I want to use the custom validation to validate an email address.I am using Visual basic to do it in.so far i have
Dim ampposition As Integer
Dim dotposition As Integer
For i = 1 To Len(txtemail.Text)
Next
As i want to use a for loop to validate the email
I need to fire some custom JavaScript validation and then submit my ASP.NET using JavaScript.How do I submit the form using JavaScript?
View 3 RepliesI'm trying to write a custom validation on a set of radiobutton list where if certain radio button is selected, a specified checkbox needs to be fill in with certain amount.
Code:
<asp:CustomValidator ID="CustomValidator1" runat="server" OnServerValidate="CustomValidator1_ServerValidate" ClientValidationFunction="CheckAmt" ControlToValidate="txtAmt" Display="Dynamic" ErrorMessage="Enter contribution amount" SetFocusOnError="True" Enabled = "true" ValidationGroup="GiftValidate"></asp:CustomValidator><br />
Code:
[code]....
Custom Validation Client-Side not working
View 9 RepliesDo I understand correctly that for your own custom atrributes, to work with client side validation, you also have to write a jQuery script that validate the value?My client side validation works fine, but not for my own attributes (In this case the "PropertiesMustMatchAttribute" I just copied out of a default asp.net mvc project (not empty one), or others that hit the database to see if an email address are unique
View 2 RepliesIn a ListView, I have a CustomValidator set up to validate a field whenever a button with CommandName="Delete" is clicked.
<ItemTemplate>
<asp:TextBox ID="NameTextBox" Text=<%# Eval("Name") %> runat="server" />
<asp:Button ID="DeleteButton" Text="Delete" CommandName="Delete" ValidationGroup="Delete" runat="server" />
<asp:CustomValidator ValidationGroup="Delete" SetFocusOnError="true" Display="Dynamic" OnServerValidate="CustomValidator_ServerValidate" runat="server">You can't delete this.</asp:CustomValidator>
</ItemTemplate>
However, the error message is never displayed and the processing continues. What's strange is that the custom validation method is called, finds the field, and properly sets up e.IsValid to false. It does not matter whether I check Page.IsValid or not, because the error message is not displayed anyway. It works if I remove the CommandName="Delete" from the button.
With Google I found the following solution, which seems to indicate someone has had a similar issue:
[URL]
But I want to make sure that this solution is the way to go. I mean, is custom validation really not supposed to work with a delete button in a databound control, seriously?
I've written a custom ASP.net control that descends from LinkButton and overrides the Render() method. I'm using it to replace ImageButtons in the site I'm working on so we don't have to have an image for each button. This control works fine, does the required post-backs etc., however it doesn't fire the validators in its validation group. This is obviously an issue. The code for the control is (condensed) as follows:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public class CustomButton : LinkButton
{
public string SpanCssClass { get; set; }
protected override void Render(HtmlTextWriter writer)
{
if (!Visible)
{
return;
}
writer.AddAttribute(HtmlTextWriterAttribute.Name, UniqueID);
writer.AddAttribute(HtmlTextWriterAttribute.Id, ClientID);
writer.AddAttribute(HtmlTextWriterAttribute.Class, CssClass);
string postback = string.IsNullOrEmpty(OnClientClick) ? "javascript:__doPostBack('" + UniqueID + "','');" : OnClientClick;
writer.AddAttribute(HtmlTextWriterAttribute.Href, postback);
writer.RenderBeginTag(HtmlTextWriterTag.A);
writer.AddAttribute(HtmlTextWriterAttribute.Class, SpanCssClass);
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(Text);
writer.RenderEndTag();
writer.RenderEndTag();
}
}
Does anyone know why this would not be causing the validators to fire? I was under the impression that leaving all the other methods in LinkButton un-overridden would leave all the other functionality the same.
I am using the CreateUserWizard in my VB.Net 3.5 web app. I added my own custom fields (First Name, Last Name...) to the form by using the CreateUserWizardStep and the CreateUserWizard1_CreatedUser event. Everything inserts fine into the aspnet_ tables and my own table. However, I cannot get the form validation to work. In other words, the form is ignoring the RequiredFieldValidators that I added.
View 4 RepliesHow can we implement a custom validation of two controls as a unit, say a picture upload control and a dropdown ("0", ""100", "200") for the width of the picture display.
View 1 Replies