Irwsoft Data Framework

Select Table Function
Brief Information
EditionsProfessional and Ultimate
ProvidersSqlClient and Oracle.
DataschemaTable-Function
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);
select.Columns.Add(tf.PersonId);
select.Columns.Add(tf.FirstName);

// 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.