Hi,
I just Want to create a RDLC reports in the Windows form But I am not getting Please help me I am Using This Code Data is getting to reportviewer but it is not shown in RDLC. plese solve this problem.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication
{
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);
}
}
}