this.ddlProvinces.DataValueField = "contact_type_id";
this.ddlProvinces.DataTextField = "contact_type_text";
Data.database = 1;
SqlConnection conn = Data.OpenConnection();
SqlCommand cmd = new SqlCommand("GetContactTypes", conn);
SqlDataReader r = cmd.ExecuteReader();
this.ddlProvinces.DataSource = r;
this.ddlProvinces.DataBind();
Data.CloseConnection(conn);