public DataTable RetrieveRoleByName(string name) { SqlCmdBuilder cmd = DataBaseHelpers.CreateCommand(); cmd.Query = @"SELECT * FROM ADP_ROLE WHERE NAMA_ROLE=@name"; cmd.AddParameter("name", SqlCmdParameterDirection.Input, name); return(cmd.GetTable()); }