Sending DataGridview Date to Fastreport.net in C#

Comments

• ipong

  April 2020

  show the code...
• Mahnazd

  April 2020

  i have a datagridview in my program and i want to display the information of that in Data Section in my report

  My Code in C#:

        //******* Create Data Table And Fill With Data From Datagrid view *******************

        DataTable dtPrint = new DataTable();

        dtPrint.Columns.Add("StockName");

        dtPrint.Columns.Add("Weight");

        dtPrint.Columns.Add("Amount");

        dtPrint.Columns.Add("Price");

        foreach(DataGridViewRow item in dataGridView1.Rows)

        {

          dtPrint.Rows.Add(

             item.Cells[1].Value.ToString()

            ,item.Cells[2].Value.ToString()

            ,item.Cells[3].Value.ToString()

            ,item.Cells[4].Value.ToString()

            );

        }

        //***************************Set Fast Report Parameter************************************

        report1.Load("Untitled.frx");

        report1.SetParameterValue("timePara", TimeLabel.Text);

        report1.SetParameterValue("DatePara", DateLabel.Text);

        report1.SetParameterValue("NumPara", NumLabel.Text);

        report1.SetParameterValue("NamePara", NameTextBox.Text);

        report1.SetParameterValue("DocDatePara", DocDate.Text);

        report1.SetParameterValue("DocNumPara", DocNumTextBox.Text);

        report1.SetParameterValue("TWeightPara", TotalWeightLabel.Text);

        report1.SetParameterValue("TAmountPara", TotalWeightLabel.Text);

        //report1.RegisterData(dtPrint,"DT");

        report1.Prepare();

        report1.ShowPrepared(); 
• ipong

  April 2020

  your code seems right to me, please attach untitled.frx
• Mahnazd

  April 2020

  unfortunately, I could not upload the file here. i emailed it to you.

  My problem is defining a data source without connecting to the database
• ipong

  April 2020

  yes, your problem is how to define datasource, try this:

      report1.Load("Untitled.frx");

        report1.SetParameterValue("timePara", TimeLabel.Text);

        report1.SetParameterValue("DatePara", DateLabel.Text);

        report1.SetParameterValue("NumPara", NumLabel.Text);

        report1.SetParameterValue("NamePara", NameTextBox.Text);

        report1.SetParameterValue("DocDatePara", DocDate.Text);

        report1.SetParameterValue("DocNumPara", DocNumTextBox.Text);

        report1.SetParameterValue("TWeightPara", TotalWeightLabel.Text);

        report1.SetParameterValue("TAmountPara", TotalWeightLabel.Text);

        report1.RegisterData(dtPrint,"DT");

  // open the designer

  report.Design();

  // uncomment below if you already done your report design

        //report1.Prepare();

        //report1.ShowPrepared(); 

  Untitled.zip

  Uploaded Apr 19, 20201.45 KB

  
  
• ipong

  April 2020

  sorry, it should be: report1.Design(); 😀
• Mahnazd

  April 2020

  Wowww

  Thanks, the problem is solved.

  Can you just explain how DT is defined in "Untitled.frx" ?
• ipong

  April 2020

  open untitled.frx with notepad. if you know the data fields, you may add/modify yourself and after adding tabledatasource, you can edit the report without data.

  report.design(); => push data from application to fastreport and open the designer

  
  

    <TableDataSource Name="DT" ReferenceName="DT" DataType="System.Int32" Enabled="true">

     <Column Name="StockName" DataType="System.String"/>

     <Column Name="Weight" DataType="System.String"/>

     <Column Name="Amount" DataType="System.String"/>

     <Column Name="Price" DataType="System.String"/>

    </TableDataSource>

  
  

  note: <tabledatasource> is for datatable/dataset

  <BusinessObjectDataSource> is for businessobject
• Mahnazd

  April 2020

  Thanks ipong