using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Data; using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { ReportDocument rpt = new ReportDocument(); bday ds = new bday(); DataTable dt = new DataTable(); dt.TableName = "crystal report"; dt = getallorders(); ds.Tables[0].Merge(dt); rpt.Load(Server.MapPath("~/ROKKIE.rpt")); rpt.SetDataSource(ds); CrystalReportViewer1.ReportSource = rpt; } public DataTable getallorders() { SqlConnection con = new SqlConnection(); con.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["KKConnectionString"].ConnectionString; SqlCommand cmd = new SqlCommand(); DataSet ds = null; SqlDataAdapter adapter; try { con.Open(); cmd.CommandText = "select * from jj"; cmd.Connection = con; ds = new DataSet(); adapter = new SqlDataAdapter(cmd); adapter.Fill(ds, "user"); } catch (Exception ex) { throw new Exception(ex.Message); } finally { cmd.Dispose(); con.Close(); } return ds.Tables[0]; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)