使用C＃编码在窗口应用程序中使用RDLC进行报告 [英] Report using RDLC in window application using C# coding

问题描述

我想使用C＃在Window应用程序中使用RDLC开发报告。





请有人附上样品编码。







谢谢，

Hi,
I want to develop a Report using RDLC in Window Application using C#.


Please anyone attach sample coding .



Thanks,

推荐答案

试试这些文章

RDLC报告

使用C＃报告

获取完整代码：带有源代码的Rdlc [ ^ ]

dataset-report-rdlc [ ^ ]

在运行时将DataSet和Generic * .rdlc报告绑定到ReportViewer [ ^ ]

Get complete code:Rdlc with source code[^]
dataset-report-rdlc[^]
Binding DataSet and Generic *.rdlc Reports to a ReportViewer at Runtime[^]

公共部分类Form1：表格

{

public Form1（）

{

InitializeComponent（）;

}

List< class1> lt = new List< class1>（）;



private void Form1_Load（object sender，EventArgs e）

{



this.reportViewer1.RefreshReport（）;

}



private void button1_Click（对象发送者） ，EventArgs e）

{

SqlConnection cnn = new SqlConnection（server =。; user id = sa; password = 123; database = harish）;

string str =SELECT [ItemStoneID]，[ItemCode]，[StoneWt]，[StoneCarats]，[StonePrice]，[StoneCost]，[StoneID]，[Quantity] FROM [dbo]。[ItemStoneDetails]其中Cast（LastUpdatedAt as date）介于'+ textBox1.Text +'和'+ textBox2.Text +';

SqlDataAdapter da = new SqlDataAdapter（str，cnn）;

long dataRows = 0;

DataTable dt = new DataTable（）;

DataSet ds = new System.Data.DataSet（）;

da.Fill（ds，ItemSt oneDetails）;



dt = ds.Tables [ItemStoneDetails];

dataRows = ds.Tables [ItemStoneDetails]。 Rows.Count - 1;

Class1 stone = new Class1（）;

for（int i = 0;我< = dataRows; i ++）

{

stone.Carat = Convert.ToDouble（ds.Tables [ItemStoneDetails]。Rows [i] .ItemArray.GetValue（3））;

stone.Cost = Convert.ToDouble（ds.Tables [ItemStoneDetails]。Rows [i] .ItemArray.GetValue（5））;

stone.Price = Convert .ToDouble（ds.Tables [ItemStoneDetails]。Rows [i] .ItemArray.GetValue（4））;

stone.StoneWt = Convert.ToDouble（ds.Tables [ItemStoneDetails]。行[i] .ItemArray.GetValue（2））;

stone.Quantity = Convert.ToInt32（ds.Tables [ItemStoneDetails]。Rows [i] .ItemArray.GetValue（7）） ;

stone.Name = ds.Tables [ItemStoneDetails]。Rows [i] .ItemArray.GetValue（1）.ToString（）;

lt.Add（石头）;

}



reportViewer1.LocalReport.ReportEmbeddedResource =Report1.rdlc;





Micro soft.Reporting.WinForms.ReportDataSource（DataSet1，lt）;



reportViewer1.LocalReport.ReportEmbeddedResource =Report1.rdlc;

Microsoft.Reporting.WinForms.ReportDataSource datasource = new Microsoft.Reporting.WinForms.ReportDataSource（DataSet1，lt）;

Microsoft.Reporting.WinForms.ReportDataSource（DataSet2，dsBNCReportImagesData.Tables [ 0]）;

reportViewer1.LocalReport.DataSources.Clear（）;

reportViewer1.LocalReport.DataSources.Add（datasource）;

< br $> b $ b

}

}

public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
List<class1> lt = new List<class1>();

private void Form1_Load(object sender, EventArgs e)
{

this.reportViewer1.RefreshReport();
}

private void button1_Click(object sender, EventArgs e)
{
SqlConnection cnn = new SqlConnection("server=.;user id=sa;password=123;database=harish");
string str = "SELECT [ItemStoneID],[ItemCode],[StoneWt],[StoneCarats],[StonePrice],[StoneCost],[StoneID],[Quantity] FROM [dbo].[ItemStoneDetails] where Cast(LastUpdatedAt as date) between'" + textBox1.Text + "' and '" + textBox2.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(str, cnn);
long dataRows = 0;
DataTable dt = new DataTable();
DataSet ds = new System.Data.DataSet();
da.Fill(ds, "ItemStoneDetails");

dt = ds.Tables["ItemStoneDetails"];
dataRows = ds.Tables["ItemStoneDetails"].Rows.Count - 1;
Class1 stone = new Class1();
for (int i = 0; i <= dataRows; i++)
{
stone.Carat = Convert.ToDouble(ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(3));
stone.Cost = Convert.ToDouble(ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(5));
stone.Price = Convert.ToDouble(ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(4));
stone.StoneWt = Convert.ToDouble(ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(2));
stone.Quantity = Convert.ToInt32(ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(7));
stone.Name = ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(1).ToString();
lt.Add(stone);
}

reportViewer1.LocalReport.ReportEmbeddedResource = "Report1.rdlc";


Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", lt);

reportViewer1.LocalReport.ReportEmbeddedResource = "Report1.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource datasource = new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", lt);
Microsoft.Reporting.WinForms.ReportDataSource("DataSet2", dsBNCReportImagesData.Tables[0]);
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.DataSources.Add(datasource);


}
}

这篇关于使用C＃编码在窗口应用程序中使用RDLC进行报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！