CrystalReport db Connection 연결과 파라미터 넘기기

//TableLogOnInfo객체생성

    CrystalDecisions.Shared.TableLogOnInfo cryLogonInfo = new CrystalDecisions.Shared.TableLogOnInfo();

   

    //계정정보설정

    cryLogonInfo.ConnectionInfo.ServerName = "db";

    cryLogonInfo.ConnectionInfo.Password = "1234";

    cryLogonInfo.ConnectionInfo.UserID = "sa";

    cryLogonInfo.ConnectionInfo.DatabaseName = "pubs";

   

    //계정추가

    CrystalReportViewer1.LogOnInfo.Add(cryLogonInfo);

    //로그인창 false 설정

    CrystalReportViewer1.EnableDatabaseLogonPrompt = false;

   //피라메터 설정
   CrystalReportSource1.Report.Parameters.Clear();
   CrystalDecisions.Web.Parameter param = new CrystalDecisions.Web.Parameter();
   param.Name = "@order_id";
   param.DefaultValue = strOrderID;
   //파라메터 추가
   CrystalReportSource1.Report.Parameters.Add(param);