dropdownlist issue

Question

hello;

how can i get charges of desire element of dropdownlist in my textbox .for e.g, if i selected sugery the charges of surgery display automatically in my textbox when i selected surgery. i am sending my code n scenarion image. one thing, i will tell you . i am not understanding i write this code in which place either behind the button or form load.

regards
sumaira manzoor

Satyapriya Nayak · Answer

Hi Sumaira Try this... Untitled Page onselectedindexchanged=DropDownList1_SelectedIndexChanged> 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 WebApplication5 { 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 type); con.Open(); str = select * from hospital; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader[type].ToString()); } reader.Close(); con.Close(); } } protected void DropDownList1_SelectedIndexChanged(object sender EventArgs e) { TextBox1.Text = ; SqlConnection con = new SqlConnection(strConnString); con.Open(); str = select * from hospital where type=' + DropDownList1.SelectedItem.Text + '; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { TextBox1.Text = reader[amount].ToString(); } reader.Close(); con.Close(); } } } Thanks

sumaira manzoor hussain khan · Answer

hello sir; i donot have any idea about crystal reporting in c# with asp.net. i donot know how we can establish dataset and connection in reporting. i took help of many tutoiral from the net. but i am not understanding about crystal reporting. i want to generate report on the behave patient reg code or patient visit id. regards sumaira manzoor

Satyapriya Nayak · Answer

Hi Sumaira Normal 0 protected void Page_Load( object sender EventArgs e) { TextBox_pv_date.Text= System. DateTime .Now.ToLongDateString(); OPD_TREATMENT_LIST.AutoPostBack = true ; if (!IsPostBack) { DropDownList_patient_reg_code.Items.Add(  ); SqlCommand cmd = new SqlCommand ( select * from [clinic patient registartion]  connection .get()); SqlDataReader read = cmd.ExecuteReader(); while (read.Read()) { DropDownList_patient_reg_code.Items.Add(read[ patient reg code ].ToString()); } read.Close(); OPD_TREATMENT_LIST.Items.Clear(); OPD_TREATMENT_LIST.Items.Add( Choose treatments ); string str1 = select * from [clinic treatments] ; command com = new SqlCommand (str1 connection .get()); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { OPD_TREATMENT_LIST.Items.Add(reader[ treatment name ].ToString()); } reader.Close(); } } protected void OPD_TREATMENT_LIST_SelectedIndexChanged ( object sender  EventArgs e) { TextBox_OPD_TREATMENT_CHARGES.Text =  ; string str2 = select * from [clinic treatments] where [treatment name]=' +OPD_TREATMENT_LIST.SelectedItem.Text + ' ; SqlCommand com2 = new SqlCommand (str2 connection .get()); sqlDataReader reader2 = com2.ExecuteReader(); while (reader2.Read()) { TextBox_OPD_TREATMENT_CHARGES.Text = reader2[ charges ].ToString(); } reader2.Close(); } Thanks

sumaira manzoor hussain khan · Answer

hello sir; yes i got a solution of this issue. change the name of drop list . the real name of this dropdown is OPD_TREATMENT_LIST.SelectedItem.Text. i wrote wrong name of dropdownlist.

sumaira manzoor hussain khan · Answer

hello sir; sir there are some issue again appearing in my dropdownlist. if i select opd treatment like surgerymedicineglasses etc. always one charges of desire treatments select. i am sending my code. your code and my code is same. but your code is perfetly given output and my code always given 8500 charges if i select any treatment.

Satyapriya Nayak · Answer

Thanks Sumaira for the blessing. God Bless you and your family.

sumaira manzoor hussain khan · Answer

thanks sir. ALLAH BLESS U AND UR FAMILY

Satyapriya Nayak · Answer

Hi Sumaira Try this... Untitled Page onselectedindexchanged=DropDownList1_SelectedIndexChanged> 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 surgery); con.Open(); str = select * from test; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader[surgery].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 surgery=' + DropDownList1.SelectedItem.Text + '; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { TextBox1.Text = reader[charges].ToString(); } reader.Close(); con.Close(); } } } Thanks

Pravin Ghadge · Answer

Hi use DropDownList1_SelectedIndexChanged event