Can anyone help to check what I am missing? I am going to update some UD field created on the table Resource with DynamicQueryAdapter. but it always failed at ExecuteByID method. It is urgent for me. Thanks so much in advance.
private void SetReourceStatus(string GrpID,string ResourceID,string JobNum, DateTime dt,string strStatus,int intAsm,int intOpr)
{
MessageBox.Show("setstatus begin");
DynamicQueryAdapter dqa=new DynamicQueryAdapter(oTrans);
Ice.BO.QueryExecutionDataSet ds =new Ice.BO.QueryExecutionDataSet();
MessageBox.Show(GrpID);
MessageBox.Show(ResourceID);
ds.ExecutionParameter.AddExecutionParameterRow("ParaGrpID",GrpID.ToString(),"nvarchar",false,Guid.Empty,"A");
ds.ExecutionParameter.AddExecutionParameterRow("ParaResourceID",ResourceID.ToString(),"nvarchar",false,Guid.Empty,"A");
MessageBox.Show("setstatus begin 2");
dqa.ExecuteByID("mesResource",ds);
MessageBox.Show("setstatus begin 3");
if (dqa.QueryResults.Tables["Results"].Rows.Count >0)
{
DataRow dqItem = dqa.QueryResults.Tables["Results"].Rows[0];
dqItem["Job_Running_c"] = JobNum;
dqItem["Job_Status_c"] = strStatus;
MessageBox.Show("setstatus begin 4");
dqItem["TheStatusTime_c"] = dt;
dqItem["AsmNum_c"] = intAsm;
dqItem["OprNum_c"] = intOpr;
dqItem["RowMod"] = "U";
}
dqa.Update();
dqa.Dispose();
}