void kawasan() { DataSet Ds = new DataSet(); try { string com = "select DISTINCT Area_Code,Area_Name from Ref_Kawasan ORDER BY Area_Name"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); if (dt != null) { adpt.Fill(dt); DD_kaw.DataSource = dt; DD_kaw.DataTextField = "Area_Name"; DD_kaw.DataValueField = "Area_Code"; DD_kaw.DataBind(); DD_kaw.Items.Insert(0, new ListItem("--- PILIH ---", "")); } else { DD_kaw.Items.Insert(0, new ListItem("--- PILIH ---", "")); } } catch (Exception ex) { throw ex; } }