Bind ListBox With SQL Database In ASP.NET Web Forms | ASP.NET Tutorials

 using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Configuration;

using System.Data;


namespace ListBoxAsp

{

    public partial class WebForm1 : System.Web.UI.Page

    {

        string cs = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                BindListBox();

            }

        }


        void BindListBox()

        {

            SqlConnection con = new SqlConnection(cs);

            string query = "select * from employee";

            SqlDataAdapter sda = new SqlDataAdapter(query,con);

            DataTable data = new DataTable();

            sda.Fill(data);

            ListBox1.DataSource = data;

            ListBox1.DataTextField = "name";

            ListBox1.DataValueField = "salary";

            ListBox1.DataBind();

        }


        protected void Button1_Click(object sender, EventArgs e)

        {

            if (ListBox1.SelectedIndex == -1)

            {

                Response.Write("Please select any name..");

            }

            else

            {

                foreach (ListItem li in ListBox1.Items)

                {

                    if(li.Selected)

                    {

                        Response.Write("Selected Item Text is : " + li.Text + "<br>");

                        Response.Write("Selected Item Salary is : " + li.Value + "<br>");

                        Response.Write("Selected Item Index is : " + ListBox1.Items.IndexOf(li) + "<br>");

                        Response.Write("---------------------------------------------------------------<br>");

                    }

                }

            }

;        }

    }

}

Above File is ListBoxAsp\WebForm1.aspx.cs





<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="ListBoxAsp.WebForm1" %>


<!DOCTYPE html>


<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

        <div>

            <asp:ListBox ID="ListBox1" runat="server" BackColor="#66FF66" Font-Bold="True" Font-Italic="True" Font-Size="Large" ForeColor="#CC3399" SelectionMode="Multiple">

                <%--<asp:ListItem Value="1">India</asp:ListItem>

                <asp:ListItem Value="2">Canada</asp:ListItem>

                <asp:ListItem Value="3">Brazil</asp:ListItem>

                <asp:ListItem Value="4">Mexico</asp:ListItem>

                <asp:ListItem Value="5">Nepal</asp:ListItem>

                <asp:ListItem Value="6">Russia</asp:ListItem>--%>

            </asp:ListBox>

            <br />

            <br />

            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Submit" />

        </div>

    </form>

</body>

</html>

Above File is ListBoxAsp\WebForm1.aspx








<?xml version="1.0" encoding="utf-8"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  https://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <system.web>
    <compilation debug="true" targetFramework="4.7.2" />
    <httpRuntime targetFramework="4.7.2" />
    <pages>
      <namespaces>
        <add namespace="System.Web.Optimization" />
      </namespaces>
      <controls>
        <add assembly="Microsoft.AspNet.Web.Optimization.WebForms" namespace="Microsoft.AspNet.Web.Optimization.WebForms" tagPrefix="webopt" />
      </controls>
    </pages>
  </system.web>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Antlr3.Runtime" publicKeyToken="eb42632606e9261f" />
        <bindingRedirect oldVersion="0.0.0.0-3.5.0.2" newVersion="3.5.0.2" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.Web.Infrastructure" publicKeyToken="31bf3856ad364e35" />
        <bindingRedirect oldVersion="0.0.0.0-2.0.0.0" newVersion="2.0.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" />
        <bindingRedirect oldVersion="0.0.0.0-13.0.0.0" newVersion="13.0.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="WebGrease" publicKeyToken="31bf3856ad364e35" />
        <bindingRedirect oldVersion="0.0.0.0-1.6.5135.21930" newVersion="1.6.5135.21930" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
  <system.codedom>
    <compilers>
      <compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:default /nowarn:1659;1699;1701" />
      <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.VBCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:default /nowarn:41008 /define:_MYTYPE=\&quot;Web\&quot; /optionInfer+" />
    </compilers>
  </system.codedom>
<connectionStrings>
<add name="dbcs" connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\DotNet_Programmes\ListBoxAsp\ListBoxAsp\App_Data\MyEmployeeDB.mdf;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
</configuration>
Above File is ListBoxAsp\Web.config













Comments

Post a Comment

Popular posts from this blog

AJAX Method Of jQuery AJAX In ASP.NET Web Forms | Learn ASP.NET Web Forms

Image
 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="ajax_method.WebForm1" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title></title>     <style>         #loader{             display:none;         }     </style> </head> <body>     <form id="form1" runat="server">         <div>             <input type="text" placeholder="Enter your name" id="uname"/>             <br/><br/>             <input type="text" placeholder="Enter your surname" id="surname"/>             <br/><br/>             <input type="button" value="Submit" ...
Read more

Create Show Password Check Box In Login Form In ASP.NET Web Forms | ASP.NET

Image
 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="ShowPasswordCheckBox_Practice.WebForm1" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title></title>     <style type="text/css">         .auto-style1{             width:100%;         }         .auto-style2 {             margin-left: 0px;         }         .auto-style3 {             width: 99px;         }     </style>     <script type="text/javascript">         function ShowPassword(checkBox)         {             var PasswordTextBox = document.getElementById("TextBox1");     ...
Read more

List Box In ASP.NET Web Forms | ASP.NET ListBox | Web Forms Tutorial | ASP.NET

Image
 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="ListBoxAsp.WebForm1" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title></title> </head> <body>     <form id="form1" runat="server">         <div>             <asp:ListBox ID="ListBox1" runat="server" SelectionMode="Multiple" Font-Bold="true" Font-Italic="true" Font-Size="Large" ForeColor="#CC3399">                 <asp:ListItem Value="1" Text="India"></asp:ListItem>                 <asp:ListItem Value="2" Text="SriLanka"></asp:ListItem>                 <asp:ListItem Value="3" Text="USA"></asp:ListItem>                 <asp...
Read more