SqlDataAdapter da = new SqlDataAdapter("select * from out_gatematerial where gatepass_no='" + passno.Trim() + "'", con);
            DataSet ds = new DataSet();
            da.Fill(ds, "table");
            con.Close();
            Gate_Material_out cry = new Gate_Material_out();
            cry.SetDatabaseLogon("asp_apps", "asp_apps", "SUNARKSBS", "MM", true);
            cry.RecordSelectionFormula = "{out_gatematerial.gatepass_no}=" + passno.Trim() + "";
            cry.SetDataSource(ds.Tables[0]);
            crys_viewer.ReportSource = cry;
            crys_viewer.DataBind();

using System.Data;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;
namespace winSampleCSharp
{
    public partial class Form1 : Form
    {
        //Create table emp(eno int,empname varchar(50),sal bigint) 
        //insert some records too in that table
        SqlConnection sqlcon = new SqlConnection(@"Server=RAVI-PC\SQLEXPRESS;database=test1;uid=ravindran;pwd=srirangam;");
        SqlCommand sqlcmd;
        SqlDataAdapter da;
        DataTable dt = new DataTable();  
        DataSet ds = new DataSet();     
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            sqlcon.Open();
            sqlcmd = new SqlCommand("select * from emp", sqlcon);
            da = new SqlDataAdapter(sqlcmd);
            da.Fill(ds);
            dt = ds.Tables[0];
            CrystalReport1 objReport = new CrystalReport1();
            objReport.SetDataSource(dt);
            crystalReportViewer1.ReportSource = objReport;
            sqlcon.Close();
        }     
    }
}