Validation Controls not working in DetailsView

malie22001 · March 16th, 2012, 11:26 AM

Hi,

I have created a DetailsView control that is supposed to add an item in the database. The control is attached to the datasource of a gridview just as it was done in the book. I have then converted two of its fields to a template to allow me replace them with other controls and add validation controls to them.

I have replaced one of the fields with a FileUpload control and another with a textbox. I removed the EditItem areas as it was done in the book. Now I added two validation controls; one for the textbox and the other for the FileUpload control.

After this, I try to test the application. When testing, I realized that the validation controls will activate when I try to edit an item in GridView, not the DetailsView. So I decided to add the validation controls to a ValidationGroup. Once I did this, the validatio controls no longer activate for the GridView, and they do not work for the DetailsView either.

Please help me out.

Thanks.

Imar · March 17th, 2012, 04:02 PM

Hi there,

Is this related to a specific page or exercise in the book? If so, can you specify page and chapter numbers and provide more detail on what exactly you're asking?

If it's not related, can you please post this in a more general ASP.NET category here: http://p2p.wrox.com/asp-net-4-539/ as you'll attract more viewers there. Also, be sure to post the full source code. If you provide a link, I'll take a look.

Cheers,

Imar

malie22001 · March 21st, 2012, 12:51 AM

Yes it is related. In the book, you discussed how to use the validation controls within the server controls when the fields in the server controls have been converted to templates (Page 463 - Exercise titled "Customizing the DetailsView and Handling Its Events").

In this exercise, you demonstrate how we can add the Validation controls in the data controls.

Here is my entire code.

Code:

<%@ Page Title="Ruby Admin | Category" Language="C#" MasterPageFile="~/Masters/AdminMaster.master" AutoEventWireup="true" CodeFile="Categories.aspx.cs" Inherits="Categories" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="CpReadable" Runat="Server">
    <div class="pageContent">
        <h1>
            Categories Administration
        </h1>
        <p>
            You can use this section to add and/or edit new or existing categories.
        </p>

        List of all Categories: 
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataKeyNames="CategoryID" DataSourceID="SqlDataSource1" 
            EmptyDataText="There are no data records to display." AllowPaging="True" 
            AllowSorting="True" CssClass="gridView">
            <AlternatingRowStyle CssClass="alternatingRows" />
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                <asp:BoundField DataField="CategoryID" HeaderText="ID" ReadOnly="True" 
                    SortExpression="CategoryID" InsertVisible="False" />
                <asp:BoundField DataField="Category" HeaderText="Category" 
                    SortExpression="Category" />
                <asp:BoundField DataField="ImageUrl" HeaderText="Image Url" 
                    SortExpression="ImageUrl" />
                <asp:BoundField DataField="Description" HeaderText="Description" 
                    SortExpression="Description" />
                <asp:BoundField DataField="DateAdded" HeaderText="Date Added" 
                    SortExpression="DateAdded" DataFormatString="{0:d}" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:RubyDBConnectionString %>" 
            DeleteCommand="DELETE FROM [Category] WHERE [CategoryID] = @CategoryID" 
            InsertCommand="INSERT INTO [Category] ([Category], [ImageUrl], [Description], [DateAdded]) VALUES (@Category, @ImageUrl, @Description, @DateAdded)" 
            ProviderName="<%$ ConnectionStrings:RubyDBConnectionString.ProviderName %>" 
            SelectCommand="SELECT [CategoryID], [Category], [ImageUrl], [Description], [DateAdded] FROM [Category]" 
            UpdateCommand="UPDATE [Category] SET [Category] = @Category, [ImageUrl] = @ImageUrl, [Description] = @Description, [DateAdded] = @DateAdded WHERE [CategoryID] = @CategoryID">
            <DeleteParameters>
                <asp:Parameter Name="CategoryID" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="Category" Type="String" />
                <asp:Parameter Name="ImageUrl" Type="String" />
                <asp:Parameter Name="Description" Type="String" />
                <asp:Parameter DbType="DateTime2" Name="DateAdded" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="Category" Type="String" />
                <asp:Parameter Name="ImageUrl" Type="String" />
                <asp:Parameter Name="Description" Type="String" />
                <asp:Parameter DbType="DateTime2" Name="DateAdded" />
                <asp:Parameter Name="CategoryID" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>

        <br />



        <h1>Add New Category</h1>
        Fill out the below form to add a new Category.

        <br />
        <br />
        <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" 
            DataKeyNames="CategoryID" DataSourceID="SqlDataSource1" DefaultMode="Insert" 
            Height="50px" Width="500px" GridLines="None" 
            oniteminserting="DetailsView1_ItemInserting">
            <Fields>
                <asp:BoundField DataField="CategoryID" HeaderText="CategoryID" 
                    InsertVisible="False" ReadOnly="True" SortExpression="CategoryID" />
                <asp:TemplateField HeaderText="Category" SortExpression="Category">
                    <InsertItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Category") %>' 
                            CssClass="textbox" Width="250px"></asp:TextBox>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" 
                            ControlToValidate="TextBox1" CssClass="error" 
                            ErrorMessage="Category is a required field." ValidationGroup="addCategory">*</asp:RequiredFieldValidator>
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("Category") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="ImageUrl" SortExpression="ImageUrl">
                    <InsertItemTemplate>
                        <asp:FileUpload ID="FileUpload1" runat="server" CssClass="textbox" 
                            Width="250px" />
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" 
                            ControlToValidate="FileUpload1" CssClass="error" 
                            ErrorMessage="You have not selected an image to upload." 
                            ValidationGroup="addCategory">*</asp:RequiredFieldValidator>
                        <asp:CustomValidator ID="CustomValidator1" runat="server" CssClass="error" 
                            ErrorMessage="You have not selected a valid image file" 
                            onservervalidate="CustomValidator1_ServerValidate" 
                            ValidationGroup="addCategory">*</asp:CustomValidator>
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("ImageUrl") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Description" SortExpression="Description">
                    <InsertItemTemplate>
                        <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Description") %>' 
                            CssClass="textbox" Height="150px" TextMode="MultiLine" Width="250px"></asp:TextBox>
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label3" runat="server" Text='<%# Bind("Description") %>'></asp:Label>
                    </ItemTemplate>
                    <HeaderStyle VerticalAlign="Top" />
                </asp:TemplateField>
                <asp:BoundField DataField="DateAdded" HeaderText="DateAdded" 
                    InsertVisible="False" SortExpression="DateAdded" />
                <asp:CommandField ButtonType="Button" InsertText="Add Category" 
                    ShowInsertButton="True" >
                <ControlStyle CssClass="button" />
                </asp:CommandField>
            </Fields>
        </asp:DetailsView>
        <br />
        <asp:ValidationSummary ID="ValidationSummary1" CssClass="error" runat="server" />
    </div>
</asp:Content>

Imar · March 21st, 2012, 04:05 AM

Hi there,

Since it's *not* related to the Planet Wrox web site, but to a site you've built yourself, it's hard for me to test this code and see what's going on. There are a lot of dependencies on your database, connection strings and so on, stopping me from seeing this code work at run-time.

That said, could it be that you haven't set the ValidationGroup for the buttons in the DetailsView? Right now, you have a CommandField but you could convert that to a template field and set the ValidationGroup property on individual buttons or other controls you may use.

Cheers,

Imar

malie22001 · March 21st, 2012, 11:37 PM

Thank you. That was the problem. I set the ValidationGroup property for the validation controls but forgot to set it for the control that actually causes the validation.

That's again.