private void LoadData()
{
ErrorMsgLabel.Text = "";
string SSID = Request["SSID"].ToString();
string strLocateSection = Request["LocateSection"].ToString();
DataTable dtBoxNo = (DataTable)Session[SSID];
DataTable dtResult = new DataTable();
VGRModel.VDS_VGR06_BCO BCOVGR = new VGRModel.VDS_VGR06_BCO(ConntionDB);
for (int i = 0; i < dtBoxNo.Rows.Count; i++)
{
ParameterList.Clear();
ParameterList.Add(dtBoxNo.Rows[i]["box_no"].ToString());
ParameterList.Add(strLocateSection);
DataTable dtTemp = BCOVGR.QueryItemByBoxNO(ParameterList);
if (i == 0)
dtResult = dtTemp.Clone();
dtResult.Merge(dtTemp);
}
DataView dv = dtResult.DefaultView;
dv.Sort = "orderRemain asc,Remain_QTY asc,batch_no asc,box_no asc,item asc,period asc ";
string SessionIDName = "VGR062_" + PageTimeStamp.Value;
Session[SessionIDName] = dv.ToTable();
GridView1.DataSource = dv;
GridView1.DataBind();
}//page_load
