How to write a code for selected item in a combo box

[rhepsi]

hii all,

for selecting one item in a combo box n writing a search button_click code for that....

There are 3 items in teh combobox, nw for 1 item i want to write a code for search_button click

How to start with

If combobox = Project Manager Then................>> error

wat shd i consider...

plz someone help...

thnx

[Vidhura]

hii all,

for selecting one item in a combo box n writing a search button_click code for that....

There are 3 items in teh combobox, nw for 1 item i want to write a code for search_button click

How to start with

If combobox = Project Manager Then................>> error

wat shd i consider...

plz someone help...

thnx

in Combobox

Could you explain more?What is your requirment?

[r035198x]

hii all,

for selecting one item in a combo box n writing a search button_click code for that....

There are 3 items in teh combobox, nw for 1 item i want to write a code for search_button click

How to start with

If combobox = Project Manager Then................>> error

wat shd i consider...

plz someone help...

thnx

Do you mean that you want to call the same actions in the method button_click when option 1 is selected?
Which language are you using? e.g in C# :
to test the value selected on the combobox you use

if (this.combobox .Text == "Project Manager") 

[rhepsi]

Do you mean that you want to call the same actions in the method button_click when option 1 is selected?
Which language are you using? e.g in C# :
to test the value selected on the combobox you use

if (this.combobox .Text == "Project Manager") 

thnx for ur reply...

i have 3 items... i want to write in the search_button_click for 3rd option...
im using vb.net 1.1...

plz help..

[rhepsi]

in Combobox

Could you explain more?What is your requirment?

hii,

i have 2 comboboxes...one for select category(3items: project code, project location, project manager) and 2nd combobox for search list( where im populating the code, location and manager )
here im populating the records for code n location from tbl_projects (db) whereas for manager i need from tbl_staffs and tbl_staff_assignments(where category for manager is present)...

i hope u understand...

nw i have search button,

in this, i can search the records by project_id_pk...(tbl_projects)


[vb.net code] for search_button_click


' Get Primary Key from Listbox
objListItem = CType(cbPrSearchList.SelectedItem, ListItem)

cmSQL = New MySqlCommand




Dim mySelectQuery As String = "Select pr_project_id_pk, pr_project_code, pr_project_location, --etc " _
& "from tbl_projects where pr_project_id_pk= ?PrID"


cmSQL.Parameters.Add("?PrId", objListItem.ID)

[/code]

nw my doubt is i dont want to take list item, rather single ones...

how and wat shd be my code..???

plz help..

thnx n regards
hepsi..

[prabunewindia]

hi friend,
i am not getting u.
give ur table details and combox and for what u r using the same and
what u need as ur output?
plz be clear
prabu

hii,

i have 2 comboboxes...one for select category(3items: project code, project location, project manager) and 2nd combobox for search list( where im populating the code, location and manager )
here im populating the records for code n location from tbl_projects (db) whereas for manager i need from tbl_staffs and tbl_staff_assignments(where category for manager is present)...

i hope u understand...

nw i have search button,

in this, i can search the records by project_id_pk...(tbl_projects)


[vb.net code] for search_button_click


' Get Primary Key from Listbox
objListItem = CType(cbPrSearchList.SelectedItem, ListItem)

cmSQL = New MySqlCommand




Dim mySelectQuery As String = "Select pr_project_id_pk, pr_project_code, pr_project_location, --etc " _
& "from tbl_projects where pr_project_id_pk= ?PrID"


cmSQL.Parameters.Add("?PrId", objListItem.ID)

[/code]

nw my doubt is i dont want to take list item, rather single ones...

how and wat shd be my code..???

plz help..

thnx n regards
hepsi..

[Vidhura]

hii,

i have 2 comboboxes...one for select category(3items: project code, project location, project manager) and 2nd combobox for search list( where im populating the code, location and manager )
here im populating the records for code n location from tbl_projects (db) whereas for manager i need from tbl_staffs and tbl_staff_assignments(where category for manager is present)...

i hope u understand...

nw i have search button,

in this, i can search the records by project_id_pk...(tbl_projects)


[vb.net code] for search_button_click


' Get Primary Key from Listbox
objListItem = CType(cbPrSearchList.SelectedItem, ListItem)

cmSQL = New MySqlCommand




Dim mySelectQuery As String = "Select pr_project_id_pk, pr_project_code, pr_project_location, --etc " _
& "from tbl_projects where pr_project_id_pk= ?PrID"


cmSQL.Parameters.Add("?PrId", objListItem.ID)

[/code]

nw my doubt is i dont want to take list item, rather single ones...

how and wat shd be my code..???

plz help..

thnx n regards
hepsi..

Still I couldnt get you

My understanding:

Combobox1 has following 3 items

1.ProjectCode
2.ProjectLocation
3.ProjectManager

Combobox 2 is empty

If you select ProjectManager in combobox1 all the projectmangers should be listed in Combobox2...

in button clickevent

if (this.combobox .selectedItem == "ProjectManager")
query="select distinct staffname from tbl_staff "

is this your requirment?

[rhepsi]

Still I couldnt get you

My understanding:

Combobox1 has following 3 items

1.ProjectCode
2.ProjectLocation
3.ProjectManager

Combobox 2 is empty

If you select ProjectManager in combobox1 all the projectmangers should be listed in Combobox2...

in button clickevent

if (this.combobox .selectedItem == "ProjectManager")
query="select distinct staffname from tbl_staff "

is this your requirment?

thnx for ur reply...

no thts not my requirement..

my requirement is:
combobox2 is not empty..
.combobox2:
1. abc
2.xyz
3.fdf;
so on. till 52

in the form i have a search button ...
when i select project manager from1st combobox, all the managers are populated in the 2nd combobox....(this is frm tbl_staffs)

nw when i click on search,
search is doin its operation in tbl_projects like
the list of managers tht r present in the combobox's primary key = tbl_projects primary key
that means it is not goin to tbl_staffs but rather tbl_projects
i hope u understand...
i need a help for writing a separate query for tbl_staffs for the project manager..

thnx
hepsi..

[prabunewindia]

be clear my friend!
what u want to search?
what is table project contains?
give details about both table.
what result u r expecting?

thnx for ur reply...

no thts not my requirement..

my requirement is:
combobox2 is not empty..
.combobox2:
1. abc
2.xyz
3.fdf;
so on. till 52

in the form i have a search button ...
when i select project manager from1st combobox, all the managers are populated in the 2nd combobox....(this is frm tbl_staffs)

nw when i click on search,
search is doin its operation in tbl_projects like
the list of managers tht r present in the combobox's primary key = tbl_projects primary key
that means it is not goin to tbl_staffs but rather tbl_projects
i hope u understand...
i need a help for writing a separate query for tbl_staffs for the project manager..

thnx
hepsi..

[Vidhura]

thnx for ur reply...

no thts not my requirement..

my requirement is:
combobox2 is not empty..
.combobox2:
1. abc
2.xyz
3.fdf;
so on. till 52

in the form i have a search button ...
when i select project manager from1st combobox, all the managers are populated in the 2nd combobox....(this is frm tbl_staffs)

nw when i click on search,
search is doin its operation in tbl_projects like
the list of managers tht r present in the combobox's primary key = tbl_projects primary key
that means it is not goin to tbl_staffs but rather tbl_projects
i hope u understand...
i need a help for writing a separate query for tbl_staffs for the project manager..

thnx
hepsi..

You want to list the projectcode and projectlocation for the projectmanager you selected in the Combobox2.Is this right?

If yes,give your table_staff,table_staff_assignment,table_project structures(fields present in the table)

sample query:

select C.ID,C.ProjectCode,C.ProjectLocation,C.ProjectName from tbl_staff A
left join tbl_staff _assignments B on B.StaffID=A.ID
left join tbl_projects C on C.ID=B.projectID
where A.Name=(combobox.selecteditem)

[rhepsi]

You want to list the projectcode and projectlocation for the projectmanager you selected in the Combobox2.Is this right?

If yes,give your table_staff,table_staff_assignment,table_project structures(fields present in the table)

sample query:

select C.ID,C.ProjectCode,C.ProjectLocation,C.ProjectName from tbl_staff A
left join tbl_staff _assignments B on B.StaffID=A.ID
left join tbl_projects C on C.ID=B.projectID
where A.Name=(combobox.selecteditem)

thnq so much... i shall try tht code... n give u reply...

[rhepsi]

You want to list the projectcode and projectlocation for the projectmanager you selected in the Combobox2.Is this right?

If yes,give your table_staff,table_staff_assignment,table_project structures(fields present in the table)

sample query:

select C.ID,C.ProjectCode,C.ProjectLocation,C.ProjectName from tbl_staff A
left join tbl_staff _assignments B on B.StaffID=A.ID
left join tbl_projects C on C.ID=B.projectID
where A.Name=(combobox.selecteditem)

Hey ive tried it.... but of no use...
here is my code:

        ' Get Primary Key from Listbox
        objListItem = CType(cbPrSearchList.SelectedItem, ListItem)
 
        cmSQL = New MySqlCommand
 
        Dim mySelectQuery As String = "Select pr_project_id_pk, pr_project_code," _
        & "pr_project_location, pr_project_manager_id_fk, pr_street_address, " _
        & "pr_state_id_fk, pr_pincode, pr_postal_address, pr_phone, " _
        & "pr_courier_service, pr_email, pr_om_field, pr_total_students, pr_total_staff, " _
        & "pr_teaching_staff, pr_non_teaching_staff, pr_project_background, " _
        & "pr_profile_status, pr_photo_status, pr_upload_status, pr_comm_history" _
        & "from tbl_staffs INNER JOIN tbl_staff_assignments ON tbl_staff_assignments.sta_staff_id_fk = tbl_staffs.stf_staff_id_pk " _
        & "INNER JOIN tbl_projects ON tbl_projects.pr_project_id_pk = tbl_staff_assignments.sta_project_id_fk " _
        & "WHERE tbl_staff_assignments.sta_project_id_fk = ?StId"
 
 
        cmSQL.Parameters.Add("?StId", objListItem.ID)
 
        cnSQL = New MySqlConnection
        cnSQL.ConnectionString = connect.ConnectionString
 
        cmSQL.Connection = cnSQL
        cmSQL.CommandText = mySelectQuery
 
 

Its takingdirectly the project_id from tbl_projects not from tbl_staff_assignments project_id...

plz if u can help me...

[rhepsi]

Hey ive tried it.... but of no use...
here is my code:

        ' Get Primary Key from Listbox
        objListItem = CType(cbPrSearchList.SelectedItem, ListItem)
 
        cmSQL = New MySqlCommand
 
        Dim mySelectQuery As String = "Select pr_project_id_pk, pr_project_code," _
        & "pr_project_location, pr_project_manager_id_fk, pr_street_address, " _
        & "pr_state_id_fk, pr_pincode, pr_postal_address, pr_phone, " _
        & "pr_courier_service, pr_email, pr_om_field, pr_total_students, pr_total_staff, " _
        & "pr_teaching_staff, pr_non_teaching_staff, pr_project_background, " _
        & "pr_profile_status, pr_photo_status, pr_upload_status, pr_comm_history" _
        & "from tbl_staffs INNER JOIN tbl_staff_assignments ON tbl_staff_assignments.sta_staff_id_fk = tbl_staffs.stf_staff_id_pk " _
        & "INNER JOIN tbl_projects ON tbl_projects.pr_project_id_pk = tbl_staff_assignments.sta_project_id_fk " _
        & "WHERE tbl_staff_assignments.sta_project_id_fk = ?StId"
 
 
        cmSQL.Parameters.Add("?StId", objListItem.ID)
 
        cnSQL = New MySqlConnection
        cnSQL.ConnectionString = connect.ConnectionString
 
        cmSQL.Connection = cnSQL
        cmSQL.CommandText = mySelectQuery
 
 

Its takingdirectly the project_id from tbl_projects not from tbl_staff_assignments project_id...

plz if u can help me...

Im getting this error


Dim mySelectQuery As String = "Select pr_project_id_pk, pr_project_code," _
& "pr_project_location, pr_project_manager_id_fk, pr_street_address, " _
& "pr_state_id_fk, pr_pincode, pr_postal_address, pr_phone, " _
& "pr_courier_service, pr_email, pr_om_field, pr_total_students, pr_total_staff, " _
& "pr_teaching_staff, pr_non_teaching_staff, pr_project_background, " _
& "pr_profile_status, pr_photo_status, pr_upload_status, pr_comm_history, " _
& "pr_cs_comments, pr_lkg, pr_ukg, pr_class01, pr_class02, pr_class03, " _
& "pr_class04, pr_class05, pr_class06, pr_class07, pr_class08, pr_class09, " _
& "pr_class10, pr_year_started , pr_land_status, pr_building_status, " _
& "pr_ann_op_cost, pr_project_remarks, pr_info_date, pr_isactive " _
& "FROM tbl_staffs LEFT JOIN tbl_staff_assignments ON tbl_staff_assignments.sta_staff_id_fk = tbl_staffs.stf_staff_id_pk " _
& "LEFT JOIN tbl_projects ON tbl_projects.pr_project_id_pk = tbl_staff_assignments.sta_project_id_fk " _
& "WHERE tbl_staffs.stf_first_name = ?SID "


cmSQL.Parameters.Add("?SID", objListItem.ID)


General Error

Cast from string "" to type 'Double' is not valid.

[Vidhura]

Im getting this error


Dim mySelectQuery As String = "Select pr_project_id_pk, pr_project_code," _
& "pr_project_location, pr_project_manager_id_fk, pr_street_address, " _
& "pr_state_id_fk, pr_pincode, pr_postal_address, pr_phone, " _
& "pr_courier_service, pr_email, pr_om_field, pr_total_students, pr_total_staff, " _
& "pr_teaching_staff, pr_non_teaching_staff, pr_project_background, " _
& "pr_profile_status, pr_photo_status, pr_upload_status, pr_comm_history, " _
& "pr_cs_comments, pr_lkg, pr_ukg, pr_class01, pr_class02, pr_class03, " _
& "pr_class04, pr_class05, pr_class06, pr_class07, pr_class08, pr_class09, " _
& "pr_class10, pr_year_started , pr_land_status, pr_building_status, " _
& "pr_ann_op_cost, pr_project_remarks, pr_info_date, pr_isactive " _
& "FROM tbl_staffs LEFT JOIN tbl_staff_assignments ON tbl_staff_assignments.sta_staff_id_fk = tbl_staffs.stf_staff_id_pk " _
& "LEFT JOIN tbl_projects ON tbl_projects.pr_project_id_pk = tbl_staff_assignments.sta_project_id_fk " _
& "WHERE tbl_staffs.stf_first_name = ?SID "


cmSQL.Parameters.Add("?SID", objListItem.ID)


General Error

Cast from string "" to type 'Double' is not valid.

& "WHERE tbl_staffs.stf_first_name = ?SID "


cmSQL.Parameters.Add("?SID", objListItem.ID)

what the objectlistItem.ID contains?either staffname or ID

If you connecting with ID

use
& "WHERE tbl_staffs.ID= ?SID "

[rhepsi]

& "WHERE tbl_staffs.stf_first_name = ?SID "


cmSQL.Parameters.Add("?SID", objListItem.ID)

what the objectlistItem.ID contains?either staffname or ID

If you connecting with ID

use
& "WHERE tbl_staffs.ID= ?SID "

hey thnq so much... its workin nw...