public void GetAllCostumers()
 {
     try
     {
         var pResult = "";
         var ds      = _wscalled.GetAllCostumers(Session["connectionString"].ToString(), ref pResult);
         if (pResult == "")
         {
             if (ds.Tables[0].Rows.Count > 0)
             {
                 ASPxGridLookup1.DataSource = ds;
                 //ASPxGridLookup1.TextField = "NAME_CLASSIFICATION";
                 //ASPxGridLookup1.ValueField = "CLASSIFICATION";
                 ASPxGridLookup1.DataBind();
             }
             Session["CUSTOMER"] = ds;
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
     }
 }
 public void LoadClient()
 {
     try
     {
         var pResult = "";
         var ds      = _objPicking.GetAllCostumers(Session["connectionString"].ToString(), ref pResult);
         if (pResult == "")
         {
             var regionCombo = (ASPxGridView1.Columns["CLIENTE"] as GridViewDataComboBoxColumn);
             if (regionCombo != null)
             {
                 regionCombo.PropertiesComboBox.DataSource = ds.Tables[0];
                 regionCombo.PropertiesComboBox.ValueField = "NAME_CUSTOMER";
                 regionCombo.PropertiesComboBox.TextField  = "NAME_CUSTOMER";
             }
         }
         else
         {
             ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
         }
     }
     catch (Exception ex)
     {
         ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
     }
 }