Guest User

Untitled

a guest
Mar 29th, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.23 KB | None | 0 0
  1. string Username = "**********";
  2. string password = "**********";
  3. IOrganizationService _service;
  4. ClientCredentials credentials = new ClientCredentials();
  5. credentials.UserName.UserName = Username;
  6. credentials.UserName.Password = password;
  7. credentials.Windows.ClientCredential = CredentialCache.DefaultNetworkCredentials;
  8. Uri serviceUri = new Uri("https://*******.api.crm**.dynamics.com/XRMServices/2011/Organization.svc");
  9.  
  10. Uri HomeRealm = null;
  11.  
  12.  
  13. ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
  14. OrganizationServiceProxy proxy = new OrganizationServiceProxy(serviceUri, HomeRealm, credentials, null);
  15. {
  16.  
  17. _service = (IOrganizationService)proxy;
  18.  
  19. }
  20. return _service;
  21. }<!---- Modal Gridvview popup for Dynamic crm -------!>protected void Page_Load(object sender, EventArgs e)
  22. {
  23. IOrganizationService _service = GetCRMService();
  24. QueryExpression Query = new QueryExpression("contact");
  25. Query.ColumnSet.AllColumns = true;
  26. filtering conditions
  27. Query.Criteria.AddCondition("fullname", ConditionOperator.NotEqual, "xxx");
  28. Query.Criteria.AddCondition("emailaddress1", ConditionOperator.NotEqual, "xxx");
  29. Query.Criteria.AddCondition("telephone1", ConditionOperator.NotEqual, "xxx");
  30. Query.Criteria.AddCondition("address1_line2", ConditionOperator.NotEqual, "xxx");
  31. EntityCollection collection = _service.RetrieveMultiple(Query);
  32. DataTable dt = new DataTable();
  33. dt.Columns.Add("fullname");
  34. dt.Columns.Add("emailaddress1");
  35. dt.Columns.Add("telephone1");
  36. dt.Columns.Add("address1_line2");
  37. dt.Columns.Add("");
  38.  
  39. foreach (Entity entity in collection.Entities)
  40. {
  41. DataRow dr = dt.NewRow();
  42. dr["fullname"] = entity.Attributes["fullname"].ToString();
  43. dr["emailaddress1"] = entity.Attributes["emailaddress1"].ToString();
  44. dr["telephone1"] = entity.Attributes["telephone1"].ToString();
  45. dr["address1_line2"] = entity.Attributes["address1_line2"].ToString();
  46. dt.Rows.Add(dr);
  47. }
  48. GridView1.DataSource = dt;
  49. GridView1.DataBind();
  50.  
  51.  
  52. }
Add Comment
Please, Sign In to add comment