Hi,
string strDBConnection = "Data Source=Localhost;Initial Catalog=Employee;Persist Security Info=True;User ID=sa;Password=1";
string strCommandText = "SELECT * FROM EMP";
SqlConnection SConnection = new SqlConnection(strDBConnection);
SqlCommand cmd = new SqlCommand(strCommandText, SConnection);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(strCommandText, SConnection);
DataSet ds = new DataSet();
sqlDataAdapter.Fill(ds);
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("EmployeeDetail.rpt"));
rd.Refresh();
rd.SetDataSource(ds.Tables[0]);
CrystalReportViewer1.ReportSource = rd;
CrystalReportViewer1.DataBind();
Thanks,
Imdadhusen