Xtrareport如何绑定dataSet数据
1、report.datasource直接放一个dataset或datatable
此种方法在代码里实现，直接为report赋数据源
特点：
-无须生成xml
-生成模板文件.repx中不包含表结构信息
-可用于特定表的使用，一旦将repx复制到其他地方，则无法根据repx生成表结构
2、XReport 代码如下 作用就是绑定一下数据
XREPORT代码在设计器界面右键显示
3、public XtraReport1(DataTable dt) { InitializeComponent(); this.DataSource = dt; //这里面的Text是xrtable的属性 区分大小写
4、this.xrTableCell1.DataBindings.Add("Text",dt,"bid"); this.xrTableCell2.DataBindings.Add("Text", dt, "bname"); this.xrTableCell3.DataBindings.Add("Text", dt, "shuoming"); this.xrTableCell4.Text = "编号"; this.xrTableCell5.Text = "名称"; this.xrTableCell6.Text = "备注";
5、private void button1_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); string constr = "server=192.168.100.222;user=sa;pwd=p@ssw1rd;database=pwd1";
6、SqlConnection con = new SqlConnection(constr); try { con.Open(); SqlCommand com = new SqlCommand("select bid,bname,shuoming from book",con); SqlDataAdapter dpt = new SqlDataAdapter(com);
7、dpt.Fill(dt); XtraReport1 report = new XtraReport1(dt); report.Landscape = true; documentViewer1.DocumentSource = report; report.CreateDocument(); } catch (Exception) { throw; } }
