0

previously i try to approve /reject thrugh buttons and i try to code it but now i try to approve/reject through dropdownlist but i dont know how i code though dropdownlist....

this is code when i add buttons of approve and reject..

protected void GrdFileApprove_RowCommand(object sender, GridViewCommandEventArgs e)
        {

            if (e.CommandName == "_Approve")
            {
                //using (SqlConnection con = DataAccess.GetConnected())
                using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["mydms"].ConnectionString))
                {
                    try
                    {
                        con.Open();
                        int rowindex = Convert.ToInt32(e.CommandArgument);
                        GridViewRow row = (GridViewRow)((Control)e.CommandSource).NamingContainer;
                        Button Prove_Button = (Button)row.FindControl("BtnApprove");
                        SqlCommand cmd = new SqlCommand("approveee", con);

                        //cmd.CommandType = CommandType.StoredProcedure;
                        cmd.CommandType = CommandType.StoredProcedure;
                        //con.Execute("approve", new { UserID, DocID, ApproveID });


                        cmd.Parameters.Add(new SqlParameter("@UserID", UserID));
                        cmd.Parameters.Add(new SqlParameter("@DocID", DocID));
                        //cmd.Parameters.Add("ApproveID", (object)ApproveID ?? DBNull.Value);
                        cmd.Parameters.Add(new SqlParameter("@ApproveID", ApproveID));
                        int result = cmd.ExecuteNonQuery();
                        if (result != 0)
                        {
                            GrdFileApprove.DataBind();
                        }
                    }

                    catch
                    {
                        apfi.Text = "Not Approve";



                    }
                    finally
                    {
                        con.Close();
                    }
                }
            }


            else if (e.CommandName == "_Reject")
            {
                using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["mydms"].ConnectionString))
                {
                    try
                    {
                        con.Open();
                        int rowindex = Convert.ToInt32(e.CommandArgument);
                        GridViewRow row = (GridViewRow)((Control)e.CommandSource).NamingContainer;
                        LinkButton Prove_Button = (LinkButton)row.FindControl("Button1");
                        SqlCommand cmd = new SqlCommand("sprejectapprove", con);

                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.Add(new SqlParameter("@UserID",UserID));
                        cmd.Parameters.Add(new SqlParameter("@DocID", DocID));
                        cmd.Parameters.Add(new SqlParameter("@ApproveID", ApproveID));
                        int result = cmd.ExecuteNonQuery();
                        if (result != 0)
                        {
                            GrdFileApprove.DataBind();
                        }
                    }

                    catch
                    {
                        apfi.Text = "Rejct";
                    }
                    finally
                    {
                        con.Close();
                    }
                }
            }
            }

this is grdivew html

<asp:GridView ID="GrdFileApprove" runat="server" BackColor="White" 
                  BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4" 
                  GridLines="Horizontal" AutoGenerateColumns="False" 
                    onrowcommand="GrdFileApprove_RowCommand" OnRowDataBound="OnRowDataBound" >
                     <Columns>
                       <asp:TemplateField HeaderText="S no">
                           <ItemTemplate>
                               <%# Container.DataItemIndex+1 %>
                               <asp:HiddenField runat="server" ID="HdnFileID" Value='<%# Eval("DocID") %>' />
                           </ItemTemplate>
                       </asp:TemplateField>
                       <asp:BoundField DataField="DocID" HeaderText="DocumentID"  />
                       <asp:BoundField DataField="DocName" HeaderText="DocName"  />
                       <asp:BoundField DataField="Uploadfile" HeaderText="File Name" />
                       <asp:BoundField DataField="DocType" HeaderText="Document" />
                       <asp:BoundField DataField="DepType" HeaderText="Department" />

                       <asp:BoundField HeaderText="ApproveID" DataField="ApproveID" ></asp:BoundField>
                <asp:TemplateField>
                    <ItemTemplate>
                       <asp:Label ID="lblCountry" runat="server" Text='<%# Eval("ApproveID") %>' Visible = "false" />

                        <asp:DropDownList ID="DropDownList4" runat="server" class="vpb_dropdown">
                        </asp:DropDownList>
                    </ItemTemplate>
                </asp:TemplateField>


                   </Columns>
                <RowStyle BackColor="White" ForeColor="#333333" />
                <FooterStyle BackColor="White" ForeColor="#333333" />
                <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
                <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
            </asp:GridView>

            plzz can any one tell me how i done with dropdownlist?
2
Contributors
1
Reply
9
Views
3 Years
Discussion Span
Last Post by LastMitch
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.