<asp:SqlDataSource ID="SqlDataSourceShow" runat="server" 
        ConnectionString="<%$ ConnectionStrings:conCadry %>" 
            SelectCommand="SELECT [guid], [dateregister], [famely], [names], [otchestvo], [telepfone], [registercode] FROM cadryuser WHERE ([activity] = @activity)"  
            UpdateCommand="UPDATE carduser SET [activity] = @stage WHERE [guid] = @selected_row">
        <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="activity" Type="Int32" />
        </SelectParameters>
        <UpdateParameters>
            <asp:ControlParameter ControlID="selected_row" Name="select_guid" PropertyName="Text" Type="String" />
            <asp:Parameter Name="stage" DefaultValue="2" Type="String" />
        </UpdateParameters>

    </asp:SqlDataSource>
       
        <asp:GridView ID="GridView" runat="server" AutoGenerateColumns="False" 
            CssClass="table table-striped table-bordered table-condensed" 
            DataSourceID="SqlDataSourceShow" AllowSorting="True" EmptyDataText="На данный момент анкеты отсутствуют." DataKeyNames="guid">
            <Columns>
                <asp:BoundField DataField="guid" HeaderText="Код пользователя" 
                    SortExpression="guid" />
                <asp:BoundField DataField="dateregister" HeaderText="Дата регистрации" 
                    SortExpression="dateregister" />
                <asp:BoundField DataField="registercode" HeaderText="Код регистрации" 
                    SortExpression="registercode" />
                <asp:BoundField DataField="famely" HeaderText="Фамилия" 
                    SortExpression="famely" />
                <asp:BoundField DataField="names" HeaderText="Имя" 
                    SortExpression="names" />
                <asp:BoundField DataField="otchestvo" HeaderText="Отчество" 
                    SortExpression="otchestvo" />
                <asp:BoundField DataField="telepfone" HeaderText="Телефон" 
                    SortExpression="telepfone" />
                <asp:CommandField SelectText="Одобрить" ShowSelectButton="True" />
            </Columns>
        </asp:GridView>

        <asp:HiddenField ID="selected_row" runat="server" />

    Protected Sub GridView_SelectedIndexChanged(sender As Object, e As System.EventArgs) Handles GridView.SelectedIndexChanged
        Me.selected_row.Value = Me.GridView.SelectedRow.Cells("0").Text

        Try
            SqlDataSourceShow.Update()
            Dim complete_title As String = "Обработка завершина."
            Dim complete_style As MsgBoxStyle = MsgBoxStyle.OkOnly Or MsgBoxStyle.SystemModal
            Dim complete_message As String = "Анкета успешно одобрина!"
            MsgBox(complete_message, complete_style, complete_title)

        Catch except As Exception

            Dim error_title As String = "Ошибка обновления данных."
            Dim error_style As MsgBoxStyle = MsgBoxStyle.Critical Or MsgBoxStyle.SystemModal
            Dim error_message As String = "Не удалось одобрить анкету! Повторите попытку через 5 минут или обратитесь к администратору по телефону: 10-515 (Владимир)."
            MsgBox(error_message, error_style, error_title)

        End Try

    End Sub

    <asp:SqlDataSource ID="SqlDataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:conCadry %>" 
        SelectCommand="SELECT * FROM [cadryuser]" 
        DeleteCommand="DELETE FROM cadryuser WHERE (id = @id)" 
        UpdateCommand="UPDATE cadryuser SET activity = @new_activity WHERE (id = @id)">
        <DeleteParameters>
            <asp:ControlParameter ControlID="GridView" Name="id" PropertyName="SelectedValue" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="new_activity" DefaultValue="2" />
            <asp:ControlParameter ControlID="GridView" Name="id" PropertyName="SelectedValue" />       
        </UpdateParameters>
    </asp:SqlDataSource>
    

    <asp:GridView ID="GridView" runat="server" AllowSorting="True" 
        AutoGenerateColumns="False" DataSourceID="SqlDataSource" DataKeyNames="id">
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowSelectButton="True" />
            <asp:BoundField DataField="id" HeaderText="id" SortExpression="id" 
                InsertVisible="False" ReadOnly="True" />
            <asp:BoundField DataField="dateregister" HeaderText="dateregister" 
                SortExpression="dateregister" />
            <asp:BoundField DataField="dateotclans" HeaderText="dateotclans" 
                SortExpression="dateotclans" />
            <asp:BoundField DataField="registercode" HeaderText="registercode" 
                SortExpression="registercode" />
            <asp:BoundField DataField="famely" HeaderText="famely" 
                SortExpression="famely" />
            <asp:BoundField DataField="names" HeaderText="names" SortExpression="names" />
            <asp:BoundField DataField="otchestvo" HeaderText="otchestvo" 
                SortExpression="otchestvo" />
            <asp:BoundField DataField="telepfone" HeaderText="telepfone" 
                SortExpression="telepfone" />
            <asp:BoundField DataField="activity" HeaderText="activity" 
                SortExpression="activity" />
            <asp:BoundField DataField="rangs" HeaderText="rangs" SortExpression="rangs" />
            <asp:BoundField DataField="autch" HeaderText="autch" SortExpression="autch" />
            <asp:BoundField DataField="psytest" HeaderText="psytest" 
                SortExpression="psytest" />
            <asp:BoundField DataField="iqtest" HeaderText="iqtest" 
                SortExpression="iqtest" />
            <asp:BoundField DataField="proftest" HeaderText="proftest" 
                SortExpression="proftest" />
        </Columns>
        <EmptyDataTemplate>
            Нет данных для отображения.
        </EmptyDataTemplate>
    </asp:GridView>