StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
WinForms (How do I?)
»
Using the WhereStatement
Using the WhereStatement
Post Reply
Like
0
Using the WhereStatement
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Bill Cunnien
Bill Cunnien
posted 15 Years Ago
ANSWER
HOT
Topic Details
Share Topic
Group: Forum Members
Posts: 785,
Visits: 3.6K
Good afternoon!
I have the following code working within a browse dialog.
private void WorkOrderBrowseDialog_Searching(object sender, MicroFour.StrataFrame.UI.Windows.Forms.BrowseDialogSearchingEventArgs e)
{
ArrayList mPartArray = new ArrayList();
using (PartsBO mPartsBO = new PartsBO())
{
mPartsBO.FillForComboBox(); // fills list for one division
foreach (PartsBO mBO in mPartsBO.GetEnumerable())
mPartArray.Add(mBO.partindex);
}
WhereStatement mWhere = new WhereStatement(new String[] { "partindex" }, mPartArray, WhereStatementTypeOptions.In);
e.RawWhereStatementsCollection.Add(mWhere);
}
The problem is, like always, speed. There are 1250 parts in the mPartsBO--more in the other division. The delay seems to be building that array. Is there any easier, faster, more economical way to reference the partindex field in the BO collection?
Thanks!
Bill
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Using the WhereStatement
Bill Cunnien
-
15 Years Ago
(bump)
Table Structure
WorkOrderMaster
...
Bill Cunnien
-
15 Years Ago
Sorry about the formatting...apparently, the posts get leading spaces...
Bill Cunnien
-
15 Years Ago
Bill,
I'm not quite clear on what your doing with the...
Greg McGuffey
-
15 Years Ago
Also, Bill, if you are using SQL 2008 you might take a look at the...
Charles R Hankey
-
15 Years Ago
Is it possible to substitute a SQL Stored Procedure for the logic of...
Bill Cunnien
-
15 Years Ago
[quote][b]Bill Cunnien (11/06/2009)[/b][hr]Is it possible to...
Bill Cunnien
-
15 Years Ago
Why not use the OverrideSearchTableName and OverrideSearchTableSchema?...
Trent L. Taylor
-
15 Years Ago
Cool! Thanks for the tip.
Good to see you back on the...
Bill Cunnien
-
15 Years Ago
Sorry for the absence! Had a lot going on lately. The good news is...
Trent L. Taylor
-
15 Years Ago
No worries on the absence...you need no excuse. We are all glad to...
Bill Cunnien
-
15 Years Ago
The search item is invisible, so I removed the checkmark on "Ignore...
Bill Cunnien
-
15 Years Ago
Good job...glad you got it going! :)
Trent L. Taylor
-
15 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search