public PersonalRelationData getPersonalRelation(string personal_relation_code) { PersonalRelationData PersonalRelation_data = new PersonalRelationData(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From Relation Where Relation_Code='" + personal_relation_code + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { PersonalRelation_data.PersonalRelation_Code = rowData["RELATION_CODE"].ToString(); PersonalRelation_data.PersonalRelation_Thai = rowData["RELATION_THAI"].ToString(); PersonalRelation_data.PersonalRelation_Eng = rowData["RELATION_ENG"].ToString(); } return(PersonalRelation_data); }
public List <PersonalRelationData> getPersonalRelation() { List <PersonalRelationData> PersonalRelation_data = new List <PersonalRelationData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From Relation Order By Relation_Code"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { PersonalRelationData Relation = new PersonalRelationData(); Relation.PersonalRelation_Code = rowData["RELATION_CODE"].ToString(); Relation.PersonalRelation_Thai = rowData["RELATION_THAI"].ToString(); Relation.PersonalRelation_Eng = rowData["RELATION_ENG"].ToString(); PersonalRelation_data.Add(Relation); } return(PersonalRelation_data); }