Avatar billede CRavnkilde Nybegynder
06. maj 2011 - 10:07

Validering ifm. gridiew

Har et gridview med data. Ud for hver record er det muligt at sende en e-mail, men det skal kun være muligt, hvis alle felter for den pågældende record er tilstede. Hvis de mangler, skal de udfyldes via "Rediger"-knappen. Jeg har altså brug for at validere før der kan sendes - fejl-meddelelsen må gerne vises via dialog-boks.

Jeg er helt ny i ASP.NET og har brug for noget hjælp her til hvordan jeg angriber ovenstående.

Her nedenfor mit gridview:

<body>
    <form id="form1" runat="server">
    <div>
   
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
            AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="GUID"
            DataSourceID="SqlDataSource2" PageSize="30" Font-Size="Small"
            BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px"
            CellPadding="2" ForeColor="Black" GridLines="Vertical" OnSelectedIndexChanged="SendSurvey"  >
            <AlternatingRowStyle BackColor="PaleGoldenrod" />
            <Columns>
                <asp:CommandField ShowEditButton="True" EditText="Rediger" UpdateText="GEM" CancelText="Fortryd" HeaderStyle-Width="100px" />
                <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" Visible="false" />
                <asp:BoundField DataField="GUID" HeaderText="GUID" SortExpression="GUID" Visible="false" ReadOnly="false" InsertVisible="false" />
                <asp:BoundField DataField="CustID" HeaderText="CustID" SortExpression="CustID" Visible="false"  />
                <asp:BoundField DataField="CustFirm" HeaderText="Firma" SortExpression="CustFirm" ReadOnly="true" />
                <asp:BoundField DataField="CustName" HeaderText="Kontaktperson" SortExpression="CustName" HeaderStyle-Width="220px" />
                <asp:BoundField DataField="GEOPL" HeaderText="GEOPL" SortExpression="Projektleder" ControlStyle-Width="40px" />
                <asp:BoundField DataField="PersonResponsible" HeaderText="P.Ansv." SortExpression="PersonResponsible" ReadOnly="true" />
                <asp:BoundField DataField="ProjectNumber" HeaderText="Projectnr." SortExpression="ProjectNumber" ReadOnly="true" />
                <asp:BoundField DataField="Description" HeaderText="Projektnavn" SortExpression="Description" ReadOnly="false" ControlStyle-Width="220px"  />
                <asp:CommandField ShowSelectButton="True" SelectText="Send undersøgelse"  />
            </Columns>
            <FooterStyle BackColor="Tan" />
            <HeaderStyle BackColor="Tan" Font-Bold="True" />
            <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue"
                HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
        </asp:GridView>
       
        <asp:SqlDataSource ID="SqlDataSource2" runat="server"
            ConflictDetection="CompareAllValues"
            ConnectionString="<%$ ConnectionStrings:XXXsql02_ConnectionString %>"
            DeleteCommand="DELETE FROM [CustSurveyContacts] WHERE [ID] = @original_ID AND (([GUID] = @original_GUID) OR ([GUID] IS NULL AND @original_GUID IS NULL)) AND (([CustID] = @original_CustID) OR ([CustID] IS NULL AND @original_CustID IS NULL)) AND (([CustFirm] = @original_CustFirm) OR ([CustFirm] IS NULL AND @original_CustFirm IS NULL)) AND (([CustName] = @original_CustName) OR ([CustName] IS NULL AND @original_CustName IS NULL)) AND (([CustEmail] = @original_CustEmail) OR ([CustEmail] IS NULL AND @original_CustEmail IS NULL)) AND (([GEOPL] = @original_GEOPL) OR ([GEOPL] IS NULL AND @original_GEOPL IS NULL)) AND (([ProjectNumber] = @original_ProjectNumber) OR ([ProjectNumber] IS NULL AND @original_ProjectNumber IS NULL))"
            InsertCommand="INSERT INTO [CustSurveyContacts] ([GUID], [CustID], [CustFirm], [CustName], [CustEmail], [GEOPL], [ProjectNumber]) VALUES (@GUID, @CustID, @CustFirm, @CustName, @CustEmail, @GEOPL, @ProjectNumber)"
            OldValuesParameterFormatString="original_{0}"
            SelectCommand="SELECT * FROM [CustSurveyContacts] ORDER BY [CustFirm], [GEOPL], [ProjectNumber]"
            UpdateCommand="UPDATE [CustSurveyContacts] SET  [CustName] = @CustName, [CustEmail] = @CustEmail, [GEOPL] = @GEOPL, [Description] = @Description WHERE [GUID] = @original_GUID ">
            <DeleteParameters>
                <asp:Parameter Name="original_ID" Type="Int32" />
                <asp:Parameter Name="original_GUID" Type="Object" />
                <asp:Parameter Name="original_CustID" Type="String" />
                <asp:Parameter Name="original_CustFirm" Type="String" />
                <asp:Parameter Name="original_CustName" Type="String" />
                <asp:Parameter Name="original_CustEmail" Type="String" />
                <asp:Parameter Name="original_GEOPL" Type="String" />
                <asp:Parameter Name="original_ProjectNumber" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="GUID" Type="Object" />
                <asp:Parameter Name="CustID" Type="String" />
                <asp:Parameter Name="CustFirm" Type="String" />
                <asp:Parameter Name="CustName" Type="String" />
                <asp:Parameter Name="CustEmail" Type="String" />
                <asp:Parameter Name="GEOPL" Type="String" />
                <asp:Parameter Name="ProjectNumber" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="GUID" Type="Object" />
                <asp:Parameter Name="CustID" Type="String" />
                <asp:Parameter Name="CustFirm" Type="String" />
                <asp:Parameter Name="CustName" Type="String" />
                <asp:Parameter Name="CustEmail" Type="String" />
                <asp:Parameter Name="GEOPL" Type="String" />
                <asp:Parameter Name="ProjectNumber" Type="String" />
                <asp:Parameter Name="Description" Type="String" />
                <asp:Parameter Name="original_ID" Type="Int32" />
                <asp:Parameter Name="original_GUID" Type="Object" />
                <asp:Parameter Name="original_CustID" Type="String" />
                <asp:Parameter Name="original_CustFirm" Type="String" />
                <asp:Parameter Name="original_CustName" Type="String" />
                <asp:Parameter Name="original_CustEmail" Type="String" />
                <asp:Parameter Name="original_GEOPL" Type="String" />
                <asp:Parameter Name="original_ProjectNumber" Type="String" />
                <asp:Parameter Name="original_Description" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>
   
    </div>
    </form>
</body>
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester