public String getUnionName(int unionno, int thanano)
{
String s = "SELECT union_name FROM [union],thana where [union].thana_no=thana.thana_no and [union].thana_no=" + thanano + " and [union].union_no=" + unionno + "";
unionname = DB.SelectSrting(s);
return(unionname);
}
public String getThanaName(int thanano, int districtno)
{
String s = "SELECT thana_name FROM thana,district where thana.district_no=district.district_no and thana.district_no=" + districtno + " and thana.thana_no=" + thanano + "";
thananame = DB.SelectSrting(s);
return(thananame);
}
public String getPassword(String userId)
{
String ret = null;
String s = "select password from [user] where user_id='" + userId + "'";
//MessageBox.Show(s);
ret = db.SelectSrting(s);
return(ret);
}
public String getEvaluation(int evaluationno)
{
String s = "SELECT evaluation FROM evaluation WHERE evaluation_no =" + evaluationno + "";
evaluation = DB.SelectSrting(s);
return(evaluation);
}
public String getRelation(int relationno)
{
String s = "SELECT relation FROM relation WHERE relation_no =" + relationno + "";
relation = DB.SelectSrting(s);
return(relation);
}
public String getUserId(String khanaid)
{
String s = "select user_id from khana where khana_id='" + khanaid + "'";
String userid = DB.SelectSrting(s);
return(userid);
}
public String getDistrictName(int districtno)
{
String s = "SELECT district_name FROM district WHERE district_no = " + districtno + "";
distrintname = DB.SelectSrting(s);
return(distrintname);
}
public String getFloor(int floorno)
{
String s = "SELECT floor FROM floor WHERE floor_no =" + floorno + "";
floor = DB.SelectSrting(s);
return(floor);
}
public String getRoof(int roofno)
{
String s = "SELECT roof FROM roof WHERE roof_no =" + roofno + "";
roof = DB.SelectSrting(s);
return(roof);
}
public String getOccupation(int occupationno)
{
String s = "SELECT occupation FROM occupation WHERE occupation_no =" + occupationno + "";
occupation = DB.SelectSrting(s);
return(occupation);
}
public String getEducation(int educationno)
{
String s = "SELECT education FROM education WHERE education_no =" + educationno + "";
education = DB.SelectSrting(s);
return(education);
}
public String getMaritalStatus(int maritalstatusno)
{
String s = "SELECT status FROM marital_status WHERE marital_no =" + maritalstatusno + "";
maritalstatus = DB.SelectSrting(s);
return(maritalstatus);
}
public String getWall(int wallno)
{
String s = "SELECT wall FROM wall WHERE wall_no =" + wallno + "";
wall = DB.SelectSrting(s);
return(wall);
}
public String getSex(int sexno)
{
String s = "SELECT sex FROM sex WHERE sex_no =" + sexno + "";
sex = DB.SelectSrting(s);
return(sex);
}
public String getWaterSource(int watersourceno)
{
String s = "SELECT water_source FROM water_source WHERE water_source_no =" + watersourceno + "";
watersource = DB.SelectSrting(s);
return(watersource);
}