C#

void report()
   {
   int fact;
   if (!int.TryParse(textBox4.text, out fact))
      {
      ... report input problem to user ...
      return;
      }
   // fact now contains a valid integer.

SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood'

SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;--'

SELECT * FROM MyTable WHERE StreetAddress = 'x';

DROP TABLE MyTable;

--'

Quote:

As far as your actual question goes, we can't help based on the code you show: it doesn't display the report at all, just set up some conditions for it to be displayed or printed. You need to look elsewhere in your code to find out exactly what happens from that point.

Quote:

As far as your actual question goes, we can't help based on the code you show: it doesn't display the report at all, just set up some conditions for it to be displayed or printed. You need to look elsewhere in your code to find out exactly what happens from that point.

cryRpt.PrintToPrinter(1, true, 1, 1);

c2.SetDataSource(dt);
crystalReportViewer1.ReportSource = c2;
c2.SetDatabaseLogon("sa", "789456");

dt.Load(dtr);
               FactCons c2 = new FactCons();//this is my crystal.rpt: means crystalreport
               c2.SetDataSource(dt);
               crystalReportViewer1.ReportSource = c2;
               c2.SetDatabaseLogon("sa", "123456");

OriginalGriff wrote:

I genuinely think he has no idea what he is doing

private void butt_prnt_Click(object sender, EventArgs e)
      {
          report();//your question
      }
      void report()
      {
          cnx = new SqlConnection(db.RXcon);
          try
          {
              cnx.Open();
      string cg=" SELECT * from Consultation where NumFact=" + @Convert.ToInt32(textBox4.Text);
              commd2 = new SqlCommand(cg);
              commd2.Connection = cnx;
              DataSet dts = new DataSet();
              DataTable dt = new DataTable();
              dtr = commd2.ExecuteReader();
              dt.Load(dtr);
              FactCons c2 = new FactCons();
              c2.SetDataSource(dt);
              crystalReportViewer1.ReportSource = c2;
              c2.SetDatabaseLogon("sa", "789654");
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.Message);
          }
          cnx.Close();
      }

crystalReportViewer1.ReportSource = c2;

c2.PrintToPrinter(1, true, 0, 0)

c2.SetDatabaseLogon("sa", "789654");

RobF_83 wrote:

is the line that actually loads the report into the report control.
You need to replace that with this:

c2.PrintToPrinter(1, true, 0, 0)

You should also place it AFTER

c2.SetDatabaseLogon("sa", "789654");

void report()
       {
           cnx = new SqlConnection(db.RXcon);
          try
           {
               cnx.Open();
        string cg=" SELECT * from Consultation where NumFact=" + @Convert.ToInt32(textBox4.Text);
               commd2 = new SqlCommand(cg);
               commd2.Connection = cnx;
               DataSet dts = new DataSet();
               DataTable dt = new DataTable();
               dtr = commd2.ExecuteReader();
               dt.Load(dtr);
               FactCons c2 = new FactCons();
               c2.SetDataSource(dt);
               crystalReportViewer1.ReportSource = c2;
               c2.SetDatabaseLogon("sa", "765432");
               c2.PrintToPrinter(1, true,0, 0);// i just add this and it works correctly

           }
           catch (Exception ex)
           {
              MessageBox.Show(ex.Message);
           }
           cnx.Close();
       }