Irwsoft NETCore Asp

LookupTable
Brief Information
DescriptionA selection tag-helper for relation tables from one to many.
The child table consume the master table using its single primary key.
FeaturesBind one property for foreign key (single-column only) in child table.
LookupTable tag-helper
LookupTable tag-helper


The INA ASP.net LookupTable tag-helper is input tag-helper for relation tables from one to many. Which generally the child table consumes the master table using its primary key.

Example : Input EmployeeID data of DivisionEmployee table from Person table with LookupTable


C# code for Person table

// 1) Sample code for DivisionEmployee table
public class DivisionEmployee
{
     // 2) The columns of DivisionEmployee table.
     public int DivisionID { get; set;}
     public int EmployeeID { get; set;}  // 2) Input EmployeeID property of DivisionEmployee.
}

// 3) Sample code for Division table
public class DivisionEmployee
{
     public int ID { get; set;}
     public string Name { get; set;}
}

// 4) Sample code for Person table
public class Person
{
     public int ID { get; set;}
     public string FirstName { get; set;}
     public string LastName { get; set;}
     public GenderType Gender { get; set;}
     public DateTime DateOfBirth { get; set;}
     public int Age { get; set;}
     public string Address { get; set;}
     public string City { get; set;}
     public string Country { get; set;}
     public string IdentityCardNo { get; set;}
     public string BioData { get; set;}
     public string PictureUrl { get; set;}
}


ASPX code for LookupTable

// 1) Defines the LookupTable tag-helper
<LookupTable ID="DDT1" SkinStyle="SimpleGrey" DataObject=Model DataFormat="{0}) {1} {2}" Width="300">
     // 2) Defines a propertyto bind inside DataPropertyNames tag
     <DataPropertyName Name="EmployeeID" DataType="Integer" />
     // 3) Defines the columns of Person table
     <DropDownTableColumn Name="ID" DataType="Integer" Key="true" />
     <DropDownTableColumn Name="FirstName" />
     <DropDownTableColumn Name="LastName" />
</LookupTable>


Related Topics :


Irwsoft Data Ultimate Edition 4.0 supports data-schema extension (entity framework, linq to sql, simple class, and etc).