Direct database connection

[Sandy Pham]

In addition to using datasets, I need to allow my users to connect directly to the database and see all of the available tables/fields. Can you do this?

SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=Trebuchet;Integrated Security=True;");
conn.Open();
rpt.RegData("Trebuchet", conn); //Trebuchet is the name of my database

If not, I can prompt for a SQL string before I launch your designer. In this case, I need to know what API method(s) to use to set the SQL string.

[Vital]

In addition to using datasets, I need to allow my users to connect directly to the database and

You can connect directly to database from report designer. To create new connection go to report dictionary and
select command "New Database".

see all of the available tables/fields. Can you do this?

At this moment you can't select tables from available. You need write sql query.
In next version we will provide this functionality.

Thank you.