Selected Data from DataGridView display in RDLC Report

Hemal Joshi

Hello,

I am generating one form where i have two text boxes, two labels, and button Show now when i enter values in both text box and click on Show button data is displayed in dataGridView now when i want to click Generate Button it will only display selected data from dataGridView to the RDLC report viewer help me for that.

Run Time:

Report:

Code:

private void btnShow_Click(object sender, EventArgs e)

{

if (String.IsNullOrEmpty(textBox1.Text.Trim()))

{

MessageBox.Show("Plese Enter Value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

return;

}

else

{

con.Open();

SqlCommand cmd = new SqlCommand("select * from MMMEMBER where MNO between " + Convert.ToInt32(textBox1.Text.Trim()) + " and " + Convert.ToInt32(textBox2.Text.Trim()), con);

cmd.CommandType = CommandType.Text;

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

da.Fill(dt);

dataGridView1.AutoGenerateColumns = false;

dataGridView1.ColumnCount = 9;

//Add Columns

dataGridView1.Columns[0].Name = "MNO";

dataGridView1.Columns[0].HeaderText = "MNO";

dataGridView1.Columns[0].DataPropertyName = "MNO";

dataGridView1.Columns[1].Name = "MNAME";

dataGridView1.Columns[1].HeaderText = "MNAME";

dataGridView1.Columns[1].DataPropertyName = "MNAME";

dataGridView1.Columns[2].Name = "MNAME1";

dataGridView1.Columns[2].HeaderText = "MNAME1";

dataGridView1.Columns[2].DataPropertyName = "MNAME1";

dataGridView1.Columns[3].Name = "NOMINY";

dataGridView1.Columns[3].HeaderText = "NOMINY";

dataGridView1.Columns[3].DataPropertyName = "NOMINY";

dataGridView1.Columns[4].Name = "ADD1";

dataGridView1.Columns[4].HeaderText = "ADD1";

dataGridView1.Columns[4].DataPropertyName = "ADD1";

dataGridView1.Columns[5].Name = "CITY";

dataGridView1.Columns[5].HeaderText = "CITY";

dataGridView1.Columns[5].DataPropertyName = "CITY";

dataGridView1.Columns[6].Name = "OP_DT";

dataGridView1.Columns[6].HeaderText = "OP_DT";

dataGridView1.Columns[6].DataPropertyName = "OP_DT";

dataGridView1.Columns[7].Name = "PHONE1";

dataGridView1.Columns[7].HeaderText = "PHONE1";

dataGridView1.Columns[7].DataPropertyName = "PHONE1";

dataGridView1.Columns[8].Name = "CU_SH_AMT";

dataGridView1.Columns[8].HeaderText = "CU_SH_AMT";

dataGridView1.Columns[8].DataPropertyName = "CU_SH_AMT";

dataGridView1.DataSource = dt;

con.Close();

}

DataGridViewCheckBoxColumn checkBoxColumn = new DataGridViewCheckBoxColumn();

checkBoxColumn.HeaderText = "";

checkBoxColumn.Width = 30;

checkBoxColumn.Name = "checkBoxColumn";

dataGridView1.Columns.Insert(0, checkBoxColumn);

List selectedRows = (from row in dataGridView1.Rows.Cast()

where Convert.ToBoolean(row.Cells["checkBoxColumn"].Value) == true

select row).ToList();

SampleReport sr = new SampleReport(selectedRows);

//sr.ShowDialog();

}

private void btnGenerate_Click(object sender, EventArgs e)

{

new SampleReport().Show();

}

Thanks

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta8y ago
@Hemal

Be assured of what technology are you using with. In your question, snapshot depicts a windows application, however you are now changing your technology to ASP.Net.

However, it is not possible to do the whole code for you.

Fetching the rows from the database with dataGridView1.AutoGenerateColumns = true;

If you required 5 columns then its better to fetch only 5 columns instead of all
private void btnShow_Click(object sender, EventArgs e)

        {

            if (String.IsNullOrEmpty(textBox1.Text.Trim()))

            {

                MessageBox.Show("Plese Enter Value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

                return;

            }

            else

            {

                dataGridView1.AutoGenerateColumns = true;

                con.Open();

                SqlCommand cmd = new SqlCommand("select * from MMMEMBER where MNO between " + Convert.ToInt32(textBox1.Text.Trim()) + " and " + Convert.ToInt32(textBox2.Text.Trim()), con);

                cmd.CommandType = CommandType.Text;

                SqlDataAdapter da = new SqlDataAdapter(cmd);

                DataTable dt = new DataTable();

                da.Fill(dt);

                dataGridView1.DataSource = dt;

                con.Close();



                // to add checkboxes to your gridview, you can simply add boolean type column to your datatable

                dt.Columns.Add("CheckBoxColumn", typeof(bool));



                //setting it to the first index

                dt.Columns["CheckBoxColumn"].SetOrdinal(0);

            }

}

2. Fetching the selected rows
var rows = dt.Select("CheckBoxColumn= true");

// now you got all checked rows in rows variable

// do your rest stuff with report
0
Hemal Joshi8y ago
Hello Amit,

I am the beginner in ASP.NET in my understanding of your 1st point you will say I used only required column as shown my code in select query. And after the 1st point, I didn't understand anything in code so can you describe your solution as you give your point. Then it will be helpful for me.

Thanks,
Hemal
+1
Amit Gupta8y ago
Have you tried implementing my points? Where did you find difficulty in understanding.
+1
Hemal Joshi8y ago
Hello Manav,

Regarding your above suggestion, I have tried a lot but I didn't remove the errors on those errors can help me to resolve that as soon as possible.

Thanks
+2
Hemal Joshi8y ago
Hello Amit,

Can you explain me with the code of mine then i understand better

Replay as soon as possible with code brother.
+2
Manav Pandya8y ago
hello hemal

Please follow the article :

http://www.aspforums.net/Threads/166903/Display-selected-DataGridView-row-in-RDLC-report-using-C-and-VBNet-in-Windows-Forms-Application/

https://www.aspsnippets.com/Articles/RDLC-Report-in-Windows-Forms-WinForms-Application-using-C-and-VBNet.aspx

Thanks
+1
Amit Gupta8y ago
Hey

Instead of complicating the things, it can be done in a optimized way.

1. Use the required column when building query.

2. Set the Autogenerated column to true instead of recreating the whole thing.

3. Checkbox can be added when you add a boolean type of column in your datatable, so that it can fetch data according to user selection.

4. Fetch the checked rows from the database.

For desiging rdlc

1. Design your report as usual from the database.

Whrn all done, pass reportDataSource to your rdlc to have the final output.

Good Luck
+2
Hemal Joshi8y ago
Hello Sagar I have already used that for my application but it will raise an error in Sample Report.rdlc file.

Report File:
public SampleReport(List selectedRows)
{
// TODO: Complete member initialization
//this.selectedRows = selectedRows;
DataTable dt = new DataTable("DataTable1");
dt.Columns.AddRange(new DataColumn[3] {
new DataColumn("Member_No", typeof(string)), new DataColumn("Member_Name", typeof(string)), new DataColumn("Name", typeof(string)) });
foreach (DataGridViewRow row in selectedRows)
{
dt.Rows.Add(row.Cells["Member_No"].Value, row.Cells["Member_Name"].Value, row.Cells["Name"].Value);
}
WorkingMembers wm = new WorkingMembers();
wm.Merge(dt);
ReportDataSource datasource = new ReportDataSource("MMMEMBER", wm.Tables[0]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(datasource);
this.reportViewer1.RefreshReport();
}
private void SampleReport_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'SampleDataset.MMMEMBER' table. You can move, or remove it, as needed.
this.MMMEMBERTableAdapter.Fill(this.SampleDataset.MMMEMBER);
this.reportViewer1.RefreshReport();
}

Error:
+2
Sagar Pandurang Kap8y ago
Hi,
Refer below link :-

http://www.aspforums.net/Threads/166903/Display-selected-DataGridView-row-in-RDLC-report-using-C-and-VBNet-in-Windows-Forms-Application/

it might helps..
+2