Geeks With Blogs

@azamsharp
  • azamsharp The WWDC app says that there are new videos but there is nothing under videos!!! about 475 days ago
  • azamsharp Can I post my opinion on iOS 7 Beta or is it under NDA or something? about 475 days ago
  • azamsharp iOS 7 BETA installed successfully! about 475 days ago
  • azamsharp iOS 7 BETA installed! Now restoring! I am on NET10 which uses AT&T network. Hopefully 3G will still work! Lets c.. about 475 days ago
  • azamsharp The missing of button borders in Xcode 5 makes it hard to determine the clickable area. about 475 days ago
  • azamsharp I might wait for iOS to be released before I can put it on my device! Don't want a bricked or unstable device! about 475 days ago
  • azamsharp Android has many features that no one uses, number of versions that no one upgrades to and thousands of apps that no one pays for. about 475 days ago
  • azamsharp Maybe it is just me but the new iOS 7 UI looks like Windows Phone 8 UI! #maybeIamCrazy about 476 days ago
  • azamsharp Anyone using H20 network upgraded to iOS 7 BETA Keep me updated if you face any problems. about 476 days ago
  • azamsharp @merowing_ You already downloaded it! I cannot even load the developer's website! :( about 476 days ago

AzamSharp Some day I will know everything. I hope that day never comes.

 

One cool thing about Crystal Reports is that you can easily configure it to use your custom made strongly typed dataset. All you need to do is to create your dataset and use the Crystal Report "Database Expert" option to assign the source as ADO.NET DataSets. And finally you will need to populate the dataset in your C# code.

protected void Btn_DisplayReport(object sender, EventArgs e)

{

UserDataSet user = new UserDataSet();

SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

SqlDataAdapter ad = new SqlDataAdapter("SELECT * FROM Users", myConnection);

ad.Fill(user,"Users");

ReportDocument report = new ReportDocument();

report.FileName = Server.MapPath("UserReport.rpt");

report.SetDataSource(user);

CrystalReportViewer1.ReportSource = report;

}

Posted on Thursday, September 14, 2006 12:56 PM | Back to top


Comments on this post: Populating Crystal Reports With Custom Strongly Typed DataSet

# re: Populating Crystal Reports With Custom Strongly Typed DataSet
Requesting Gravatar...
Can you send me an sample
mouranet@gmail.com

Left by Alberto Moura on Feb 21, 2008 11:01 PM

# re: Populating Crystal Reports With Custom Strongly Typed DataSet
Requesting Gravatar...
Excellent article.
Thank you very much
Left by Tony Mathew on Feb 29, 2008 12:38 AM

Your comment:
 (will show your gravatar)
 


Copyright © Mohammad Azam | Powered by: GeeksWithBlogs.net | Join free