How to bind crystal report to manually created DataSet

by

There is only way out. As suggested by rosado. Little bit explained
1. CReate a RPT File.
2. Create a XSD with the desired columns.
3. Drag drop the columns on the rpt. Format it as required.
4. Now create connection, use adapter to fill that dataset.
5. Filling u dataset will automatically fill the report columns.

Below is a sample code from one of mine project.

Invoice invoice = new Invoice(); // instance of my rpt file
var ds = new DsBilling();  // DsBilling is mine XSD
var table2 = ds.Vendor;
var adapter2 = new VendorTableAdapter();
adapter2.Fill(table2);                   

var table = ds.Bill;
var adapter = new BillTableAdapter();
string name = cboCustReport.Text;
int month = int.Parse(cboRptFromMonth.SelectedItem.ToString());
int year = int.Parse(cboReportFromYear.SelectedItem.ToString());
adapter.Fill(table, name,month,year);

ds.AcceptChanges();

invoice.SetDataSource(ds);
crystalReportViewer1.ReportSource = invoice;
crystalReportViewer1.RefreshReport();

More Related Contents:

  1. How I can filter a Datatable?
  2. Stored procedure return into DataSet in C# .Net
  3. Convert Dataset to XML
  4. How to stop crystal report viewer from asking login credentials when opening subreport
  5. Using parameters inserting data into access database
  6. How to create JSON string in C#
  7. Read data from SqlDataReader
  8. System.MissingMethodException: Method not found?
  9. How can I create a dynamic button click event on a dynamic button?
  10. GridView must be placed inside a form tag with runat=”server” even after the GridView is within a form tag
  11. Export DataTable to Excel File
  12. ASP.Net URLEncode Ampersand for use in Query String
  13. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  14. What SqlDbType maps to varBinary(max)?
  15. Can we create custom HTTP Status codes?
  16. Interop.Word Documents.Open is null
  17. How to delete cookies on an ASP.NET website
  18. How to make the .net HttpClient use http 2.0?
  19. Getting Nested Object Property Value Using Reflection
  20. What does square bracket [] mean in the below code?
  21. When `PostAuthenticateRequest` gets execute?
  22. User in Entity type MVC5 EF6
  23. How to write a transaction to cover Moving a file and Inserting record in database?
  24. Restrict route to controller namespace in ASP.NET Core
  25. How to Get the HTTP Post data in C#?
  26. Unable to serialize the session state
  27. Asp .NET Button – OnClientClick=”return function()” vs OnClientClick=”function()”
  28. When to use Request.Cookies over Response.Cookies?
  29. SignalR – Checking if a user is still connected
  30. Get first element from a dictionary

Leave a Comment