crystal report

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

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

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

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