using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        BindReport();
    }

    private void BindReport()
    {
        string strProvider = "server=.\\sqlexpress;database=BestChina;uid=bestchina;pwd=supply";
        CrystalReport1 oCR = new CrystalReport1();
        Dataset1 ds = new Dataset1();
        SqlConnection MyConn = new SqlConnection(strProvider);
        MyConn.Open();
        string strSel = "Select * from ProjectStage";
        SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel, MyConn);
        MyAdapter.Fill(ds, "ProjectStage");
        oCR.SetDataSource(ds);
        this.CrystalReportViewer1.ReportSource = oCR;
    }

}