StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Populate Comboboxwith dependency of code product

Populate Comboboxwith dependency of code product

Rafael — Sun, 14 Sep 2008 23:34:37 GMT

How population combobox with dependency of code product.

[code]Select * from Produto where code_product = textbox_code_product[/code]

RE: Populate Comboboxwith dependency of code product

Rafael — Sun, 14 Sep 2008 23:34:37 GMT

I have a Example !

Eu preciso population a comboBox1 com o valor da textbox1. O Meu problema é que eu preciso fazer um Select * from ProjetoEquipamento where prj_nrow = value of textbox1 . Como population combobox whith Select ?

RE: Populate Comboboxwith dependency of code product

Trent L. Taylor — Sat, 13 Sep 2008 22:16:17 GMT

Rafael,

I think that you are inadvertantly making a very simple task very complex. As mentioned in previous posts, there are a lot of samples that show how to do this...and I know that other developers have tried to help you understand as well. Maybe at this point you should just create a simple sample illustrating your problem and post it out here instead of all of these posts as this doesn't really seem to be going anywhere. Maybe a real sample from YOUR perspective and then a correction via the forum posters will help you better undertstand where you are going wrong.

RE: Populate Comboboxwith dependency of code product

Rafael — Sat, 13 Sep 2008 00:40:24 GMT

yes, but my probleman is no this.

I modified my code for

[quote]        private void btnProjeto_Click(object sender, EventArgs e)
        {
            if (this.bdProjeto.ShowDialog() == DialogResult.OK)
            {
                prj_cod.Text = Convert.ToString(sysProjetoBO1.prj_cod);
                proj_eqp_nrow.Requery();
            }
        }
        private void proj_eqp_nrow_ListPopulating(MicroFour.StrataFrame.UI.ListPopulatingEventArgs e)
        {
            e.Parameters[0].Value = sysProjetoEquipamentoBO1.proj_eqp_nrow;
        }

[/quote]In BO
[quote]        public void FillByProjetoEquipamentoGL(int nRowProjeto)
        {
            GoLiveGlobals.infoMessageBox(nRowProjeto.ToString());
            //this.FillDataTable("select * from tabproj_equipamento where prj_nrow = " + nRowProjeto);
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = String.Format("select * from tabproj_equipamento where prj_nrow = " + nRowProjeto, this.TableName);
            this.FillDataTable(cmd);
        }[/quote]

In GoLiveGlobals.infoMessageBox(nRowProjeto.ToString()); return 0 ! Why ?

RE: Populate Comboboxwith dependency of code product

Edhy Rijo — Sat, 13 Sep 2008 00:09:35 GMT

Hi Rafael,

I noticed you have this code:

[codesnippet]private void proj_eqp_nrow_ListPopulating(MicroFour.StrataFrame.UI.ListPopulatingEventArgs e)
{
e.Parameters[0].Value = prj_cod.Text;
}
[/codesnippet]

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.

RE: Populate Comboboxwith dependency of code product

Rafael — Fri, 12 Sep 2008 23:43:11 GMT

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 ?

RE: Populate Comboboxwith dependency of code product

Rafael — Fri, 12 Sep 2008 15:01:39 GMT

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

RE: Populate Comboboxwith dependency of code product

Rafael — Fri, 12 Sep 2008 14:56:23 GMT

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

In BO

[quote]public void FillByProjetoEquipamentoGL(string nRowProjeto)
{
this.FillDataTable("SELECT * FROM "+ this.TableName);
}[/quote]

in Form

[quote]private void proj_eqp_nrow_ListPopulating(MicroFour.StrataFrame.UI.ListPopulatingEventArgs e)
{
e.Parameters[0].Value = prj_cod.Text;
}
private void proj_eqp_nrow_Leave(object sender, EventArgs e)
{
this.proj_eqp_nrow.Requery();
}[/quote]

What it is made a mistake?

RE: Populate Comboboxwith dependency of code product

Ivan George Borges — Fri, 12 Sep 2008 13:37:02 GMT

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

:cool:

RE: Populate Comboboxwith dependency of code product

Rafael — Fri, 12 Sep 2008 11:32:17 GMT

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

RE: Populate Comboboxwith dependency of code product

Trent L. Taylor — Fri, 12 Sep 2008 08:12:49 GMT

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.

RE: Populate Comboboxwith dependency of code product

Rafael — Thu, 11 Sep 2008 23:48:56 GMT

I tried to use the code below
[code]private void prj_cod_Leave(object sender, EventArgs e)

{

sysProjetoEquipamentoBO1.FillDataTable("SELECT * FROM tabproj_equipamento WHERE prj_nrow = " + sysProjetoBO1.prj_nrow);

}[/code]

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!

RE: Populate Comboboxwith dependency of code product

Dustin Taylor — Thu, 11 Sep 2008 23:04:29 GMT

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?

[codesnippet]MyBO.FillDataTable("SELECT * FROM Table WHERE code_product = " & cbo_Product.SelectedValue)[/codesnippet]
(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.