B ) DROPDOWNLIST CONTROL

                          * DROPDOWNLIST * 


             Properties :- 1)  Datasource = dr ;
                                  2)  Datatextfield = "column name" ;
                                 3) Databind ( ) ;

                                 ddlstate.DataSource = dr;
                                ddlstate.DataTextField = "state";
                                ddlstate.DataBind();
  
             Q ) How to insertext  in dropdownlist control

                  ddlstate.Items.Insert(0, "select");

string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=vnit;Integrated "
            cn = new SqlConnection(path);
            cn.Open();

           string k = "select * from  statedb  ";
           cm = new SqlCommand(k, cn);
          dr = cm.ExecuteReader();
          ddlstate.DataSource = dr;
          ddlstate.DataTextField = "state";
          ddlstate.DataBind();
          ddlstate.Items.Insert(0, "select");
          dr.Close();

   
  Q)    If  some name city is repeted then use group by 

      :-  string k = " select city from statedb group by city "


                               Simple bind in Dropdownlist controle with Group by query




DDL Assigment 







Searchable Dropdownlist Concept

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

<!DOCTYPE html>

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


    <%--add jquery cdn link--%>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.js"></script>

    <%--select2 js cdn--%>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/js/select2.min.js" integrity="sha512-2ImtlRlf2VVmiGZsjm9bEyhjGW4dU7B6TNwh/hx/iSByxNENtj3WVE6o/9Lj4TJeVXPi4bnOIMXFIJJAeufa0A==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>

    <%--css link select2--%>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/css/select2.css" integrity="sha512-p209YNS54RKxuGVBVhL+pZPTioVDcYPZPYYlKWS9qVvQwrlzxBxkR8/48SCP58ieEuBosYiPUS970ixAfI/w/A==" crossorigin="anonymous" referrerpolicy="no-referrer" />

 <%--use Script var using cssclass(ddl)--%>
    <script>
        $(Document).ready(function () {
            $(".ddl").select2({

            });

        });
    </script>

    <style type="text/css">
        .auto-style1 {
            text-align: center;
        }
    </style>

</head>
<body>
    <form id="form1" runat="server">
        <p class="auto-style1">
            Serchable Dropdown Concept&nbsp;
           
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            
        </p>
        <div class="row">
                    <div class="col-md-5 mb-4 pb-2">
                        <asp:DropDownList ID="ddlstate" runat="server" Height="97px"  CssClass="ddl" Width="270px" AutoPostBack="false">
            </asp:DropDownList>
                        <label class="form-label black" for="form3Examplev4">State</label>
                        <br />
                    </div>

                    <div class="col-md-7 mb-4 pb-2">
                        <asp:DropDownList ID="ddlcity" runat="server" Height="97px"  CssClass="ddl" Width="270px" AutoPostBack="false">
            </asp:DropDownList>
                        <label class="form-label black" for="form3Examplev4">City</label>
                    </div>
         </div>
        
        <p>
            &nbsp;</p>
    </form>
</body>
</html>

Code :-  Same Show coding and call in pageload























Comments

Post a Comment

Popular posts from this blog

DATA CONTROL ( Gridview , Repeater , Formview , DataList , Detailsview , Listview )

  GRIDVIEW SOURCE CODE :      <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"              Height="279px" Width="610px">             <Columns>                 <asp:TemplateField HeaderText="roll">                 <ItemTemplate>                     <asp:TextBox ID="txtroll" runat="server" Text='<%# Eval("roll") %>'></asp:TextBox>                 </ItemTemplate>                 </asp:TemplateField>                 <asp:TemplateField HeaderText="name">                 <ItemTemplate>               ...
Read more

Z 5 ) MVC (Model view Controller)

Image
  MVC (Model view Controller)    Model View Controller   The first version of  MVC is called MVED(Model View Editor) MVC is to multi layer architecture  Model         (class and variables) View          (.cshtml) Controller   (Logic building) MVC is directly operate html page in this reason it is called light weight environment. MVC Block Diagrame   .NET Framework  ASP.NET MVC ASP.Net Webform Benefits of MVC application It is manage complex application Direct control use in html It provide test driven development testing to (url http/data)
Read more

Z 8 ) MVC HTMLHELPER METHOD AND ACTIONLINK (how to use css ,atrributes,style in css)

Image
  HTML HELPER METHODS IN ASP.NET MVC 5 In ASP.NET MVC Framework, helper methods: Ø  Are extension methods to the Html Helper class, can be called only from views. Ø  An HTML helper is a method that is used to render html content in a view. Ø  Simplifies the process of creating a view. Ø  Allows generating HTML markup that you can reuse across the Web application. Some of the commonly used helper methods while developing an MVC application are as follows: Ø  Html.ActionLink() Ø  Html.BeginForm() and Html.EndForm() Ø  Html.Label() Ø  Html.TextBox() Ø  Html.TextArea() Ø  Html.Password() Ø  Html.CheckBox()
Read more