using System;

using System.Windows.Forms;

using CrystalDecisions.CrystalReports.Engine;

using CrystalDecisions.Shared;



namespace WindowsApplication1

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }



        private void button1_Click(object sender, EventArgs e)

        {

            ReportDocument cryRpt = new ReportDocument();

            cryRpt.Load("PUT CRYSTAL REPORT PATH HERE\CrystalReport1.rpt");



            TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();

            TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();

            ConnectionInfo crConnectionInfo = new ConnectionInfo();

            Tables CrTables;



            ParameterFieldDefinitions crParameterFieldDefinitions ;

            ParameterFieldDefinition crParameterFieldDefinition ;

            ParameterValues crParameterValues = new ParameterValues();

            ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();



            crParameterDiscreteValue.Value = textBox1.Text;

            crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;

            crParameterFieldDefinition = crParameterFieldDefinitions["fromDate"];

            crParameterValues = crParameterFieldDefinition.CurrentValues;



            crParameterValues.Clear();

            crParameterValues.Add(crParameterDiscreteValue);

            crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);



            crParameterDiscreteValue.Value = textBox2.Text;

            crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;

            crParameterFieldDefinition = crParameterFieldDefinitions["toDate"];

            crParameterValues = crParameterFieldDefinition.CurrentValues;



            crParameterValues.Add(crParameterDiscreteValue);

            crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);



            crConnectionInfo.ServerName = "YOUR SERVERNAME";

            crConnectionInfo.DatabaseName = "DATABASE NAME";

            crConnectionInfo.UserID = "USERID";

            crConnectionInfo.Password = "PASSWORD";



            CrTables = cryRpt.Database.Tables;

            foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)

            {

                crtableLogoninfo = CrTable.LogOnInfo;

                crtableLogoninfo.ConnectionInfo = crConnectionInfo;

                CrTable.ApplyLogOnInfo(crtableLogoninfo);

            }



            crystalReportViewer1.ReportSource = cryRpt;

            crystalReportViewer1.Refresh(); 

        }

   }

}