The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
PJPoornima Joy Balan Syncfusion Team October 8, 2007 05:52 AM UTC
Hello,
Here's the code snippet to dynamically bind dataset in crystal report at run time.
String connString = @"Provider=SQLOLEDB.1;User ID=yourid;Password=yourpassword;Persist Security Info=True;Network Address=yourIP;Initial Catalog=databasename"; OleDbConnection conn = new OleDbConnection(connString); conn.Open(); string query = "SELECT * from table"; OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(query, conn); DataSet dataReport = new DataSet(); myDataAdapter.Fill(dataReport);
CrystalReport1 rep = new CrystalReport1(); rep.SetDataSource(dataReport); crystalReportViewer1.ReportSource = rep;
Let me know, any further queries.
Regards, Poornima
ADAdministrator Syncfusion Team February 4, 2009 05:37 PM UTC
hai attaching dataset to report ok but in report i dint added any table i wil not get data .i should add same tables which i specified in select statment and should i drag feilds which i want? i want clarity what ur saying plz tell
ADAdministrator Syncfusion Team February 4, 2009 05:38 PM UTC
hai attaching dataset to report ok but in report i dint added any table i wil not get data .i should add same tables which i specified in select statment and should i drag feilds which i want? i want clarity what ur saying plz tell