public MaritalData getMarital(String Marital_Code)
{
MaritalData Marital_data = new MaritalData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From MARITAL Where MARITAL_CODE='" + Marital_Code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
Marital_data.Marital_Code = rowData["MARITAL_CODE"].ToString();
Marital_data.Marital_Thai = rowData["MARITAL_THAI"].ToString();
Marital_data.Marital_Eng = rowData["MARITAL_ENG"].ToString();
}
return(Marital_data);
}
public List <MaritalData> getMarital()
{
List <MaritalData> Marital_data = new List <MaritalData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From MARITAL Order By MARITAL_CODE";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
MaritalData Marital = new MaritalData();
Marital.Marital_Code = rowData["MARITAL_CODE"].ToString();
Marital.Marital_Thai = rowData["MARITAL_THAI"].ToString();
Marital.Marital_Eng = rowData["MARITAL_ENG"].ToString();
Marital_data.Add(Marital);
}
return(Marital_data);
}
