-->

30 December 2019

How to Reset or Relink datatable in Crystal Report Asp.Net

  Asp.Net CS By Example       30 December 2019

  How to Reset or Relink datatable in Crystal Report Asp.Net

  In this post, we learn on How to Reset or Relink Datatable in Crystal Reports in asp.net.

 There are many situation occur than when we move Crystal Report from one Project or Datatable move from one Dataset to another dataset or Datatable is misplace and we not getting in project then we need to create new one datatable in dataset and need to relink datatable with crystal report.

1) To Add existing Dataset To Project follow below Steps:
   => Right Click On Project.
   => Select Existing Item.
Right click On Project.png

   => Select dataset file of (Visaul Studio Dataset Internal Info File) extension(.xsc) view as [Check List View on Icon].
Select dataset file.png

  

2) Now In Crytal Report Relink or Reset Datatabe follow below Steps:
   => Right Click On Database Filed
   => Select 'Set Datasource Location'
Set Datasource Location.png

   => Now Set Datasource Location window will opened. Right Click On 'Project Data'
Set Datasource Location Screen.png

   => Click On 'Refresh'
Right Click Project.PNG

   => Now Expand 'Project Data' Option.
Expand Project Data.png

   => Expand 'ADO.NET Dataset'.
Expand ADO.NET Dataset.png

   => Select Which Dataset we want to Link.
   => Click On Both dataset of Crytal and Project.
   => Click On 'Update' Button.
   => Now Click on 'Close' Button.
Dataset Update.png


3) Now Check very our changes are reflected or not follow below step if Database varify means changes are done.
   => Right Click On Database Filed
   => Click On 'Virify DataBase'
   => Check Now Whatever Field added in Dataset is reflected or not. If Reflacted means Crytal Dataset is link with Project Dataset.

logoblog

Thanks for reading How to Reset or Relink datatable in Crystal Report Asp.Net

Previous
« Prev Post

No comments:

Post a Comment

Please do not enter any spam link in the comment box.