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 RepliesASP.NET 2.0 application exports GridView data to Excel2003 as shown below, but then needs to be able to access the Excel instance; to add a title row, auto-fit column widths, rename the worksheet, etc. Can anyone explain/show how to reference the Excel instance programmatically?
Response.ClearContent()
Response.AddHeader("content-disposition", "attachment;filename=MyFile.xls")
Response.ContentType = "application/vnd.ms-excel"
[code]...
I am uploading an Excel file into DataSet/Gridview but once the file is uploaded, then i want to be able to make changes the data that is uploaded like making changes the data inside the Gridview or deleting the data etc. Here is my code:
<div>
<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="btnUpload_Click" />
<br />
[Code].....
Is it possible, inside a Custom Model Binder, to fire "something" that "says" the value is invalid so it gets handled by validation part?
Basically, I am getting an exception when the value for the property is invalid.
I make use of validation with data annotations in my model classes. How do I make sure this annotations are not violated when I validate data in my business layer, before sending it to the DAL? I guess I don't want to define the validation rules in two places (model classes and in my BLL-classes)?
View 6 Repliespoint out an example or tutorial online that shows where data validation is done in the viewmodelas against the model? i saw a number of posts where that method is recommended..i dont really agree with it but i would like to see how it would work out..
View 2 RepliesI have recently started working on ASP.NET with MVC 2 framework, and I am facing following difficulty in validating my data,
Scenario:
In my application the view (ASPX) is divided into tabs (jQuery) and each tab's content is ViewUserControl (ASCX). The main model for the view has collection of sub models for individual tabs. I use RenderPartial method to render view user control.
[Code]....
And the user control (Tab1.ascx) refers the specific model for it,
[Code]....
Now if in my Tab1Model if I put following validation
[Code]....
In the controller ModelState.IsValid is always indicates TRUE. How do I override the validation behavior such that it as well looks the items in the collection member (which holds sub models) as well.
<%= Html.ValidationMessage("FirstName") %>
I am a MVC newbie & am lost in various ways validation can be implemented in my application.
I created a custom model-level data annotation validator attribute, but am unable to display its error message in the view. Basically, I have let's say 5 properties in the Entity class Job (model-level custom attribute called UniqueKeywords defined on it):
1) LoginID: value comes in the URL
2) Title: Required property level attribute defined on it
3) CatID1, CatID2, CatID3 - 3 categoryIDs - these are dropdowns in the view with same list of keywords in all 3.
I want to mandate that the values picked by the user in all 3 category dropdowns should be different.
With reference to the code pasted below, here is the explanation of what happens:
When I submit the form without specifying a title or picking anything from any of the 3 category dropdowns, the validation occurs for the property level Required attribute as well as model level uniquekeywords attribute, but the error is displayed only next to the required field "Title". I can confirm that the custom validation also works by filling in some text in the Title field & then re-posting the form...this re-displays the view, but the error message "Category cannot be duplicated" is not displayed.
Only relevant code sections are pasted below:
My Entity class code:
[Code]....
I have a gridview that displays data from my online database. Works great. edit/update/delete functions work also.
I decided to import data into my database through my SQL Server web admin. It worked fine, and the imported data now shows up in my gridview, but once I decide to use my gridview edit/delete buttons, the grid won't update the data or delete the rows. It will however properly function on the rows that were manually entered with the gridview and/or in visual studio.
I've got a view model that has some text properties. And I use Html.DisplayFor to display them on the screen. But those text data won't be post back, so in the case of failed validation, the returned view won't have those data. How do I handle this kind of situation?
View 2 RepliesMy MVC 2 app includes a simple file upload within in a strongly typed view and I am trying to figure out how to apply model validation to the file name. Is this possible? Is there better way to do file upload within an MVC app?
The salient parts of the (prototype) controller code are:
[Code]....
The Create view code was generated with VS2010 and then modified to support file upload and client side validation:
[Code]....
[Required]
[DisplayName("my date")]
public DateTime? DateReg { get; set; }
so if the user is going to pass in an invalid datetime value he will get this message "The value '02.07.201022' is not valid for my date."
I am using an array to keep track what checkboxes a user has clicked.
[Code]....
However, validation doesn't seem to work for this field. This is how I am rendering it in the view:
[Code]....
[Code]....
[Code]....
I have a viewmodel with a property of a model class type. I set some properties in the model class to be able to show it to the user but then when I make a post, the model gets validated. How to overcome this? I don't want to enforce the DataAnnotations contraint in this case....
public class TheViewModel
{
TheModel TheModel { get; set;}
}
[code]...
I use viewModels to communicate between my controller and my view. To get model validation, i use a partial class like this :
[MetadataType(typeof(EvaluationValidation))]
public partial class Evaluation
{
public class EvaluationValidation
{
[DisplayName("Title of evaluation")]
[Code]....
I have a Order view with 2 user controls in it.
The first user control in the view is just to validate the customer and get some more details about the customer. This control is having one text box (customer name) with the button. When the user clicks the button it should validate the customer name in the client side using data annotations of customer model. if validation success then it should use some bussiness logic to verify the customer and show the customer details on the form.
The 2nd user control in the view is to get the address of the customer by searching for the house no and the postcode. This control is having 2 text box with the button.
The first user control is based on the strongly typed customer entity
The 2nd user control is bsed on the strongly typed address entity
The view with both the user control is based on the strongly typed order entity.
The issue here is with the validation. I have the validation summary in the view and client sider validation is enabled. When i click the search button on the first user control the client validation starts and throws validation error messages because when i search for the customer at that point of time i will not have values to may of the customer related fields in the order view.
The same thing happen when i click the search button on the 2nd view. It will throw client side validation for other fields.
What i want to achive is that when the user click the search button on the user control 1 then the validation should happen only to the customer name field (both in client and server).
When the user click the search button on the 2 nd user control the the validation should happen only for houseno and the postcode both in client and the server.
When the user clicks the save button on the order view all the fields in the form even the controls usere input fields should get validated. How to achive this in mvc?
With my model, I have one view model using another as its base. In my case, BaseUserModel is inherited by CreateUserModel, in order to share common properties such as Username and Password. My CreateUserModel adds to that by having ConfirmPassword, Email, SecurityQuestion, etc.
My problem is, when using the ValidationSummary() Html helper, the validation is obviously in order of the properties in my model. Basically, because of the inheritance I have going on here, the errors are not in the correct order.
Is it possible to control when or how these validation rules are added to the list? The only attribute I'm using is Required.
I am uploading a JPEG image in an ASP.NET MVC web site.
The model validation fails in IE, but passes in Firefox, when I try to check the mime type of the
HttpPostedBaseFile.
So I debuged it and I found that when using Firefox the Mime type is "image/jpeg" as expected.
When using IE8 the mime type is "image/pjpeg".
Don't say that Microsoft invented a new Mime Type of JPeg images?
I'm starting with asp.net MVC 2. Very cool.I have been reading about the data annotations validation attributes that can be set on the view model properties.It's cool but I have a scenario where I need to determine at runtime whether one of the property is required or not.How can I achieve this ? I want to have client side validation enabled too.
View 6 Repliesi am currently working on an asp.net mvc (.net 3.5 sp1) web app, that uses data annotations and client side validation. I would like to have localization enabled, thus i have implemented a localization mechanism for enabling site visitors select the locale they prefer, by overriding the Execute() controller action and setting the CurrentCulture appropriately (i get the culture to change to from the URL route parameters).
I tried implementing my model validation messages localization with no success. What i did was adding two resource files undeer my model App_LocalResoorces folder (one for my locale greek language Validation.el.resx and one for the default english language Validation.el.resx) and set the appropriate file properties ("Access Modifier" to "Public", "Build Action" to "Embedded Resource","CustomTool" to "PublicResXFileCodeGenerator" and "Custom Tool Namespace" to "ModelLocalRes". Then i added a RequiredFieldPrompt" name-value to both the resource files.
Then i tried modify the required validation attribute on my model's name metadata like this:
[Code]....
The problem is that i cannot get the localization working, since the error message gets displayed always for the english default locale, no matter the locale selected from the site visitor.
i have a view model with a property like this one :
[RegularExpression(@"^d+$", ErrorMessageResourceType = typeof(Resources.Validation), ErrorMessageResourceName = "NumberValidationMsg" )]
public int? Number {get; set;}
NumberValidationMsg resource is set to "Only numbers allowed !".
but when I try to enter something like 'test' into Number field on form, ModelState displays the ErrorMessage with content similar to :
"The value 'test' is not valid for Number."
can this message be turned off, customized? (or maybe the best solution would be just to replace int? with string)
i am creating a MVC2 application for pubs and bars. I have a model 'Opening_Time' with the following properties:
int Day,time OpeningTimetime ClosingTimeWhen adding/editing an Opening_Time, I want to validate an Opening_Time, to check the user isn't adding one for an existing Day (ie they can't have two entries for the same day).
How/Where is the best place to do this?
Preferably, I want to do it a Model level, so I can use Model.IsValid and the Html.Form helpers
I'm using ASP.NET MVC 2 and here's the issue. My View Model looks something like this. It includes some fields which are edited by the user and others which are used for display purposes. Here's a simple version
public class MyModel
{
public decimal Price { get; set; } // for view purpose only
[Required(ErrorMessage="Name Required")]
[Code]....
But doing this, I get an error on UpdateModel(rec): The model of type 'MyModel' could not be updated.
I am not being able to use User Role at model level. I need this to grant control to each repository's method individualy.
This works fine at the objectController, at the controller level:
[Code]....
But at the objectRepository, model level, the following compiles but is ignored:
[Code]....
ASP.NET MVC doesn't allow this? Is there any way arround?
I want to upload csv file and import the data into sql. but I cant do the import thing. The file is uploaded but it cannot be imported into sql. This is my code. Hope that someone can tell me what is the problem.
[Code]....