Populating Grids

Yahoo Archive
1
Hey Jim,

That worked like a charm, thanks! Say hello to the old gang for me.

Take care,

Scott

--- In vantage@yahoogroups.com, "jckinneman" <jckinneman@...> wrote:
>
> The data is in data tables so normal C# techniques to loop or search through the table will work. Once you have found the row of interest through whichever approach you can change the value using the code you used.
>
> pseudo code brute force
> for each datarow dr in ud09Adapter.UD09Data.UD09.Rows
> // do some sort of test to see if row of interest
> // if the row of interest make a change to it
> next dr
>
> You can also use default views, selected and other table based techniques. Google "search filter datatable c#"
>
> Jim Kinneman
> Encompass Solutions, Inc
>
> --- In vantage@yahoogroups.com, "altyrocks" <alty_rocks@> wrote:
> >
> > It appears that setting that value will only affect the row that is highlighted. What I need is to be able to search through the grid and find the line to update and them update it and redisplay on the screen.
> >
> > --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@> wrote:
> >
> > Replace [0] with [edvUD09.Row].
> >
> > Brian.
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of altyrocks
> > Sent: Tuesday, June 05, 2012 12:17 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Populating Grids
> >
> >
> >
> >
> >
> > I'm running Epicor 9.05.605 and I'm trying to update a grid with data
> > from some fields on the screen after I hit the "update" button. The grid itself is read-only. Is there a way (using c# in the script editor) to > be able to search through a grid to find the record or row that I need to update? I tried this code:
> >
> > ud09Adapter.UD09Data.UD09.Rows[0].BeginEdit();
> > edvUD09.dataView[edvUD09.Row]["Number04"] = "3";
> > ud09Adapter.UD09Data.UD09.Rows[0].EndEdit();
> >
> > but this always updates the first row. I need to be able to find the row
> > that I need to update but not sure what the code is to replace the
> > Rows[0] in my above example.
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
2
I'm running Epicor 9.05.605 and I'm trying to update a grid with data from some fields on the screen after I hit the "update" button. The grid itself is read-only. Is there a way (using c# in the script editor) to be able to search through a grid to find the record or row that I need to update? I tried this code:

ud09Adapter.UD09Data.UD09.Rows[0].BeginEdit();
edvUD09.dataView[edvUD09.Row]["Number04"] = "3";
ud09Adapter.UD09Data.UD09.Rows[0].EndEdit();

but this always updates the first row. I need to be able to find the row that I need to update but not sure what the code is to replace the Rows[0] in my above example.
3
Replace [0] with [edvUD09.Row].

Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of altyrocks
Sent: Tuesday, June 05, 2012 12:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Populating Grids





I'm running Epicor 9.05.605 and I'm trying to update a grid with data
from some fields on the screen after I hit the "update" button. The grid
itself is read-only. Is there a way (using c# in the script editor) to
be able to search through a grid to find the record or row that I need
to update? I tried this code:

ud09Adapter.UD09Data.UD09.Rows[0].BeginEdit();
edvUD09.dataView[edvUD09.Row]["Number04"] = "3";
ud09Adapter.UD09Data.UD09.Rows[0].EndEdit();

but this always updates the first row. I need to be able to find the row
that I need to update but not sure what the code is to replace the
Rows[0] in my above example.





[Non-text portions of this message have been removed]
4
It appears that setting that value will only affect the row that is highlighted. What I need is to be able to search through the grid and find the line to update and them update it and redisplay on the screen.

--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:

Replace [0] with [edvUD09.Row].

Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of altyrocks
Sent: Tuesday, June 05, 2012 12:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Populating Grids





I'm running Epicor 9.05.605 and I'm trying to update a grid with data
from some fields on the screen after I hit the "update" button. The grid itself is read-only. Is there a way (using c# in the script editor) to > be able to search through a grid to find the record or row that I need to update? I tried this code:

ud09Adapter.UD09Data.UD09.Rows[0].BeginEdit();
edvUD09.dataView[edvUD09.Row]["Number04"] = "3";
ud09Adapter.UD09Data.UD09.Rows[0].EndEdit();

but this always updates the first row. I need to be able to find the row
that I need to update but not sure what the code is to replace the
Rows[0] in my above example.





[Non-text portions of this message have been removed]
5
The data is in data tables so normal C# techniques to loop or search through the table will work. Once you have found the row of interest through whichever approach you can change the value using the code you used.

pseudo code brute force
for each datarow dr in ud09Adapter.UD09Data.UD09.Rows
// do some sort of test to see if row of interest
// if the row of interest make a change to it
next dr

You can also use default views, selected and other table based techniques. Google "search filter datatable c#"

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "altyrocks" <alty_rocks@...> wrote:
>
> It appears that setting that value will only affect the row that is highlighted. What I need is to be able to search through the grid and find the line to update and them update it and redisplay on the screen.
>
> --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@> wrote:
>
> Replace [0] with [edvUD09.Row].
>
> Brian.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of altyrocks
> Sent: Tuesday, June 05, 2012 12:17 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Populating Grids
>
>
>
>
>
> I'm running Epicor 9.05.605 and I'm trying to update a grid with data
> from some fields on the screen after I hit the "update" button. The grid itself is read-only. Is there a way (using c# in the script editor) to > be able to search through a grid to find the record or row that I need to update? I tried this code:
>
> ud09Adapter.UD09Data.UD09.Rows[0].BeginEdit();
> edvUD09.dataView[edvUD09.Row]["Number04"] = "3";
> ud09Adapter.UD09Data.UD09.Rows[0].EndEdit();
>
> but this always updates the first row. I need to be able to find the row
> that I need to update but not sure what the code is to replace the
> Rows[0] in my above example.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>