Comobox SelectedIndexChanged help me?

Guest User

4y946

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User4y ago
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, '< Name >' as volunteername, '0' as dbfullname
union
select volunteerid, displayfullname as volunteername, dbfullname
from tblvolunteer
order by dbfullname;

END
Guest User4y ago
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 Singh4y ago
Where are you setting drp_volunteer datasource?
your Member value for drp_volunteer is not int.
Sachin Singh4y ago
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.
Jishan Siddique4y ago
Please check this

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