////////// FUNCTIONS //////////
private void VS_Show()
{
// Add the results of the query to the DataGrid
using (var _rs = new StaticRS($"select ROUTE,FINIS,QTY,[PENDING QTY]=QtyPending,DEALER,[DESCRIPTION]=DealerDesc,[ORDER NUMBER]=OrderNumber,[ORDER LINE]=OrderItemNumber,[RECEIVAL CODE]=ReceivalCode,[RECEIVAL LINE]=Line from vPendingLines where cod3='{Values.COD3}' and (Route='{cboRoute.Text}' or '{cboRoute.Text}'='') order by Route,Dealer,OrderNumber,OrderItemNumber,Finis", Values.gDatos))
{
_rs.Open();
VS.DataSource = _rs.DataObject;
}
VS.CurrentCell = null;
VS.Refresh();
if (VS.Rows.Count == 0)
{
VS.Tag = "";
}
}