crystal report

[Sherin]

How can we dynamically bind dataset in crystal report at run time plz help.

[Poornima Joy Balan]

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

[Administrator]

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

[Administrator]

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