3
Answers

Match the value In the DropDownlist through SQL IN ASP.NET?

Richa Garg

Richa Garg
12y
5.8k
1
Hi Friends,
    I made a table in the SQL DATABASE in which two values are displayed one is the value and other is the code of that particular value. Now In Asp.net all these values are displayed in the dropdownlist. I want when I click on any value in the dropdownList the corresponding code of that clicked value will be fetch from the database and Display that code in the label. How can this possible? Please help me out.
Answers (3)
1
Santhosh Kumar Jayaraman

Santhosh Kumar Jayaraman

NA 9.9k 2.3m 12y
In the dropdownlist selection changed event

if (DropDownList1.SelectedIndex != 0)
{
string strValue = string.Empty;
SqlConnection con = new SqlConnection("Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;");
SqlCommand cmd = new SqlCommand(" select Empname from Employee where empid='"+ DropDownList1.SelectedValue.ToString()+"'", con);
con.Open();
strValue = (string)cmd.ExecuteScalar();
con.Close();
TextBox1.Text = strValue;
}
Accepted
0
prakash kumawat

prakash kumawat

NA 3 700 10y
what to do if the selection mode is multiple in listbox and I want to display those records which are selected in the list box
0
Satyapriya Nayak

Satyapriya Nayak

NA 53k 8m 12y
Hi Richa,


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Dropdownlist_click_data_in_textbox._Default" %>

<!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>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:DropDownList ID="DropDownList1" runat="server"
            onselectedindexchanged="DropDownList1_SelectedIndexChanged">
        </asp:DropDownList><br />
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    </div>
   
    </form>
</body>
</html>





using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Dropdownlist_click_data_in_textbox
{
    public partial class _Default : System.Web.UI.Page
    {
        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        string str;
        SqlCommand com;
        protected void Page_Load(object sender, EventArgs e)
        {
            DropDownList1.AutoPostBack = true;
            SqlConnection con = new SqlConnection(strConnString);

            if (!IsPostBack)
            {
                DropDownList1.Items.Add("Choose id");
                con.Open();
                str = "select * from  test";
                com = new SqlCommand(str, con);
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    DropDownList1.Items.Add(reader["id"].ToString());
                }
                reader.Close();
                con.Close();
            }
        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str = "select * from test where id='" + DropDownList1.SelectedItem.Text + "'";
            com = new SqlCommand(str, con);
            SqlDataReader reader = com.ExecuteReader();
            while (reader.Read())
            {
                TextBox1.Text = reader["name"].ToString();
               
            }
            reader.Close();
            con.Close();
        }
    }
}



Thanks
If this post helps you mark it as answer
Next Recommended Forum