Ima jos nacina. Ja idem preko starog dobrog recordset-a. Doduse ja sam uvek za da se koriste novije stvari u ovom slucaju dataset ali koristim recordset jer se brze podaci ucitavaju pa ako je nekome bitno to evo
tereba samo dadati referencu na neku od ado 2.x library
Code:
ADODB.RecordsetClass rs = new ADODB.RecordsetClass();
string connectionString = "...";
rs.Open("SELECT * FROM SUcenikMaticniPodaci", connectionString, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, 1);
MojReport.SetDataSource(rs);
Mozda ce nekom smetati sto se mesaju COM i .NET ali sta da se radi :)
Postoji jos jedna mogucnost da se konektuje a to je preko CrystalDecisions.Shared.ConnectionInfo klase.
evo primera sa msdn-a
Code:
private void SetConnectionInfo (ReportDocument Report, string table, string server, string database, string user, string password)
{
// Get the ConnectionInfo Object.
TableLogOnInfo logOnInfo = new TableLogOnInfo();
logOnInfo = Report.Database.Tables[table].LogOnInfo;
ConnectionInfo connectionInfo = new ConnectionInfo ();
connectionInfo = logOnInfo.ConnectionInfo;
// Set the Connection parameters.
connectionInfo.DatabaseName = database;
connectionInfo.ServerName = server;
connectionInfo.Password = password;
connectionInfo.UserID = user;
Report.Database.Tables [table].ApplyLogOnInfo(logOnInfo);
}
Nadam se da je pomoglo. Pozdrav