Crystal report returns no result data

And here is my code:

 string brdok = this.textBox2.Text;
            SqlConnection connection = null;
           
            ConnectionStringSettings settings =
                ConfigurationManager.ConnectionStrings["Blagajna_JSPTURS.Properties.Settings.blagajna_jspturs"];
            if (settings != null)
            {
                string ConnectionString = settings.ConnectionString;
                connection = new SqlConnection(ConnectionString);
            }
          

             alatkiDAC dac = new alatkiDAC();
            SqlCommand command=new SqlCommand();
                command.Connection = dac.GetConnection();
                string comstring1 = "SELECT Valuta.id, Valuta.Valuta, Vidpodatok.idpod, Vidpodatok.vp,blagajna_jspturs.brdok,blagajna_jspturs.data, blagajna_jspturs.datafra,blagajna_jspturs.vp,blagajna_jspturs.Imeprezime, blagajna_jspturs.Iznos, blagajna_jspturs.valutaid, blagajna_jspturs.valutakurs, blagajna_jspturs.iznosden, blagajna_jspturs.br_fra, blagajna_jspturs.br_fra, blagajna_jspturs.br_patna_ska, blagajna_jspturs.osnov, blagajna_jspturs.br_kas_izvod from Valuta, Vidpodatok, blagajna_jspturs where blagajna_jspturs.brdok=@brdok";
            command.CommandText = comstring1;
            command.Parameters.AddWithValue("@brdok", textBox2.Text);

                BlagajnaDataSet dataSet2=new BlagajnaDataSet();
                              
                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
              
                dataSet2.Clear();

                sqlDataAdapter.SelectCommand = command;
                sqlDataAdapter.Fill(dataSet2);
               

            ReportDocument Rpt = new ReportDocument();
            Rpt.Load(@"the path \CrystalReport7.rpt");

            Rpt.SetDataSource(dataSet2);
            crystalReportViewer2.ReportSource = Rpt;

            Rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait;
            crystalReportViewer2.Refresh();

Thanks Murali, I changed the CPU but still the problem exists:(. I still can not retrieve data from the database in the crystal report. It gives only the first row with the head row, but no data after that. All the fields in the report are empty.

Try to change the target of your application and try it once.


To set the Target CPU property
With a project selected in Solution Explorer, on the Project menu, click Properties.

Click the Compile tab.

Click the Advanced Compile Options button to open the Advanced Compiler Settings dialog box.

Choose a CPU type from the Target CPU drop-down list, and then click OK.

Refer : http://stackoverflow.com/questions/3244464/how-to-solve-warning-referenced-assembly-targets-a-different-processor-than-the

Hope this helps you.