Comobox SelectedIndexChanged help me?

Question

mere pass ek configuration file hai jisi ma sub k name a rha hai

jub ma who name select karo to who value k data fill ho jaye text box ma

"configurationDal" file hai > is ma yeah funcation call huwa hai

ConfigurationDal dal = new ConfigurationDal

dal.FeatchUsername(userid:0);

is highligt function muaje combox say attach kar na hai

Sachin Singh · Answer

step 1.create one method public void SetCombo() { comboBox1.DisplayMember = "firstname" ; comboBox1.ValueMember = "userid" ; comboBox1.DataSource = GetAllusers(); } public List GetAllusers() { List users= new List (); using (SqlConnection con= new SqlConnection(conStr)) { SqlCommand cmd= new SqlCommand( "select * from tblUser" ); con.Open(); var rdr=cmd.ExecuteReader(); while (rdr.Read()) { User user= new User(); user.userid=Convert.ToInt32(rdr[ "id" ]); user.FirstName=rdr[ "firstname" ].ToString(); //other properties users.Add(user); } return users; } } step 2. Call this method during form Load() private void Form_Load(....) { SetCombo(); } step 3. define selectedIndexChange method on your page and then private void ComboBox1_SelectedIndexChanged(object sender, System.EventArgs e) { ComboBox comboBox = (ComboBox) sender; int selectedUserId = ( int ) ComboBox1.SelectedValue; configurationDal dal = new configurationDal(); datatable dt = new datatabe(); dt = dal.Fetchuserdetail(userid:selectedUserId).table[0]; // notice here foreach(datarow dr in dt.rows) { txt_firstname.Text =dr[ "firstname" ].Tostring(); txt_fathername.Text =dr[ "fathername" ].Tostring(); txt_surname.Text =dr[ "surname" ].Tostring(); } } Hope this helps.

Guest User · Answer

private void VolunteerSetting_Load(object sender, EventArgs e) { SetBox(); } private void drp_Volunteer_SelectedIndexChanged(object sender, EventArgs e) { //Here Need selectindex code } public void SetBox() { ConfigurationDAL dAL = new ConfigurationDAL(); DataTable dt = new DataTable(); drp_Volunteer.DataSource = dAL.GetVolunteerList().Tables[0]; //dt = dAL.FetchVolunteerDetails(volunteerID: Convert.ToInt32(drp_Userid.Text)).Tables[0]; // this is fetchData Here drp_Volunteer.ValueMember = "volunteerid"; drp_Volunteer.DisplayMember = "volunteername"; } ConfigurationDAL dAL = new ConfigurationDAL(); //Already Connection String And DataSet //here is sqlServer Code USE [BiometricDB] GO /****** Object: StoredProcedure [dbo].[UIPKGCONFIGURATION_spFetchVolunteerDetails] Script Date: 01/17/2022 00:55:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Nazim Nizar Ali -- Create date: 03-Oct-2015 -- Description: returns volunteer details by ID -- ============================================= ALTER PROCEDURE [dbo].[UIPKGCONFIGURATION_spFetchVolunteerDetails] @inVolunteerID int AS BEGIN SET NOCOUNT ON; select * from tblvolunteer where volunteerid = @inVolunteerID; select * from tblcfgvolunteerfingerprint where volunteerid = @inVolunteerID; select * from tblvolunteerletterrecord where volunteerid = @inVolunteerID; END // here is getvolunteerlist USE [BiometricDB] GO /****** Object: StoredProcedure [dbo].[UIPKGATTENDANCE_spGetVolunteerList] Script Date: 01/17/2022 00:58:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Nazim Nizar Ali -- Create date: 22-Nov-2015 -- Description: returns all volunteer names -- ============================================= ALTER PROCEDURE [dbo].[UIPKGATTENDANCE_spGetVolunteerList] AS BEGIN SET NOCOUNT ON; select 0 as volunteerid, ' ' as volunteername, '0' as dbfullname union select volunteerid, displayfullname as volunteername, dbfullname from tblvolunteer order by dbfullname; END

Guest User · Answer

drp_volunteer show of member name ================================================== CODE ================================================== ConfigurationDAL c = new ConfigurationDAL(); DataTable dt = new DataTable(); drp_Volunteer.DataSource = c.GetVolunteerList().Tables[0]; drp_Volunteer.ValueMember = "volunteerid"; drp_Volunteer.DisplayMember = "volunteername"; ================================================== UserId Show member id ================================================== CODE ================================================== ConfigurationDAL c = new ConfigurationDAL(); DataTable dt = new DataTable(); UserID.DataSource = c.GetVolunteerList().Tables[0]; UserID.ValueMember = "volunteerid"; UserID.DisplayMember = "volunteerid"; ConfigurationDAL c = new ConfigurationDAL(); DataTable dt = new DataTable(); drp_Volunteer.DataSource = c.GetVolunteerList().Tables[0]; drp_Volunteer.ValueMember = "volunteerid"; drp_Volunteer.DisplayMember = "volunteername"; ConfigurationDAL c = new ConfigurationDAL(); DataTable dt = new DataTable(); UserID.DataSource = c.GetVolunteerList().Tables[0]; UserID.ValueMember = "volunteerid"; UserID.DisplayMember = "volunteerid"; Yeah Do Combox hai ek hai code ma selectindexChaged Event kar na hai =========================================================================== Edit this Code Value Show in -1 =========================================================================== private void drp_Volunteer_SelectedIndexChanged(object sender, EventArgs e) { ConfigurationDAL c = new ConfigurationDAL(); DataTable dt = new DataTable(); UserID.DataSource = c.GetVolunteerList().Tables[0]; UserID.ValueMember = "volunteerid"; UserID.DisplayMember = "volunteerid"; int selectedUserId = (int)UserID.SelectedIndex; ConfigurationDAL dal = new ConfigurationDAL(); dt = dal.FetchVolunteerDetails(volunteerID: UserID.SelectedIndex).Tables[0]; // notice here Volunteer Detail Get Here foreach (DataRow dr in dt.Rows) { txt_FirstName.Text = dr["firstname"].ToString(); txt_fatherName.Text = dr["middlename"].ToString(); txt_Surname.Text = dr["surname"].ToString(); txt_ReportDisplayName.Text = dr["reportdisplayname"].ToString(); txt_Address.Text = dr["address"].ToString(); txt_Cnic.Text = dr["cnic"].ToString(); } } ConfigurationDAL dal = new ConfigurationDAL(); dt = dal.FetchVolunteerDetails(volunteerID: UserID.SelectedIndex).Tables[0]; // Deatail Yeah Say Pick Kar rha Hai

Sachin Singh · Answer

Where are you setting drp_volunteer datasource? your Member value for drp_volunteer is not int.

Jishan Siddique · Answer

Please check this https://stackoverflow.com/questions/12494634/fill-combobox-from-database comboBox1.DisplayMember = "ColumnName" ; comboBox1.ValueMember = "ColumnID" ; comboBox1.DataSource = dal.FeatchUsername(userid);