3
Answers

How to assign the combobox's selected item property to .rdlc

Riyaz Kalva

Riyaz Kalva
12y
11.1k
1

I want to display the type of bill in my report.

For that I have put the combo box in data entry form(Form1) which enables user to select the type of copy whether it is original,duplicate or triplicate. I want to assign the selected value of the combo box(of Form1) to the text box which resides under the report(.rdlc file) How to assign the control's property to the text box inside the report?

Please help.
Thanks in advance.

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