Answered by:
How to retrieve records form ms CRM Database to Asp.net page in MS CRM 2011

Question
-
Hi ,
I have created an Asp.net application with two forms one is to store Student information and another one is to Search the registered student.So in the second (Search) form have one button called "Find".In this form i will enter student registration id and click Find button to search a record.
How can I achieve this ,how to get the records from crm database to asp.net form. please help me....
Saturday, November 19, 2011 3:26 PM
Answers
-
Hi,
You can use CRM Webservice in ASP.Net using SDK libraries as mentioned in the following post : http://blogs.msdn.com/b/crminthefield/archive/2011/05/18/how-to-create-a-simple-webpage-leveraging-the-crm-2011-iorganizationservice-web-service.aspx or consuming directly the WCF webservices by adding the web services reference in VS project.
In Asp.Net webpage find button click event you can call the CRM Webservice RetrieveMultiple (QueryByAttribute) method to fetch the record data by registration Id field, for retrieving data by RetrieveMultiple you may refer the following link: http://msdn.microsoft.com/en-us/library/gg334708.aspx
You may also query CRM database directly (can create a database connection and fetch data by view using datasets) by using the FilteredViews: http://msdn.microsoft.com/en-us/library/gg309722.aspx
http://www.powerobjects.com/blog/2011/09/30/filtering-views-in-dynamics-crm-2011/
Jehanzeb Javeed
http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".- Edited by Jehanzeb.Javeed Sunday, November 20, 2011 10:24 PM Added Filtered Views Details
- Proposed as answer by Jehanzeb.Javeed Sunday, November 20, 2011 10:24 PM
- Marked as answer by DavidJennawayMVP, Moderator Wednesday, December 14, 2011 3:12 PM
Sunday, November 20, 2011 10:23 PM
All replies
-
Saturday, November 19, 2011 9:35 PM
-
hi Shetty kp
In Crm 2011 In order to interact with CRM entities in two way
early bind and late bind
Early bound entity classes that provide strong type support to aid development at design time.
here is an example
http://msdn.microsoft.com/en-us/library/gg334754.aspx
Late bound entity class, which enables your code to work with entities that do not exist at design time
example
http://msdn.microsoft.com/en-us/library/gg328416.aspx
Hope this helps
Dkay
--------------------------------------------------------------------------------
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
Also Shetty kp this is regarding your earlier post on Retrive the value of type date & time
if the response answered your question, please take a minute and mark the response as an answer.
Sunday, November 20, 2011 8:34 AM -
Hi,
You can use CRM Webservice in ASP.Net using SDK libraries as mentioned in the following post : http://blogs.msdn.com/b/crminthefield/archive/2011/05/18/how-to-create-a-simple-webpage-leveraging-the-crm-2011-iorganizationservice-web-service.aspx or consuming directly the WCF webservices by adding the web services reference in VS project.
In Asp.Net webpage find button click event you can call the CRM Webservice RetrieveMultiple (QueryByAttribute) method to fetch the record data by registration Id field, for retrieving data by RetrieveMultiple you may refer the following link: http://msdn.microsoft.com/en-us/library/gg334708.aspx
You may also query CRM database directly (can create a database connection and fetch data by view using datasets) by using the FilteredViews: http://msdn.microsoft.com/en-us/library/gg309722.aspx
http://www.powerobjects.com/blog/2011/09/30/filtering-views-in-dynamics-crm-2011/
Jehanzeb Javeed
http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".- Edited by Jehanzeb.Javeed Sunday, November 20, 2011 10:24 PM Added Filtered Views Details
- Proposed as answer by Jehanzeb.Javeed Sunday, November 20, 2011 10:24 PM
- Marked as answer by DavidJennawayMVP, Moderator Wednesday, December 14, 2011 3:12 PM
Sunday, November 20, 2011 10:23 PM -
Hi Shetty .Did this help?
Please make sure to mark as answer to the response that helped you get through. This will help others with similar problem identify the answer and also close this thread as resolved.
Thanks
Dk
Monday, November 21, 2011 10:53 AM