public String[,] getAll(String khanaid)
{
String s = "SELECT member_no, mother_no, name, relation_no, age, dob, sex_no, marital_no, marital_year, education_no, occupation_no, weight, height, parity FROM member WHERE khana_id = '" + khanaid + "'";
String[,] ret = DB.SelectColumns(s, "member");
return(ret);
}
public String[] getAll(String khanaid)
{
int i = 0;
String[] ret = new String [30];
String s = "SELECT roof_no, wall_no, floor_no, house_price, land_amount, land_price, cow, goat, hen, fruit_tree, vegitable_land, month_covered, bed, chair, radio, tv, tubewell, milky_cow, milky_goat, day_labourer, labour_days, water_source_no, latrine, evaluation_no FROM khana where khana_id='" + khanaid + "'";
String [,] a = DB.SelectColumns(s, "khana");
while (i < 30)
{
ret[i] = a[0, i];
i++;
}
return(ret);
}