C# .NET - Dynamic Crystal Report in Asp.net With C#

Hi guy's... Can anyone say how to generate dynamic Crystal report. According to Given Sqlcommand eg: (select field1 from tablename)... Tks in Adv G.Sam...

 Firstly write the query you need to display:

Sqlcommand cmd;

sqlDataAdpater adap;

Dataset ds=new Dataset();

cmd=new SqlCommand("Select feidname from tablename,con);

adap = new SqlDataAdapter();

adap.Fill(ds,"table");

Crystalreport1 cr=new crystalReport();

cr.SetDataSource(ds.Tables[0]);

CrystalReportViewer1.ReportSource=cr;

            cnn.Open();
            sql = procesSQL();
            SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
            DataSet1 ds = new DataSet1();
            dscmd.Fill(ds, "");
            objRpt.SetDataSource(ds.Tables[1]);
            crystalReportViewer1.ReportSource = objRpt;
            crystalReportViewer1.Refresh();

http://csharp.net-informations.com/crystal-reports/csharp-dynamic-crystal-reports.htm

bb.