SQL Query from VB .NET to FR .NET

kaiboll

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

Magezi Sagesse

kaiboll wrote: »

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

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?