i need some help in c# in order to display the attrtibute that is not in the same table..
i have a table COMPANY and CODE..in company table, i have attribute called CmpStatusCode that just display in int (input by ddl which is selectedvalue ex: 1,2,3)..but in CODE table, there are definition for that selectedvalue (ex: 1=active , 2=not active).. what should i do to display the value of "active" by refering to 1,2,3? i'm using usp..
i'm using datagrid to display the data..
<asp:TemplateColumn HeaderText="Status" HeaderStyle-Width="5%" SortExpression="CmpStatusCode" visible="true"> <ItemTemplate> <center><asp:Label Id="lblCmpStatusCode" width="50px" Text='<%# DataBinder.Eval(Container, "DataItem.CmpStatusCode") %>' Runat="server" /></center> </ItemTemplate> </asp:TemplateColumn>
this is my usp
begin SELECT CmpID, CmpCode, CmpName, CmpEffDate, CmpExpDate, CmpStatusCode from ms_Company end
now, when the page is build, value for CmpStatusCode will be in 1,2,3.. i could not find the way to display the value for 1,2,3 that need to be refer in table code.. in Code table, the attribute that explain the CmpStatusCode is CodCode..
anybody please help me.. sorry for the bad english.. i dont know how to explain it:sad:
Edited by new SE: n/a