Disable ASP.Net DropDownList inside GridView on Button Click using C# and VB.Net

indradeo

SOLVED CLOSED ACTIVE ANSWERED
User: indradeo
Posted: on Feb 18, 2022 02:00 AM
Forum: Data Controls
Answer: 1
Views: 2771
Sample Code: Download

how to disable dropdownlist while select one value from dropdownlist usign asp c#

public partial class _Default : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(@"Data Source=(localdb)\Projects;Initial Catalog=ocms_admin;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False");
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            refreshdata();
        }       
    }

    public void refreshdata()
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from comp_box", con);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        sda.Fill(dt);
        con.Close();
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
    protected void GridView1_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            SqlConnection con = new SqlConnection(@"Data Source=(localdb)\Projects;Initial Catalog=ocms_admin;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False");
            DropDownList DropDownList1 = (e.Row.FindControl("DropDownList1") as DropDownList);
            SqlCommand cmd = new SqlCommand("select * from complaint_status", con);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            DropDownList1.DataSource = dt;
            DropDownList1.DataTextField = "STATUS_NAME";
            DropDownList1.DataValueField = "STATUS_NAME";
            DropDownList1.DataBind();
            DropDownList1.Items.Insert(0, new ListItem("--SELECT_STATUS--", "0"));
           

            DropDownList DropDownList2 = (e.Row.FindControl("DropDownList2") as DropDownList);
            cmd = new SqlCommand("select * from Assign_to", con);
            sda = new SqlDataAdapter(cmd);
            dt = new DataTable();
            sda.Fill(dt);
            DropDownList2.DataSource = dt;
            DropDownList2.DataTextField = "STATUS_NAME";
            DropDownList2.DataValueField = "STATUS_NAME";
            DropDownList2.DataBind();
            DropDownList2.Items.Insert(0, new ListItem("--SELECT_NAME--", "0"));           
        }
    }

    protected void Update(object sender, EventArgs e)
    {
        GridViewRow row = (sender as Button).NamingContainer as GridViewRow;
        DropDownList dropDownList1 = row.FindControl("DropDownList1") as DropDownList;
        DropDownList dropDownList2 = row.FindControl("DropDownList2") as DropDownList;

        int COMP_ID = Convert.ToInt32(GridView1.DataKeys[Convert.ToInt32((sender as Button).CommandArgument)].Values[0]);
        string STATUS_ID = dropDownList1.SelectedItem.Text;
        string ATTEND_BY = dropDownList2.SelectedItem.Text;
        // string remark = (row.FindControl("TextBox5") as TextBox).Text;
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand("UPDATE comp_box SET STATUS_ID = @STATUS_ID, ATTEND_BY = @ATTEND_BY WHERE COMP_ID = @COMP_ID"))
            {
                cmd.Parameters.AddWithValue("@STATUS_ID", STATUS_ID);
                cmd.Parameters.AddWithValue("@ATTEND_BY", ATTEND_BY);
                cmd.Parameters.AddWithValue("@COMP_ID", COMP_ID);
                // cmd.Parameters.AddWithValue("@REMARKS", remark);
                cmd.Connection = con;
                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();
            }
        }

        dropDownList1.Items[0].Attributes.Add("disabled", "disabled");
        dropDownList2.Items[0].Attributes.Add("disabled", "disabled");
    }
}

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
    BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
    CellPadding="3" DataKeyNames="COMP_ID" GridLines="Vertical"
    OnRowDataBound="GridView1_RowDataBound" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" >
    <AlternatingRowStyle BackColor="#DCDCDC" />
    <Columns>
        <asp:TemplateField HeaderText="COMP_ID">
            <ItemTemplate>
                <asp:Label ID="Label1" runat="server" Text='<%# Bind("COMP_ID") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Emloyee ID">
            <ItemTemplate>
                <asp:Label ID="Label2" runat="server" Text='<%# Bind("EMP_ID") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="COMP_MESSAGE">
            <ItemTemplate>
                <asp:Label ID="Label4" runat="server" Text='<%# Bind("COMP_MESSAGE") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="COMP_LODGE_DATE">
            <ItemTemplate>
                <asp:Label ID="Label5" runat="server" Text='<%# Bind("COMP_LODGE_DATE") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="STATUS_NAME">
            <ItemTemplate>
                <asp:DropDownList ID="DropDownList1" runat="server">
                </asp:DropDownList>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Assign_to">
            <ItemTemplate>
                <asp:DropDownList ID="DropDownList2" runat="server" Enabled="true" >
                </asp:DropDownList>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Remark">
            <ItemTemplate>
                <asp:TextBox ID="TextBox5" runat="server">
                </asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Button ID="Button1" Text="Save" runat="server" CommandName="Save" OnClick="Update" CommandArgument="<%# Container.DataItemIndex %>" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Button ID="Button2" Text="Closed" runat="server" CommandName="Closed" OnClick="Closed" CommandArgument="<%# Container.DataItemIndex %>" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 6

Reply
ANSWER
User: dharmendr
Replied: on Feb 19, 2022 05:18 AM
Report

Hi indradeo,

Check this example. Now please take its reference and correct your code.

HTML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridView1_RowDataBound">
    <Columns>
        <asp:TemplateField HeaderText="Id">
            <ItemTemplate>
                <asp:Label ID="Label1" runat="server" Text='<%# Bind("Id") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Status">
            <ItemTemplate>
                <asp:DropDownList ID="DropDownList1" runat="server">
                </asp:DropDownList>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Assign">
            <ItemTemplate>
                <asp:DropDownList ID="DropDownList2" runat="server">
                </asp:DropDownList>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Button ID="btnUpdate" Text="Update" runat="server" OnClick="Update"
                    CommandArgument="<%# Container.DataItemIndex %>" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Namespaces

using System.Data;

VB.Net

Imports System.Data

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("Id");
        dt.Rows.Add(1);
        dt.Rows.Add(2);
        dt.Rows.Add(3);
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}

protected void GridView1_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        DropDownList DropDownList1 = (e.Row.FindControl("DropDownList1") as DropDownList);
        DropDownList DropDownList2 = (e.Row.FindControl("DropDownList2") as DropDownList);

        DataTable dt = new DataTable();
        dt.Columns.Add("STATUS_NAME");
        dt.Rows.Add("Status 1");
        dt.Rows.Add("Status 2");
        dt.Rows.Add("Status 3");
        DropDownList1.DataSource = dt;
        DropDownList1.DataTextField = "STATUS_NAME";
        DropDownList1.DataValueField = "STATUS_NAME";
        DropDownList1.DataBind();
        DropDownList1.Items.Insert(0, new ListItem("--SELECT STATUS--", "0"));

        dt.Rows.Clear();
        dt.Rows.Add("Assign 1");
        dt.Rows.Add("Assign 2");
        dt.Rows.Add("Assign 3");
        DropDownList2.DataSource = dt;
        DropDownList2.DataTextField = "STATUS_NAME";
        DropDownList2.DataValueField = "STATUS_NAME";
        DropDownList2.DataBind();
        DropDownList2.Items.Insert(0, new ListItem("--SELECT NAME--", "0"));
    }
}

protected void Update(object sender, EventArgs e)
{
    GridViewRow row = (sender as Button).NamingContainer as GridViewRow;
    DropDownList dropDownList1 = row.FindControl("DropDownList1") as DropDownList;
    DropDownList dropDownList2 = row.FindControl("DropDownList2") as DropDownList;
    if (dropDownList1.SelectedIndex > 0)
    {
        dropDownList1.Enabled = false;
    }
    if (dropDownList2.SelectedIndex > 0)
    {
        dropDownList2.Enabled = false;
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
    If Not Me.IsPostBack Then
        Dim dt As DataTable = New DataTable()
        dt.Columns.Add("Id")
        dt.Rows.Add(1)
        dt.Rows.Add(2)
        dt.Rows.Add(3)
        GridView1.DataSource = dt
        GridView1.DataBind()
    End If
End Sub

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs)
    If e.Row.RowType = DataControlRowType.DataRow Then
        Dim DropDownList1 As DropDownList = (TryCast(e.Row.FindControl("DropDownList1"), DropDownList))
        Dim DropDownList2 As DropDownList = (TryCast(e.Row.FindControl("DropDownList2"), DropDownList))
        Dim dt As DataTable = New DataTable()
        dt.Columns.Add("STATUS_NAME")
        dt.Rows.Add("Status 1")
        dt.Rows.Add("Status 2")
        dt.Rows.Add("Status 3")
        DropDownList1.DataSource = dt
        DropDownList1.DataTextField = "STATUS_NAME"
        DropDownList1.DataValueField = "STATUS_NAME"
        DropDownList1.DataBind()
        DropDownList1.Items.Insert(0, New ListItem("--SELECT STATUS--", "0"))

        dt.Rows.Clear()
        dt.Rows.Add("Assign 1")
        dt.Rows.Add("Assign 2")
        dt.Rows.Add("Assign 3")
        DropDownList2.DataSource = dt
        DropDownList2.DataTextField = "STATUS_NAME"
        DropDownList2.DataValueField = "STATUS_NAME"
        DropDownList2.DataBind()
        DropDownList2.Items.Insert(0, New ListItem("--SELECT NAME--", "0"))
    End If
End Sub

Protected Sub Update(ByVal sender As Object, ByVal e As EventArgs)
    Dim row As GridViewRow = TryCast((TryCast(sender, Button)).NamingContainer, GridViewRow)
    Dim dropDownList1 As DropDownList = TryCast(row.FindControl("DropDownList1"), DropDownList)
    Dim dropDownList2 As DropDownList = TryCast(row.FindControl("DropDownList2"), DropDownList)

    If dropDownList1.SelectedIndex > 0 Then
        dropDownList1.Enabled = False
    End If

    If dropDownList2.SelectedIndex > 0 Then
        dropDownList2.Enabled = False
    End If
End Sub

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Disable ASP.Net DropDownList inside GridView on Button Click using C# and VB.Net

Company

Explore

Follow us

Contact Us