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); }