private void RBAreaSearch_CheckedChanged(object sender, EventArgs e) { SearchCombo(@"SELECT distinct area.AREA_MST_NAME FROM GPS_FARM_LOCATION_MASTER as farm inner join AREA_MASTER as area on farm.GPS_FRM_LOC_AR_MST_CODE=area.AREA_MST_CODE order by AREA_MST_NAME", "AREA_MST_NAME"); CMBSearch.Focus(); }
private void RBCodeSearch_CheckedChanged(object sender, EventArgs e) { SearchCombo(@"SELECT mast.FAR_HDR_MST_CODE FROM GPS_FARM_LOCATION_MASTER as farm inner join FARMER_HEADER_MASTER as mast on farm.GPS_FRM_HDR_MST_ID=mast.FAR_HDR_MST_FAR_NO order by FAR_HDR_MST_CODE", "FAR_HDR_MST_CODE"); CMBSearch.Focus(); }