SQL Query from VB .NET to FR .NET
how to transform the code below c # to vb
using FastReport.Data;
report1.Load (...);
/ / do it after loading the report, before running it
/ / find the table alias by ITS
TableDataSource report1.GetDataSource table = ("MyTable") the TableDataSource;
table.SelectCommand = "new SQL text";
report1.Show ();
Thank you
using FastReport.Data;
report1.Load (...);
/ / do it after loading the report, before running it
/ / find the table alias by ITS
TableDataSource report1.GetDataSource table = ("MyTable") the TableDataSource;
table.SelectCommand = "new SQL text";
report1.Show ();
Thank you
Comments
first you declare a tabledatasource variable type by doing: dim table as new tabledatasource
Second : table = ctype(report1.GetDataSource("table"),tabledatasource)
and table.selectCommand is there for type the Sql command that you want to run.
My problem is how can I add parameters to that sqlCommand like we do with oledbcommand?