Irwsoft Data Framework

Select Table Function
Brief Information
EditionsProfessional and Ultimate
ProvidersSqlClient and Oracle.
TopicsSelect Table Function.

This sample will show how to select table-function in common select query in Irwsoft Data Framework.

Example : We want to select GetPersonTable(PersonID) table function
               which will display a record of Person table with included PersonID parameter.

C# code
GetPersonTable tf = new GetPersonTable();
// Set parameter value of GetPersonTable function, which is PersonId = 3
tf.ParamPersonId.Value = 3;

SqlSelectFrom select = new SqlSelectFrom(tf);
// Don’t forget to set connection string !
// NOTE : it is optional if the data-schema class using default connection.

select.ConnectionString = "...";  // [OPTIONAL]

// filter columns to display or display all using this code select.Columns.All(tf);

// Execute the query and return DataView instance
Irwsoft.Data.DataView dv = select.Execute();

Related Topics :

Irwsoft Data Ultimate Edition provides comprehensive features of Irwsoft Data Framework and support from irwsoft.