How population combobox with dependency of code product.

Select * from Produto where code_product = textbox_code_product

I'm not sure I understand the question... but I'll give it a shot .



Are you trying to pull back all the records that match the selected value of your combo box?





(I wouldn't recommend hard coding it in the FillDataTable like that, but it gives you a start)



Or are you trying to populate the combo box itself with all the records associated with a given code? If so, then just add a fill method to your BO that corresponds to your select statement, and call that method in your combo's PopulationDataSourceSettings.

I tried to use the code below

private void prj_cod_Leave(object sender, EventArgs e)
{
sysProjetoEquipamentoBO1.FillDataTable("SELECT * FROM tabproj_equipamento WHERE prj_nrow = " + sysProjetoBO1.prj_nrow);
}

but he did not give certain. I have a field sysProjetoBO1.prj_cod and sysProjetoBO1.prj_nrow in the same table. I need to show prj_cod and populate combobox for the code sysProjetoBO1.prj_nrow. Combobox populated is sysProjetoEquipamentoBO1.prj_nrow!

Well I am not totally certain what you are trying to do.  But let's back up and start here.  First, all SF lists allow you to populate via a BO.  You will not want to just slap in SELECT code.  You will want to create a Fill command that accepts whatever parms that you need for population.

Second, you will want to set the combo being populated to populate Manual instead of FormLoad because you are going to want to first ensure that your dependent code is set.

Third, once you have created a Fill method and setup the PopulationDataSourceSettings to use that fill method on the Combo, then you will want to handle the ListPopulating event to provide the value from the dependent code.

Finally, there are a TON of samples on this.  This is an extremely common task done within the framework.  There are samples that come with the framework showing how to do this, you can look at the StrataFlix sample, or just search on the ListPopulating event within the forum and you will find a LOT of samples.

I searched in the forum but I did not obtain to develop. It could send me example code?

Rafael, these are only some links about ListPopulating event:

http://forum.strataframe.net/FindPost14556.aspx

http://forum.strataframe.net/FindPost12211.aspx

http://forum.strataframe.net/FindPost14538.aspx

http://forum.strataframe.net/FindPost16492.aspx

I tried to make equal in it I finish topic passed for the Ivan but he did not give certain

In BO

in Form

What it is made a mistake?

I forgot myself to place the image of the configuration of combobox

These images are of the same component combobox
I need value sysProjetoBO1.prj_nrow in Value Member for sysProjetoEquipamentoBO of the propierty PopulationDataSourceSettings. How make this ?

In Portuguese

Eu preciso do valor sysProjetoBO1.prj_nrow na Value member do  sysProjetoEquipamentoBO  da propriedade PopulationDataSourceSettings. Como eu faço isso ?

Hi Rafael,

I noticed you have this code:

But, your FillByProjetoEquipamentoGL(Int32) is expecting an Integer and the prj_cod.Text is string, so you have to make sure the value of the prj_cod.Text is an Integer, so you need to convert it using cint() or the equivalent C## function.

Edhy Rijo