public FamilyRoles() { DataTable dt = null; using (FirebirdDBHelper db = new FirebirdDBHelper(util.strDBConn)) { try { dt = db.GetDataTableSP("GET_FAMILY_ROLE"); } catch (System.Data.SqlClient.SqlException e) { throw e; } } FamilyRole fr = new FamilyRole() { Fr_Idx = "0" , Fr_Name = util.LoadProjectResource("TEXT_CB_FIRSTFIELD", "COMMONRES", "").ToString() , Fr_Sort = "0" , Fr_Use = "1" }; _roles.Add(fr); foreach (DataRow myRow in dt.Rows) { fr = new FamilyRole() { Fr_Idx = myRow["o_fr_idx"].ToString() , Fr_Name = myRow["o_fr_name"].ToString() , Fr_Sort = myRow["o_fr_sort"].ToString() , Fr_Use = myRow["o_fr_use"].ToString() }; _roles.Add(fr); } }