Reports on Visual Studio... Which one is best and easiest?

Question

Hello:
 
I am trying to decide which report builder/generator is best and easiest for me to use.
 
1) I have tried: Pebbles Report tool and I really like it but its too new and does not have enough options.
 
2) I have tried: Report Builder 3.0 and its OK, but can not get it to work correctly with VS2010. Maybe its something that I am doing incorrectly.
 
3) Crystal Reports 2010. I have been looking where I can download it, but have not found where.
 
4) MS Excel... Its nice... But: How would I  execute the Excel worksheet from my forms.
 
 

Answer 1

Hi you can try this code
private void Form1_Load(object sender, EventArgs e)
{
OleDbConnection connect = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\Users\Anas\Dropbox\C# Projects\2.Database\ClOsODb.accdb; Persist Security Info=False");
connect.Open();
string cmd = "select * from Course Number and Name";
OleDbDataAdapter adapter = new OleDbDataAdapter(new OleDbCommand(strSql, connect));
 DataSet ds = new DataSet();
adapter.Fill(ds);

course_Number_and_NameComboBox.DataSource = ds.Tables[0];
course_Number_and_NameComboBox.DisplayMember = "Course Number and Name";
course_Number_and_NameComboBox.ValueMember = "ID";
connect.Close();
}

Answer 2

But I am using C#, not VB. Sorry I did not mention it in the question.

Answer 3

Hi you can try below code

Dim cn As New OleDbConnection("provider=Provider=Microsoft.ACE.OLEDB.12.0;data source=C:\Users\Anas\Dropbox\C# Projects\2.Database\ClOsODb.accdb")

   Dim da As New OleDbDataAdapter()

   Dim dt As New DataTable()

   Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

      cn.Open()

      da.SelectCommand = New OleDbCommand("select * from [course Number and Name]", cn)

      da.Fill(dt)

 

      ComboBox1.DataSource = dt

      ComboBox1.DisplayMember = "Course Number and Name";

      ComboBox1.ValueMember = "ID";

 

      ' or this way

      ComboBox1.Items.Clear()

      Dim r As DataRow

      For Each r In dt.Rows

         ComboBox1.Items.Add(r(1).ToString)

      Next

      cn.Close()

   End Sub