如何限制从asp.net的下拉列表中选择相同的值 [英] how to restrict selecting same value from dropdownlist asp.net

问题描述

我有一个gridview.它包含两个空文本框，一个dropdownlist控件.用于dropdownlist的控件数据来自sql server.当我在gridview中单击submit tha数据时(两个文本框，dropdownlis值)应保存在sql中当我单击提交时，server.my探针，如果在下拉列表中选择了相同的值，则必须显示一个弹出错误.
使用C#在ASP中给出答案.



请帮助我.谢谢.

i have a gridview.it contains two empty text boxes,one dropdownlist control.for dropdownlist control data is taken from sql server.when i click on submit tha data in gridview(two textboxes,dropdownlis values)should be saved in sql server.my probelm when i click on submit,if same values selected in dropdownlist then an popup error must be displayed.
give the answer in asp using c#.



please help me.thanks in advance.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
    OnRowDataBound="GridView1_RowDataBound" >

    <Columns>
        <asp:TemplateField HeaderText="name">
            <ItemTemplate>
                  <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="age">
            <ItemTemplate>
                  <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="sex">
            <ItemTemplate>
                <asp:DropDownList ID="ddlSex" runat="server">
                    <asp:ListItem> MALE </asp:ListItem>
                     <asp:ListItem> FEMALE </asp:ListItem>
                </asp:DropDownList>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="seatno">
            <ItemTemplate>
                <asp:DropDownList ID="ddlSeatno" runat="server"/>
            </ItemTemplate>
        </asp:TemplateField>

    </Columns>
</asp:GridView>

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGridView();
        }
        
    }

    private void BindGridView()
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("select seatno from busseats where busno='"+lblBusno.Text+"' and status='"+lblStatus.Text+"'", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        con.Close();
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            con.Open();
            var ddl = (DropDownList)e.Row.FindControl("ddlSeatno");
            //int CountryId = Convert.ToInt32(e.Row.Cells[0].Text);
            SqlCommand cmd = new SqlCommand("select seatno from busseats where busno='" + lblBusno.Text + "' and status='" + lblStatus.Text + "'", con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            con.Close();
            ddl.DataSource = ds;
            ddl.DataTextField = "seatno";
            //ddl.DataValueField = "StateID";
            ddl.DataBind();
            ddl.Items.Insert(0, new ListItem("--Select--", "0"));

        }
    }

推荐答案

弹出错误?您当然想吓跑您的用户.帮自己一个忙:没有弹出窗口.更好地检查您的用户界面.如果用户不应该选择某个值，则该值不应出现在下拉列表中.尽管需要一些努力，但是不在屏幕上显示无用垃圾的开发人员的声誉值得. :-)

-SA

Popup error? You certainly want to scare off your users. Do yourself a favor: no pop-ups. Better review your UI. If some value should not be selected by the user, it should not appear in the drop-down list. It will take some effort though, but the reputation of a developer who does not show useless trash on screen worth it. :-)

—SA

最好在下一个DDl绑定中删除先前选择的值，您可以将其谷歌搜索并检查以下链接以进行验证....

http://forums.asp.net/t/1705719.aspx/1 [ ^ ]

http://forums.asp.net/t/1771811.aspx/1 [ ^ ]

its better to remove previously selected value in next DDl binding u can google it and check the below link for validation....

http://forums.asp.net/t/1705719.aspx/1[^]

http://forums.asp.net/t/1771811.aspx/1[^]

这篇关于如何限制从asp.net的下拉列表中选择相同的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！