skearney
(Shannon Kearney)
October 3, 2018, 3:40pm
1
I have been struggling with this for a while. I need multiple Dynamic Queries to run and populate grids when a text box is populated.
I used @josecgomez example for how to call a query from code. I am able to get one grid to populate with this example. However, I have multiple grids that I need to populate using the same object. Here is my code. The only one that works is the first Dynamic Query. I have the others commented out so I could continue testing something else.
private void changeordernumber()
{
epiNumericOrderNumRef.Value = numOrderDtl_OrderNum.Value;
//Order Detail Grid That is Hidden From View
DynamicQueryAdapter dqa = new DynamicQueryAdapter(oTrans);
dqa.BOConnect();
QueryExecutionDataSet qeds = dqa.GetQueryExecutionParametersByID("GS_Order_Detail_Params");
qeds.ExecutionParameter.Clear();
qeds.ExecutionParameter.AddExecutionParameterRow("OrderNum", epiNumericOrderNumRef.Value.ToString() , "nvarchar", false, Guid.NewGuid(), "C");
dqa.ExecuteByID("GS_Order_Detail_Params", qeds);
grid_OrderDetails.DataSource = dqa.QueryResults.Tables["Results"];
edvV_GS_Order_Detail_All_1View.ResetDataView(dqa.QueryResults.Tables["Results"].DefaultView);
edvV_GS_Order_Detail_All_1View.Notify(new EpiNotifyArgs(oTrans, 0, EpiTransaction.NotifyType.Initialize));
//Order Movement All Tab
epiNumericOrderNumRef.Value = numOrderDtl_OrderNum.Value;
DynamicQueryAdapter dqa1 = new DynamicQueryAdapter(oTrans);
dqa1.BOConnect();
QueryExecutionDataSet qeds1 = dqa1.GetQueryExecutionParametersByID("GS_UD09_Movement_All");
qeds1.ExecutionParameter.Clear();
qeds1.ExecutionParameter.AddExecutionParameterRow("OrderNum", epiNumericOrderNumRef.Value.ToString() , "nvarchar", false, Guid.NewGuid(), "D");
dqa1.ExecuteByID("GS_UD09_Movement_All", qeds1);
grid_Movement_All.DataSource = dqa1.QueryResults.Tables["Results1"];
/*//Order Misc Charges
DynamicQueryAdapter dqa2 = new DynamicQueryAdapter(oTrans);
dqa2.BOConnect();
QueryExecutionDataSet qeds2 = dqa2.GetQueryExecutionParametersByID("GS_Misc_Charges");
qeds2.ExecutionParameter.Clear();
qeds2.ExecutionParameter.AddExecutionParameterRow("OrderNum", epiNumericOrderNumRef.Value.ToString() , "nvarchar", false, Guid.NewGuid(), "E");
dqa2.ExecuteByID("GS_Misc_Charges", qeds2);
grid_MiscCharges.DataSource = dqa2.QueryResults.Tables["Results2"];
//Order Movement Last
DynamicQueryAdapter dqa3 = new DynamicQueryAdapter(oTrans);
dqa3.BOConnect();
QueryExecutionDataSet qeds3 = dqa3.GetQueryExecutionParametersByID("GS_UD09_Movement");
qeds3.ExecutionParameter.Clear();
qeds3.ExecutionParameter.AddExecutionParameterRow("OrderNum", epiNumericOrderNumRef.Value.ToString() , "nvarchar", false, Guid.NewGuid(), "F");
dqa3.ExecuteByID("GS_UD09_Movement", qeds3);
grid_LastOrderMovement.DataSource = dqa3.QueryResults.Tables["Results3"];*/
}
I am surprised the first one even works. The table name is Results and doesnt change:
grid_Movement_All.DataSource = dqa1.QueryResults.Tables[“Results”];
grid_MiscCharges.DataSource = dqa2.QueryResults.Tables[“Results”];
etc
skearney
(Shannon Kearney)
October 3, 2018, 5:55pm
3
@Chris_Conn Is this what you are suggesting I do? Sorry, I am not that great with code right now. Still learning!
private void changeordernumber()
{
epiNumericOrderNumRef.Value = numOrderDtl_OrderNum.Value;
//Order Detail Grid That is Hidden From View
DynamicQueryAdapter dqa = new DynamicQueryAdapter(oTrans);
dqa.BOConnect();
QueryExecutionDataSet qeds = dqa.GetQueryExecutionParametersByID(“GS_Order_Detail_Params”);
qeds.ExecutionParameter.Clear();
qeds.ExecutionParameter.AddExecutionParameterRow(“OrderNum”, epiNumericOrderNumRef.Value.ToString() , “nvarchar”, false, Guid.NewGuid(), “C”);
dqa.ExecuteByID(“GS_Order_Detail_Params”, qeds);
grid_OrderDetails.DataSource = dqa.QueryResults.Tables[“Results”];
edvV_GS_Order_Detail_All_1View.ResetDataView(dqa.QueryResults.Tables[“Results”].DefaultView);
edvV_GS_Order_Detail_All_1View.Notify(new EpiNotifyArgs(oTrans, 0, EpiTransaction.NotifyType.Initialize));
//Order Movement All Tab
QueryExecutionDataSet qeds1 = dqa1.GetQueryExecutionParametersByID(“GS_UD09_Movement_All”);
qeds1.ExecutionParameter.Clear();
qeds1.ExecutionParameter.AddExecutionParameterRow(“OrderNum”, epiNumericOrderNumRef.Value.ToString() , “nvarchar”, false, Guid.NewGuid(), “D”);
dqa1.ExecuteByID(“GS_UD09_Movement_All”, qeds1);
grid_Movement_All.DataSource = dqa1.QueryResults.Tables[“Results”];
I am getting the following errors:
The name dqa1 Does not exist in the current context.
Thanks!
private void changeordernumber()
{
epiNumericOrderNumRef.Value = numOrderDtl_OrderNum.Value;
//Order Detail Grid That is Hidden From View
DynamicQueryAdapter dqa = new DynamicQueryAdapter(oTrans);
dqa.BOConnect();
QueryExecutionDataSet qeds = dqa.GetQueryExecutionParametersByID("GS_Order_Detail_Params");
qeds.ExecutionParameter.Clear();
qeds.ExecutionParameter.AddExecutionParameterRow("OrderNum", epiNumericOrderNumRef.Value.ToString() , "nvarchar", false, Guid.NewGuid(), "C");
dqa.ExecuteByID("GS_Order_Detail_Params", qeds);
grid_OrderDetails.DataSource = dqa.QueryResults.Tables["Results"];
edvV_GS_Order_Detail_All_1View.ResetDataView(dqa.QueryResults.Tables["Results"].DefaultView);
edvV_GS_Order_Detail_All_1View.Notify(new EpiNotifyArgs(oTrans, 0, EpiTransaction.NotifyType.Initialize));
//Order Movement All Tab
epiNumericOrderNumRef.Value = numOrderDtl_OrderNum.Value;
DynamicQueryAdapter dqa1 = new DynamicQueryAdapter(oTrans);
dqa1.BOConnect();
QueryExecutionDataSet qeds1 = dqa1.GetQueryExecutionParametersByID("GS_UD09_Movement_All");
qeds1.ExecutionParameter.Clear();
qeds1.ExecutionParameter.AddExecutionParameterRow("OrderNum", epiNumericOrderNumRef.Value.ToString() , "nvarchar", false, Guid.NewGuid(), "D");
dqa1.ExecuteByID("GS_UD09_Movement_All", qeds1);
grid_Movement_All.DataSource = dqa1.QueryResults.Tables["Results"];
//Order Misc Charges
DynamicQueryAdapter dqa2 = new DynamicQueryAdapter(oTrans);
dqa2.BOConnect();
QueryExecutionDataSet qeds2 = dqa2.GetQueryExecutionParametersByID("GS_Misc_Charges");
qeds2.ExecutionParameter.Clear();
qeds2.ExecutionParameter.AddExecutionParameterRow("OrderNum", epiNumericOrderNumRef.Value.ToString() , "nvarchar", false, Guid.NewGuid(), "E");
dqa2.ExecuteByID("GS_Misc_Charges", qeds2);
grid_MiscCharges.DataSource = dqa2.QueryResults.Tables["Results"];
//Order Movement Last
DynamicQueryAdapter dqa3 = new DynamicQueryAdapter(oTrans);
dqa3.BOConnect();
QueryExecutionDataSet qeds3 = dqa3.GetQueryExecutionParametersByID("GS_UD09_Movement");
qeds3.ExecutionParameter.Clear();
qeds3.ExecutionParameter.AddExecutionParameterRow("OrderNum", epiNumericOrderNumRef.Value.ToString() , "nvarchar", false, Guid.NewGuid(), "F");
dqa3.ExecuteByID("GS_UD09_Movement", qeds3);
grid_LastOrderMovement.DataSource = dqa3.QueryResults.Tables["Results"];
}
skearney
(Shannon Kearney)
October 3, 2018, 6:22pm
5
Yes!!! Fantastic! That works! Thank you so much!
Shannon