StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Listview

Listview

Rafael — Wed, 27 Aug 2008 10:26:48 GMT

I have two TabControl.

In second tabControl have a listview

In first tabControl have a textbox where will to be a code for populate listview, how i do for listview populate whith :

Select * from tabpedidocompraitem where code = ( is here a value of textbox )

RE: Listview

Bill Cunnien — Wed, 27 Aug 2008 10:26:48 GMT

If your "Method to Execute" on the ListView is set to the BO fill method as I outlined above (FillByTextBoxValue(string pTextBoxValue)), then all you need in the ListPopulating event is the following:

[codesnippet]
private void lvPedidoCompraItem_ListPopulating(ListPopulatingEventArgs e)
{
e.Parameters[0].Value = for_cod.Text;
}
[/codesnippet]

On the leave focus event of the textbox (or whereever you need it), all you have to do is:

[codesnippet]
lvPedidoCompraItem.Requery();
[/codesnippet]

RE: Listview

Edhy Rijo — Tue, 26 Aug 2008 16:54:54 GMT

[quote][b]Rafael (08/26/2008)[/b][hr]The error is first post this topic :)

http://forum.strataframe.net/Topic18700-6-1.aspx[/quote]

Rafael, you could not be getting the same error:[quote]BusinessLayerException

The ParentBusinessObject property must be set before FillByParent can be called with no parameters supplied.[/quote]

since the method to populate the BO could not be FillByParent. Can you post an screenshot of the List View Population Settings, I would like to see what you have in the Method to Execute.

Here is an example of what I use in one of my forms:

In this case I use the CopyDataFrom(BusinesLayerBase,BusinessCloneDataType) because I have an instance of the bizBuildings BO in the form and I simply update that BO instance and the listview will copy all records to the ListView internal BO. I find this method easier to maintain.

P.S

I'll be online for a couple of hours in case you want to pursue with this issue.

RE: Listview

Rafael — Tue, 26 Aug 2008 16:43:42 GMT

The error is first post this topic :)

http://forum.strataframe.net/Topic18700-6-1.aspx

RE: Listview

Edhy Rijo — Tue, 26 Aug 2008 16:37:18 GMT

Ok, even though I use VB your code looks good, all you have to do now is just requery the ListView control in one of the places mentioned by Bill, in the Textbox control or in the Page's Activate.

Are you getting any specific error? or just the listview is not being populated?

RE: Listview

Rafael — Tue, 26 Aug 2008 16:32:28 GMT

RE: Listview

Edhy Rijo — Tue, 26 Aug 2008 16:31:40 GMT

So it is now working for you?

RE: Listview

Rafael — Tue, 26 Aug 2008 15:43:53 GMT

For population in Load Form, i configured populationDataSourceSetings and implemnt this code:

[code]        private void lvPedidoCompraItem_ListPopulating(ListPopulatingEventArgs e)
        {
            e.Parameters[0].Value = this.sysPedidoCompraItemBO1;
            e.Parameters[1].Value = MicroFour.StrataFrame.Business.BusinessCloneDataType.ClearAndFillFromDefaultView;
        }

        private void lvPedidoCompraItem_RowPopulating(RowPopulatingEventArgs e)
        {
            //-- Establish Locals
            sysPedidoCompraItemBO loBO = ((sysPedidoCompraItemBO)e.BusinessObject);

            //-- Set the not count
            //e.Values[1].DisplayValue = CustomerNotes.GetNoteCount(loBO.cust_pk).ToString("n0");
        }[/code]

But i use [code]e.Parameters[0].Value = for_cod.Text;[/code] and delete [code]sysPedidoCompraItemBO loBO = ((sysPedidoCompraItemBO)e.BusinessObject);[/code], when initialize form with error.

RE: Listview

Bill Cunnien — Tue, 26 Aug 2008 13:33:27 GMT

[quote]What is a bether method to used populate of listview ?

Please say me a method that used in populate listview and i search in documentation.[/quote]

You could pass the parameter in the Requery method of the ListView:

MyListView.Requery(myCoolParameter);

But, as I found out over time, it is better to pass the parameter in the ListPopulating event of the ListView (from docs using VB):

[codesnippet]
Private Sub ListView1_ListPopulating(ByVal e As MicroFour.StrataFrame.UI.ListPopulatingEventArgs) Handles ListView1.ListPopulating
'-- Pass the search text to the FillByLastName() method
e.Parameters(0).Value = Me.txtSearch.Text
End Sub
[/codesnippet]

Then, whenever you need to refresh the ListView control, it is a simple call to its Requery method:

MyListView.Requery();

No need to remember to pass a parameter since it is handled in the event. Good stuff. A "set it and forget it" type of approach.

RE: Listview

Bill Cunnien — Tue, 26 Aug 2008 13:26:09 GMT

[quote]You do...scroll down and open the last 10 posts in descending order section.[/quote]

Whoa. :blink:

Thanks! :w00t:

RE: Listview

Greg McGuffey — Tue, 26 Aug 2008 13:22:12 GMT

[quote]You do...scroll down and open the last 10 posts in descending order section.[/quote]

Wow, never noticed that! That's cool! :w00t:

Thanks for asking Bill...I've often done the quoting thing myself. The last 10 posts is much better. I also noticed that you can also open the complete topic in a new window...even better for those lonnnnng posts.

RE: Listview

Greg McGuffey — Tue, 26 Aug 2008 13:19:13 GMT

Rafael,

Not sure what your asking, if anything. Do you still have a question?

RE: Listview

Rafael — Tue, 26 Aug 2008 13:13:17 GMT

I understand and very very thanks.

I will do in event Leave of textbox, but i have a question.

What is a bether method to used populate of listview ?

Please say me a method that used in populate listview and i search in documentation.

If i have doubt, question in the forum.

RE: Listview

Trent L. Taylor — Tue, 26 Aug 2008 13:12:09 GMT

[quote](note to forum admins: it would be nice to have a view of the post to which we are replying...thanks!)[/quote]

You do...scroll down and open the last 10 posts in descending order section.

RE: Listview

Greg McGuffey — Tue, 26 Aug 2008 12:53:46 GMT

The other part of the picture is to setup the listview appropriately. This would be a two parter...

1. Obviously you'd set the ListView to use the custom method that Bill mentioned and you'd handle the ListPopulating event of the listview to get the value from the textbox.

2. You'd then need to set the listview to load manually (rather than on form load), by setting the PopulateOnFormLoad property to Manual. Of course then you need to manually fill it. To do this you'd call .Requery() as appropriate. Likely in either the TextBox.Leave event or perhaps when the tab page is activated.

Hope that helps! :D

RE: Listview

Bill Cunnien — Tue, 26 Aug 2008 12:46:55 GMT

:blush: Sorry...didn't mean to quote your whole post...I was using that as a guide and forgot to delete it before I posted.

Bill

(note to forum admins: it would be nice to have a view of the post to which we are replying...thanks!)

RE: Listview

Bill Cunnien — Tue, 26 Aug 2008 12:43:25 GMT

[quote][b]Rafael (08/26/2008)[/b][hr]I have two TabControl.

In second tabControl have a listview

In first tabControl have a textbox where will to be a code for populate listview, how i do for listview populate whith :

Select * from tabpedidocompraitem where code = ( is here a value of textbox )[/quote]

You would use a custom fill method in the tabpedidocompraitem business object. Like this:

[codesnippet]
public void FillByTextBoxValue(string pTextBoxValue)
{
    SqlCommand cmd = new SqlCommand("SELECT * FROM tabpedidocompraitem WHERE code = @textboxvalue");
    cmd.CommandType = CommandType.Text;
    cmd.Parameters.AddWithValue("@textboxvalue", pTextBoxValue).SqlDbType = SqlDbType.VarChar;
    FillDataTable(cmd);
}
[/codesnippet]

Follow the SF documentation under "ListView Population". Marvelous step-by-step to help you with the whole setup.

Hope that helps,
Bill