Saturday, July 21, 2018

how to use dropdownlist in asp.net | Sradha WebCreations

how to use dropdownlist in asp.net

 http://sradhawebcreations.com
front end /user inter face 

="ProductOrderByCustomer.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ProductOrderByCustomer.aspx.cs" Inherits="ProductOrderByCustomer" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">

        .style1
        {
            width: 100%;
        }
        .style2
        {
            height: 23px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
   
        <table class="style1">
            <tr>
                <td align="center" colspan="2">
                    PRODUCT / SERVICES ENQUIRE</td>
            </tr>
            <tr>
                <td class="style2">
                    Customer Name :</td>
                <td class="style2">
                    <asp:TextBox ID="TextBox1" runat="server" Width="216px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    Email Id :</td>
                <td>
                    <asp:TextBox ID="TextBox2" runat="server" Width="216px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    Mobile No :</td>
                <td>
                    <asp:TextBox ID="TextBox3" runat="server" Width="139px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    Land Line :</td>
                <td>
                    <asp:TextBox ID="TextBox4" runat="server" Width="138px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    State&nbsp;&nbsp;&nbsp; City&nbsp;&nbsp;&nbsp; Area&nbsp;&nbsp;&nbsp; :</td>
                <td>
                    <asp:DropDownList ID="DropDownList1" runat="server">
                        <asp:ListItem>-Slelect State-</asp:ListItem>
                        <asp:ListItem>Bihar</asp:ListItem>
                        <asp:ListItem>Odisha</asp:ListItem>
                        <asp:ListItem>West Bengal</asp:ListItem>
                        <asp:ListItem>Jharkhand</asp:ListItem>
                    </asp:DropDownList>
&nbsp;&nbsp;&nbsp;&nbsp;
                    <asp:DropDownList ID="DropDownList2" runat="server">
                        <asp:ListItem>-Select City-</asp:ListItem>
                        <asp:ListItem>Patna</asp:ListItem>
                        <asp:ListItem>Darbhanga</asp:ListItem>
                        <asp:ListItem>Madhubani</asp:ListItem>
                        <asp:ListItem>BBSR</asp:ListItem>
                        <asp:ListItem>Cuttack</asp:ListItem>
                        <asp:ListItem>Balasore</asp:ListItem>
                        <asp:ListItem>Bhadrak</asp:ListItem>
                    </asp:DropDownList>
&nbsp;&nbsp;&nbsp;&nbsp;
                    <asp:DropDownList ID="DropDownList3" runat="server">
                        <asp:ListItem>-Select Area-</asp:ListItem>
                        <asp:ListItem>Link Road</asp:ListItem>
                        <asp:ListItem>Badambadi</asp:ListItem>
                    </asp:DropDownList>
                </td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                </td>
            </tr>
            <tr>
                <td>
                    Product / Services :</td>
                <td>
                    &nbsp;&nbsp; Catagory :
                    <asp:DropDownList ID="DropDownList4" runat="server" Height="20px"
                        onselectedindexchanged="DropDownList4_SelectedIndexChanged" onclick="DropDownList4_SelectedIndexChanged"
                        Width="160px" AutoPostBack="True">
                    </asp:DropDownList>
&nbsp;<asp:Button ID="Button5" runat="server" onclick="Button5_Click" Text="Description" />
&nbsp;<asp:TextBox ID="TextBox8" runat="server" Height="57px" TextMode="MultiLine" Width="227px"
                        ></asp:TextBox>
&nbsp;&nbsp;
                    <asp:Button ID="Button4" runat="server" Text="Select" />
                </td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                    <asp:TextBox ID="TextBox5" runat="server" Height="60px" TextMode="MultiLine"
                        Width="468px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    Special Interest :</td>
                <td>
                    <asp:TextBox ID="TextBox6" runat="server" Height="53px" TextMode="MultiLine"
                        Width="305px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    <br />
                    <asp:Button ID="Button1" runat="server" Height="33px" onclick="Button1_Click"
                        Text="Submit" Width="92px" />
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                </td>
            </tr>
        </table>
   
    </div>
    </form>
</body>
</html>

back end /database  

ProductOrderByCustomer.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Security;
using System.Net;
using System.Net.Mail;

public partial class ProductOrderByCustomer : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        con.Open();

        if (!IsPostBack)
{
BindContrydropdown();
}
}

    protected void BindContrydropdown()
    {

        SqlCommand cmd = new SqlCommand("select DISTINCT Catagory from ProductByAdmin", con);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read() == true)
        {
           DropDownList4.DataTextField = "Catagory";
            DropDownList4.Items.Add( dr["Catagory"].ToString());
           // ListBox1.DataTextField = "Catagory";
           // ListBox1.Items.Add(dr["Catagory"].ToString());
        }

        dr.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {

    }
    protected void DropDownList4_SelectedIndexChanged(object sender, EventArgs e)
    {
       
    }
    protected void Button5_Click(object sender, EventArgs e)
    {
        if (TextBox8.Text == "" || TextBox8.Text == null)
        {
            TextBox8.Text = DropDownList4.SelectedItem.ToString();
        }
        else
        {
            TextBox8.Text = TextBox8.Text + "\n" + DropDownList4.SelectedValue.ToString();
        }
    }
   
}


No comments:

Post a Comment