using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;
namespace CRTest
{
    public partial class Form1 : Form
    {
        CrystalReport1 cr;
        public Form1()
        {
            InitializeComponent();
            cr = new CrystalReport1();
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            TableLogOnInfo crLogOnInfo = new TableLogOnInfo();
            ConnectionInfo crConnInfo = new ConnectionInfo();
            foreach (Table tbl in cr.Database.Tables)
            {
                crConnInfo.ServerName = "myserver";
                crConnInfo.DatabaseName = "mydbname";
                crConnInfo.UserID = "sa";
                crConnInfo.Password = "somepass";
                crLogOnInfo = tbl.LogOnInfo;
                crLogOnInfo.ConnectionInfo = crConnInfo;
                tbl.ApplyLogOnInfo(crLogOnInfo);
            }
            crystalReportViewer1.ReportSource = cr;
        }
    }
}