none
Please I need help in Resolving a Crystal Reporting Error in visual Studio c# using sqlexpress 2017. RRS feed

  • Question

  • Failed to load database information. Error in File temp_a5038319-c88d-44d7-848b-70813999b829 {1DD999F6-282A-4783-9D53-184BC0A4E344}.rpt: Failed to load database information. The error occurred at rpt.SetDataSource(ds).

    Here is the code:

    private void button1_Click(object sender, EventArgs e)
    {
        try
        {
            con = new SqlConnection(cs.DBconn2);
            con.Open();
    
            cmd = new SqlCommand("SELECT * FROM Student WHERE AdmissionNo = 56777", con);
    
            adp = new SqlDataAdapter(cmd);
            DataTable table = new DataTable();
    
            ds = new DataSet();
            adp.Fill(table);
            con.Close();
    
            ds.Tables.Add(table);
         
            CrystalReport1 rpt = new CrystalReport1();
    
            if (ds.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("No data Found");
                return;
            }
    
            rpt.SetDataSource(ds);
    
            frm.crystalReportViewer1.ReportSource = rpt;
            frm.ShowDialog();
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
        }
    }



    Friday, February 9, 2018 12:07 AM

All replies

  • Hi 2ndeh,

    Welcome to the MSDN forum.

    Refer to your description, this issue is about Crystal Report development. Since our forum is to discuss the VS IDE, please redirect to this appropriate forum: https://www.sap.com/community/tag.html?id=01200615320800001270 for a more professional support, thank you for your understanding.

    If you have any other issues about the VS IDE in the future, please feel free to let us know.

    Best regards,

    Sara


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, February 9, 2018 7:22 AM
  • ok.

    Thank u.

    Saturday, February 10, 2018 5:48 AM