CODEWITHSUNDEEP
c#asp.netgridviewcrystal-reports
pramod niralakeri
pramod niralakeri

Reputation: 65

datagridview to crystal report in asp.net website

my complete code button click event where i save to sample.xml for scheme...i use this schema for crystal report and then bind data as u suggested

protected void Button1_Click1(object sender, EventArgs e)
{
    DataTable dt = new DataTable();
    dt.Columns.Add("BLOCK NO ", typeof(string));
    dt.Columns.Add("DATE ", typeof(string));
    dt.Columns.Add("SESSION ", typeof(string));
    dt.Columns.Add("USN ", typeof(string));
    dt.Columns.Add("SUBJECT CODE ", typeof(string));
    dt.Columns.Add("SEAT/BENCH ", typeof(string));
    dt.Columns.Add("SUPERVISOR ", typeof(string));

    SqlDataAdapter adptdate = new SqlDataAdapter("select * from blocks_allocation order by date,session,block,bench", con);
    DataSet DSall = new DataSet();
    adptdate.Fill(DSall);

    for (int j = 0; j < DSall.Tables[0].Rows.Count; j++)
    {
        DataRow DR = DSall.Tables[0].Rows[j];
        dt.Rows.Add(DR.ItemArray.GetValue(0).ToString(), DR.ItemArray.GetValue(3).ToString(), DR.ItemArray.GetValue(4).ToString(), DR.ItemArray.GetValue(2).ToString(), DR.ItemArray.GetValue(5).ToString(), DR.ItemArray.GetValue(6).ToString(), DR.ItemArray.GetValue(1).ToString());

    }
    DataSet ds = new DataSet();
    ds.Tables.Add(dt);
    ds.WriteXmlSchema("F:\\pramodblde\\Bin\\Sample.xml");


    GridView1.DataSource = dt;
    GridView1.DataBind();

    ReportDocument rptDoc = new ReportDocument();
    rptDoc.Load(Server.MapPath("blockreport.rpt"));//rpt file path

    rptDoc.SetDataSource(ds);
    CrystalReportViewer1.ReportSource = rptDoc;
}

Upvotes: 1

Views: 1323

Answers (1)

Angus Chung
Angus Chung

Reputation: 1587

You can use ReportDocument to bind your data to Crystal Report.

GridView1.DataSource = dt;
GridView1.DataBind();

ReportDocument rptDoc = new ReportDocument();
rptDoc.Load(Server.MapPath("../blockreport.rpt"));//rpt file path

DataSet ds = new DataSet();
ds.Tables.Add(dt);//your datatable

rptDoc.SetDataSource(ds);
CrystalReportViewer1.ReportSource = rptDoc;

Upvotes: 1

Related Questions