Sradha WebCreations | mobile app designing Company In Cuttack,Bhubaneswar odisha

Saturday, July 21, 2018

how to use dropdownlist in asp.net | Sradha WebCreations

how to use dropdownlist in asp.net

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">

.style1

{

width: 100%;

}

.style2

{

height: 23px;

}

</style>

</head>

<body>

<div>

<tr>

PRODUCT / SERVICES ENQUIRE</td>

</tr>

<tr>

Customer Name :</td>

<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    City    Area    :</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>

<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>

<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>

 </td>

<td>

</td>

</tr>

<tr>

<td>

Product / Services :</td>

<td>

   Catagory :

<asp:DropDownList ID="DropDownList4" runat="server" Height="20px"

onselectedindexchanged="DropDownList4_SelectedIndexChanged" onclick="DropDownList4_SelectedIndexChanged"

Width="160px" AutoPostBack="True">

</asp:DropDownList>

 <asp:Button ID="Button5" runat="server" onclick="Button5_Click" Text="Description" />

 <asp:TextBox ID="TextBox8" runat="server" Height="57px" TextMode="MultiLine" Width="227px"

></asp:TextBox>

<asp:Button ID="Button4" runat="server" Text="Select" />

</td>

</tr>

<tr>

<td>

 </td>

<td>

<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>

 </td>

<td>

<br />

<asp:Button ID="Button1" runat="server" Height="33px" onclick="Button1_Click"

Text="Submit" Width="92px" />

</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();

}

#SradhaWebCreations
Contact : +91-9040573923, +91-7008182025
http://sradhawebcreations.com/
http://sradhawebcreations.blogspot.in/
https://facebook.com/sradhawebcreations

how to enscript your connection string in share hosting | Sradha WebCreations

how to enscript your connection string in share hosting panel
how to secure your database in share hosting panel

enscript is a computer program that converts text files to PostScript, RTF, or HTML formats.

Open your website which web.config file you want to enscript.
Click on website folder copy the website path
C:\Users\sradha\Documents\Visual Studio 2010\WebSites\EnscriptWebDemo
Open command prompt cmd C:\
C:\Cd windows
C:\ windows\ cd Microsoft.NET
C:\windows\Microsoft.NET\cd Framework
C:\windows\Microsoft.NET\Framework\cd V4.0.30319
C:\windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe –pef “connectionStrings” “Paste your website file location like above” –prov “DataProtectionConfigurationProvider”
Enter
Encrypting configuration section Succeeded!
Then open
Local Connection

<!--<connectionStrings configProtectionProvider="DataProtectionConfigurationProvider">

<CipherValue>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAA8efXuhXn/k2KirAgCA8auAQAAAACAAAAAAAQZgAAAAEAACAAAACKyAp5peoUwq5MbWjvklQdverTFtuela/sH0cFmRlaaQAAAAAOgAAAAAIAACAAAADE/KMBvZgW5gkiV9g3H/Om1dhyy+UUu2+WdXE3jBXm9vABAAAA/J1t1mcL61Qj42Osg0KFQxyHDS3j63GtmS28tu27SDURxmxDOzn+uvZzlTujOdasd/hhJWF34MjBYgapGIdmgo0e00uhj5/+hwRV6gxazUvjdozhpVCNzRJB6InZ4jhApxsyW1rRxdWN7A1srb5bjvuQ4WKRGEHV/UrmusBcV5Agk4hwOkp3B+ohYWEMnSYQR3UvIcpyaxuxen39rXaE0GFoRMdHZ2+a1NdTosqKkCVWwC2RNf57vdsCS78DmnWVFlzc6k/VRBVOJM/9oj8BX5LBCxw9i6MfzsV8FA4Fp+W5cSq54ZlNuT6TPAn++Y4n8ealR2QoEXGpMcDsCrrJgKkwYjaOP4EUj9B1cT32u7uxZAxuUSib0vDhfRxisSYB9Mx7NhyBlNSYKGu+5ev+RGBTRj+7pJgm8HG+sDy5mFcBcqNeeMhy0nHeLPGZiYgQtTrGRQkDaLTftLDEyp8LtILfxhfpM03FtZgwGCetV2Z1U3U3Dvzd8r4zx8d1CZbad1Rvraso3N/0O+X08QTE1C4DF65fO7emKIQ85VeTDrrt2Jx/Zpdj99+e/RSkrnFUbrfO5TZCCfqldibyew0uur5yS9I93r61TDeXVRyOyAUK0ZaMwM5H5G+Bhu0f+JfhebVCICmTqL3uzao+OO8AQAAAAFjwSn6t6Jb+oDrhcKZzvv/WhIownTWtKjnl1LY5bkL5EYTOKUxhfhJRRK48rsyTw5VyRWW0Jj6KEZFI/WO9hdQ=</CipherValue>

</CipherData>

</EncryptedData>

</connectionStrings>-->